在创建数据库时需要创建多张表,并对他们进行增删改查
一:建立社区里特帮助类,继承SQLiteOpenHelper
public class SqlHelper extends SQLiteOpenHelper {
private static final String DB_NAME = "mydatabase.db";//库名
private static final int DB_VERSION = 1;//版本
private static final String PRIMATY_KEY = " INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT";//主键不为空自动增长
public SqlHelper(Context context) {
super(context, DB_NAME, null, DB_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
/** 创建表 */
String sql_user = "create table " + UserInfo_tb.TABLE_NAME + "("
+ UserInfo_tb._ID + " " + PRIMATY_KEY + ","
+ UserInfo_tb.USER_ID + " varchar(20),"
+ UserInfo_tb.USER_PSW + " varchar(20),"
+ UserInfo_tb.USER_REAL_NAME + " varchar(15), )";
String sql_device = "create table " + Device_tb.TABLE_NAME + "("
+ Device_tb._ID + " " + PRIMATY_KEY + ","
+ Device_tb.DEVICE_ID + " varchar(15)," + Device_tb.LAT
+ " double," + Device_tb.LNG + " double ) ";
String sql_fence = " create table " + Fence_tb.TABLE_NAM