materi CITECH FEST 2018

silakan download

Emulator AppInventor

silakan download

Kuis PTIK 9 November 2018

Silakan download soal berikut

Query 2

1. SELECT KBM.NIM,Mahasiswa.Nama,KBM.Nilai
FROM KBM, Mahasiswa
WHERE KBM.NIM=Mahasiswa.NIM

2. SELECT Mahasiswa.Nama,MataKuliah.Nama,KBM.Nilai
FROM Mahasiswa,MataKuliah,KBM
WHERE KBM.NIM=Mahasiswa.NIM AND KBM.KodeMK=MataKuliah.KodeMK

3. SELECT NIM,Nama, IIF(Nama="Budi","laki-laki","perempuan") AS JenisKelamin
FROM Mahasiswa

4. SELECT IIf(DATEDIFF("m",TanggalLahir,Now()) > 11,DATEDIFF("yyyy",TanggalLahir,Now()),"belum genap 1 tahun")
FROM Mahasiswa;

Materi Query Ms.Access

Buat tiga tabel

lakukan query berikut:
1. SELECT NIM, Nama FROM Mahasiswa
2. SELECT NIM, Nama, TanggalLahir AS Umur FROM Mahasiswa
3. SELECT * FROM Mahasiswa
4. SELECT * FROM Mahasiswa, MataKuliah, KBM
5. SELECT * FROM KBM LEFT JOIN MataKuliah ON KBM.KodeMK = MataKuliah.KodeMK
6. SELECT * FROM KBM RIGHT JOIN MataKuliah ON KBM.KodeMK = MataKuliah.KodeMK
7. SELECT * FROM KBM INNER JOIN MataKuliah ON KBM.KodeMK = MataKuliah.KodeMK
8. SELECT * FROM KBM, MataKuliah ORDER BY KBM.NIM, MataKuliah.KodeMK
9. SELECT NIM, Nama, (YEAR(NOW()) - YEAR(TanggalLahir)) AS Umur FROM Mahasiswa
10. SELECT NIM, Nama, IIF(Nama="nama mahasiswa tertentu", Nama, "bukan mahasiswa yang dicari") FROM Mahasiswa

11. SELECT NIM, Nama, DATEDIFF("yyyy",TanggalLahir,Now()) AS Umur FROM Mahasiswa
12. SELECT NIM, Nama, DATEDIFF("m",TanggalLahir,Now()) AS Umur FROM Mahasiswa

QUERY VB

Public Koneksi As New ADODB.Connection

Public Sub KoneksiDatabase()
On Error GoTo konekErr

If Koneksi.State = 1 Then Koneksi.Close
Koneksi.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\DBNILAI.mdb;Persist Security Info=False"
Exit Sub

konekErr:
    MsgBox "Gagal menghubungkan ke Database ! Kesalahan pada : " & Err.Description, vbCritical, "Peringatan"
End Sub


Private Sub Form_Load()
Dim kodecari As String
kodecari = "M1"
KoneksiDatabase
Adodc1.ConnectionString = Koneksi.ConnectionString
Adodc1.RecordSource = "SELECT * FROM MHS WHERE KodeMHS = '" & kodecari & "' "
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1
End Sub


Silakan download

Belajar Adapter (Daftar Kata) di Kamus

Layout daftarkata.xml
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout 
    xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent" >
<TextView
android:id="@+id/textView1"
android:layout_width="100sp"
android:layout_height="wrap_content"
android:layout_alignParentLeft="true"
android:layout_alignParentTop="true"
android:text = "Inggris"
android:textSize="20sp" />
<TextView
android:id="@+id/textView2"
android:layout_width="100sp"
android:layout_height="wrap_content"
android:layout_alignParentTop="true"
android:layout_toRightOf="@+id/textView1"
android:text = "Indonesia"
android:textSize="20sp" />
<TextView
android:id="@+id/textView3"
android:layout_width="100sp"
android:layout_height="wrap_content"
android:layout_alignParentTop="true"
android:layout_toRightOf="@+id/textView2"
android:text = "Jerman"
android:textSize="20sp" />
<ListView 
    android:id="@+id/list1" 
    android:layout_width="fill_parent"
