SqliteDatabase 对多个表增删改查

在创建数据库时需要创建多张表，并对他们进行增删改查

一：建立社区里特帮助类，继承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