Hi to all..am new to android development.
i tried to insert two tables in my db.and want to show my tables as
two different spinner.when i tried with single table ,i got spinner
output nicely,but now am unable to do? pls point out my mistake
can any1 help.here is my data helper code..thanks i advance..
package Timer.Db;
import java.util.ArrayList;
import java.util.List;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteStatement;
import android.util.Log;
public class DataHelper
{
private static final String DATABASE_NAME = "EGRTimer.db";
private static final int DATABASE_VERSION = 1;
private static final String TABLE_NAME = "Timer_Config";
private static final String TIMER_TABLE_NAME="jangiri";
private Context Mycontext;
private SQLiteDatabase Mydb;
private SQLiteStatement insertStmt;
private static final String INSERT = "insert into "
+ TABLE_NAME +"(rid,rmins) values(?,?)";
private static final String TIMER_INSERT = "insert into "
+ TIMER_TABLE_NAME +"(Did,Dhrs,Dmins) values(?,?,?)";
public DataHelper(Context context)
{
this.Mycontext = context;
OpenHelper openHelper = new OpenHelper(this.Mycontext);
this.Mydb = openHelper.getWritableDatabase();
this.insertStmt = this.Mydb.compileStatement(INSERT);
this.insertStmt = this.Mydb.compileStatement(TIMER_INSERT);
}
public void insert(int rid,int rmins)
{
this.insertStmt.bindLong(1, rid);
this.insertStmt.bindLong(2, rmins);
for(int i=1;i<=60;i++)
{
this.insertStmt = this.Mydb.compileStatement(INSERT);
this.insertStmt.bindLong(1, i);
this.insertStmt.bindLong(2, i);
this.insertStmt.executeInsert();
}
}
public void insertCLOCK(int Did,int Dhrs,int Dmins)
{
this.insertStmt.bindLong(1, Did);
this.insertStmt.bindLong(2, Dhrs);
this.insertStmt.bindLong(3, Dmins);
for(int i=0;i<=23;i++)
{
for(int j=0;j<=45;j+=15)
{
int k = 0;k++;
this.insertStmt =
this.Mydb.compileStatement(TIMER_INSERT);
this.insertStmt.bindLong(1, k);
this.insertStmt.bindLong(2, i);
this.insertStmt.bindLong(3, j);
this.insertStmt.executeInsert();
}
}
}
public Cursor fetchAllOrders()
{
String query = "select from Timer_Configr;";
Cursor c = Mydb.rawQuery(query, null);
return c;
}
public void deleteAll()
{
this.Mydb.delete(TABLE_NAME, null, null);
this.Mydb.delete(TIMER_TABLE_NAME, null, null);
}
public List<String> selectAll()
{
List<String> list = new ArrayList<String>();
Cursor cursor = this.Mydb.query(TABLE_NAME, new String[]
{ "rid","rmins" },
null, null, null, null, null);
int rminsColumnIndex =
cursor.getColumnIndexOrThrow("rmins");
if (cursor.moveToFirst())
{
do {
list.add( cursor.getString(rminsColumnIndex));
}
while (cursor.moveToNext());
}
if (cursor != null && !cursor.isClosed())
{
cursor.close();
}
return list;
}
public List<String> getAll()
{
List<String> CLOCKlist = new ArrayList<String>();
Cursor cursor = this.Mydb.query(TIMER_TABLE_NAME, new String[]
{ "Did","Dhrs" ,"Dmins"},
null, null, null, null, null);
int DhrsColumnIndex = cursor.getColumnIndexOrThrow ("Dhrs");
int DminsColumnIndex = cursor.getColumnIndexOrThrow ("Dmins");
if (cursor.moveToFirst())
{
do {
CLOCKlist.add(cursor.getString(DhrsColumnIndex)
+":"+cursor.getString(DminsColumnIndex));
}
while (cursor.moveToNext());
}
if (cursor != null && !cursor.isClosed())
{
cursor.close();
}
return CLOCKlist;
}
private static class OpenHelper extends SQLiteOpenHelper
{
OpenHelper(Context context)
{
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db)
{
db.execSQL("CREATE TABLE " + TABLE_NAME + "(rid INTEGER
PRIMARY KEY, rmins INTEGER)");
db.execSQL("CREATE TABLE " + TIMER_TABLE_NAME + "(Did INTEGER
PRIMARY KEY, Dhrs INTEGER,Dmins INTEGER)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int
newVersion)
{
Log.w("Example", "Upgrading database, this will drop tables
and recreate.");
db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
db.execSQL("DROP TABLE IF EXISTS " + TIMER_TABLE_NAME);
onCreate(db);
}
}
}
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