android:layout_height="wrap_content" 
android:layout_weight = "1"
android:layout_alignParentLeft="true"
android:layout_below="@+id/textView1"/>
</RelativeLayout>

Layout untuk setiap item di ListView
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout
xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:orientation="horizontal"
android:paddingBottom="5sp"
android:paddingTop="5sp" >
<TextView
android:id="@+id/inggris"
android:layout_width="100sp"
android:layout_height="wrap_content"
android:layout_alignParentLeft="true" />
<TextView
android:id="@+id/indonesia"
android:layout_width="100sp"
android:layout_height="wrap_content"
android:layout_toRightOf="@+id/inggris" />
<TextView
android:id="@+id/jerman"
android:layout_width="100sp"
android:layout_height="wrap_content"
android:layout_toRightOf="@+id/indonesia" />
</RelativeLayout>

Class Controller untuk DaftaKata.java
import android.app.Activity;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
import android.widget.TextView;

public class DaftarKata extends Activity {
private DatabaseHelper dbhelper;
private SQLiteDatabase db = null;
private ListView listContent = null;
private Cursor kamusCursor = null;
CustomCursorAdapter adapter;

/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
dbhelper = new DatabaseHelper(this);
setContentView(R.layout.daftarkata);
listContent = (ListView) findViewById(R.id.list1);
isDataListView();
}
private void isDataListView() {
try {
db = dbhelper.getWritableDatabase();
kamusCursor = db.query("kamus", new String[] { "_id", "inggris",
"indonesia", "jerman" }, "_id>0", null, null, null, null);

/*
* Create an array to specify the fields we want to display in the
* list (only the 'inggris,indonesia,jerman' column in this case)
*/
String[] from = new String[] { "inggris", "indonesia", "jerman" };

/*
* and an array of the fields we want to bind those fieiplds to (in
* this case just the textView 'inggris,indonesia,jerman' from our new row.xml
* layout above)
*/
int[] to = new int[] { R.id.inggris, R.id.indonesia, R.id.jerman };

/* Now create a simple cursor adapter.. */
adapter = new CustomCursorAdapter(this, R.layout.row, kamusCursor,from, to);
listContent.setAdapter(adapter);
} catch (Exception e) {
e.printStackTrace();
} finally {
if (db != null && db.isOpen()) {
db.close();
}
}
}

@Override
public void onDestroy() {
super.onDestroy();
try {
kamusCursor.close();
} catch (Exception e) {
}
}

protected class CustomCursorAdapter extends SimpleCursorAdapter {
private int layout;
private LayoutInflater inflater;
private Context context;
public CustomCursorAdapter(Context context, int layout, Cursor c,
String[] from, int[] to) {
super (context, layout, c, from, to);
this.layout = layout;
this.context = context;
inflater = LayoutInflater.from(context);
}

@Override
public View newView(Context context, Cursor cursor, ViewGroup parent) {
Log.d("NewView", "*****xxx");
View v = inflater.inflate(R.layout.row, parent, false);
return v;
}

@Override
public void bindView(View v, Context context, Cursor c) {
// 1 is the column where you're getting your data from
String inggris = c.getString(1);
String jerman = c.getString(3);
String indonesia = c.getString(2);

/**
* Next set the name of the entry.
*/
TextView name_text = (TextView) v.findViewById(R.id.inggris);
TextView des_text = (TextView) v.findViewById(R.id.jerman);
TextView id_text = (TextView) v.findViewById(R.id.indonesia);
des_text.setText(jerman);
id_text.setText(indonesia);

if (name_text != null) {
name_text.setText(inggris);
}
}
}
}