membuat database dengan ADT

Buat Project Baru

Desain interface baru untuk tampilan awal program

Buat Layout baru dengan nama create data dengan tampilan seperti berikut :

4.Buat Class baru pada folder src dengan nama createData,tuliskan coding seperti di bawah ini:

package com.example.dbandroid;


import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;


public class createData extends Activity implements OnClickListener {
private Button Submit;
private EditText nama,merk,harga;
private DBDataSource datasource;
@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.createdata);

Submit=(Button) findViewById(R.id.btnSubmit);
Submit.setOnClickListener(this);
nama=(EditText) findViewById(R.id.txtnama);
merk=(EditText) findViewById(R.id.txtmerk);
harga=(EditText) findViewById(R.id.txtharga);

datasource=new DBDataSource(this);
datasource.open();
}
public void onClick(View arg0){
String nm=null;
String mk=null;
String hrg=null;

Barang barang=null;

if(nama.getText()!=null&&merk.getText()!=null && harga.getText()!=null){
nm=nama.getText().toString();
mk=merk.getText().toString();
hrg=harga.getText().toString();
}
switch(arg0.getId())
{
case R.id.btnSubmit:
barang=datasource.createBarang(nm,mk,hrg);
Toast.makeText(this, "masuk Barang\n"+
"nama"+barang.getNama_barang()+
"merk"+barang.getMerk_barang()+
"harga"+barang.getHarga_barang(),
Toast.LENGTH_LONG).show();
break;
}

}

}
5.Buat class baru dengan nama dbHelper,dan tuliskan coding berikut :
package com.example.dbandroid;


import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;


public class dbHelper extends SQLiteOpenHelper {
public static final String TABLE_NAME="data_inventory";
public static final String COLOUMN_ID="_id";
public static final String COLOUMN_NAME="nama_barang";
public static final String COLOUMN_MERK="merk_barang";
public static final String COLOUMN_HARGA="harga_barang";
private static final String db_name="inventory.db";
private static final Integer db_version=1;

private static final String db_create="create table"
+TABLE_NAME+"("
+COLOUMN_ID+"integer primary key autoincrement,"
+COLOUMN_NAME+"varchar(50) not null,"
+COLOUMN_MERK+"varchar(50) not null,"
+COLOUMN_HARGA+"varchar(50) not null);";

public dbHelper(Context sia){
super(sia,db_name,null,db_version);
}
public void onCreate(SQLiteDatabase db){
db.execSQL(db_create);
}
public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){
Log.w(dbHelper.class.getName(),"Upgrading database from"+
oldVersion+"to"+newVersion+"which will destroy all old data");
db.execSQL("Drop Table If Exists"+TABLE_NAME);
onCreate(db);
}
}
6.Buat Class baru dengan namaDBDataSource dengan coding seperti berikut:
package com.example.dbandroid;


import android.content.ContentValues;
import android.content.Context;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;


public class DBDataSource {
private SQLiteDatabase database;
private dbHelper dbHelper;

private String[] allcolomns={
dbHelper.COLOUMN_ID,
dbHelper.COLOUMN_NAME,
dbHelper.COLOUMN_MERK,
dbHelper.COLOUMN_HARGA
};

public DBDataSource(Context c){
dbHelper=new dbHelper(c);
}
public void open()throws SQLException{
database=dbHelper.getWritableDatabase();
}
public void close(){
dbHelper.close();
}
public Barang createBarang(String nm,String mk,String hrg){
ContentValues values=new ContentValues();
values.put(dbHelper.COLOUMN_NAME, nm);
values.put(dbHelper.COLOUMN_MERK, mk);
values.put(dbHelper.COLOUMN_HARGA, hrg);

long insertId=database.insert(dbHelper.TABLE_NAME,null, values);
Cursor cursor=database.query(distinct, table, columns, selection, selectionArgs, groupBy, having, orderBy, limit, cancellationSignal)
}

}