SQLite
andli0726
这个作者很懒,什么都没留下…
展开
-
简单的增删改查
数据库代码 public class DBHelper { public static final String DB_NAME = "opinion_db"; public static final String TABLE_NANE = "opinion_table"; public static final int VERSION = 3; public static ...原创 2011-10-02 10:25:34 · 112 阅读 · 0 评论 -
建表语句
db.execSQL("create table cs_qw_zhankouwpdetail(" // + "rowguid nvarchar,"// + "zkguid nvarchar,"// 暂扣物品的rowguid + "name nvarchar,"// 物品名称(必填) + "num nvarchar,"// 数量(必填) ...原创 2012-03-21 20:53:06 · 74 阅读 · 0 评论 -
DBOpenHelp
package com.lilin.sqlite.db; import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import android.database.sqlite.SQL...原创 2012-03-22 23:02:13 · 129 阅读 · 0 评论 -
DBHelp
package com.lilin.sqlite.db; /** * @Project: SQLiteDemo * @Title: DBHelp.java * @Package com.lilin.sqlite.db * @Description: deal db * @author lilin andlil@163.com * @date 2012-3-2...原创 2012-03-22 23:03:49 · 145 阅读 · 0 评论 -
ConfigDBHelp
/** * @Project: SQLiteDemo * @Title: ConfigDBHelp.java * @Package com.lilin.sqlite.db * @Description: do config table * @author lilin andlil@163.com * @date 2012-3-22 下午09:18:56...原创 2012-03-22 23:04:53 · 70 阅读 · 0 评论 -
初始化方法
<!-- 应用名称 --> <string name="app_name">sqlitedemo</string> <!-- 数据库名称 --> <string name="db_name">sqlite_db</string> <!-- 备原创 2012-03-22 23:31:15 · 77 阅读 · 0 评论 -
事务的使用
// 保存同步过来的User数据 public static void setUserList_YC(Context con, List<User> ulist) { long beginTime = System.currentTimeMillis(); DatabaseHelper dbhelper = new DatabaseHelper(con, con.get...原创 2012-03-22 23:39:02 · 109 阅读 · 0 评论