Blackberry java development allows to create a database on the device. There are many possible ways to create database. I have recently used Sqlite database for my application. Following is what I have done to use that with my application.
1) Create a database through through blackberry emulator. Following is the code to do that.
URI uri = URI.create("file:///SDCard/Databases/employee.db");
Database sqliteDB = DatabaseFactory.create(uri);
Statement st = sqliteDB.createStatement("CREATE TABLE Employee ("
+"ID INTEGER PRIMARY KEY,"
+"name TEXT,"
+"number TEXT,"
);");
st.prepare();
st.execute();
2) A db file will be created in the file system. Open that db file. Insert as many data as you need. I have been required to insert data like this. As I had a large number of records that i needed in db on start up time only. I have tried to insert data through java program only. But i was facing issue about memory consumption. If you don't have too many data you can insert run time.
3) Following is the code to retrieve data from database.
Statement st1 = sqliteDB.createStatement("select * from Employee;");
st1.prepare();
Cursor c = st1.getCursor();
Row r;
int count=0;
while (c.next()) {
r = c.getRow();
String name = r.getString(1);
}
If you have close database connection. You need to open the connection again before you go to retrieve data from the database.
sqliteDB = DatabaseFactory.open(uri);
This is just an example. Your implementation can be differ as per your requirement.
