۱۳۹۴/۰۶/۲۲, ۰۱:۴۹ ب.ظ
کد پیاچپی:
public class DataBaseManager extends SQLiteOpenHelper {
public DataBaseManager(Context context) {
super(context, "DbOstanInfo", null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String query = " CREATE TABLE tbl_ostan ( " +
" id INT PRIMARY KEY " +
" UNIQUE, " +
" ostan TEXT " +
"); ";
db.execSQL(query);
query = "CREATE TABLE tbl_kharid ( " +
" id INT PRIMARY KEY " +
" UNIQUE," +
" markaznam TEXT " +
" );";
db.execSQL(query);
}
@Override
public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) {
// TODO Auto-generated method stub
db.execSQL("DROP TABLE IF EXISTS tbl_ostan");
db.execSQL("DROP TABLE IF EXISTS tbl_kharid");
onCreate(db);
}
public boolean update_markaz_buy(MarkazBuy m) {
boolean r;
String query = " UPDATE tbl_kharid SET markaznam =" + m.markazbuy + " WHERE id =" + m.id + " ;";
try {
SQLiteDatabase db = this.getWritableDatabase();
db.execSQL(query);
db.close();
r = true;
}
catch (Exception e) {
r = false;
}
return r;
}
public boolean update_info_ostan(Ostan ostan) {
boolean r;
String query = " UPDATE tbl_ostan SET ostan= " + ostan.TOZIHAT + " WHERE id= " + ostan.ID + ";";
try {
SQLiteDatabase db = this.getWritableDatabase();
db.execSQL(query);
db.close();
r = true;
}
catch (Exception e) {
r = false;
}
return r;
}
}