Tuesday, October 4, 2011

BlackBerry Sqlite Database Sample


import net.rim.device.api.database.Cursor;
import net.rim.device.api.database.Database;
import net.rim.device.api.database.DatabaseFactory;
import net.rim.device.api.database.Row;
import net.rim.device.api.database.Statement;
import net.rim.device.api.io.URI;
import net.rim.device.api.ui.component.Dialog;
import net.rim.device.api.ui.component.RichTextField;
import net.rim.device.api.ui.container.MainScreen;

public class database extends MainScreen {
Database sqliteDB;
URI uri;
public void base()
{
try{
uri = URI.create("file:///SDCard/Databases/sample/sample4.db");
sqliteDB = DatabaseFactory.create(uri);

Statement st = sqliteDB.createStatement("CREATE TABLE joke(name)");
st.prepare();
st.execute();
st.close();

 Statement st1 = sqliteDB.createStatement("INSERT INTO joke VALUES ('Thirumoorthy')");
st1.prepare();
st1.execute();
st1.close();
sqliteDB.close();


//add(new RichTextField("Status: Database was created and inserted the values successfully"));

}
catch (Exception e){
System.out.println(e.getMessage());
e.printStackTrace();
}
}

}

2 comments:

  1. Nice Tutorial For Beginners ! Keep on Writing.. New blogs. too.. Thanks..

    ReplyDelete
  2. Hy thiru did you have a sample code for blackberry webservice, server using php+mysql... client using bb java.. thanks

    ReplyDelete