SQLite由浅入深
来源:互联网 发布:电脑淘宝直播在哪里看 编辑:程序博客网 时间:2024/05/17 05:02
1.怎样在数据库中一次插入多条数据?
DBHelper mDbHelper = new DBHelper(getApplication());
SQLiteDatabase db = mDbHelper.getWritableDatabase();
String sql = "insert into logtable(name,urls,dece)values('梨花','荷花','木槿'),"('月季','牡丹','菊花')";
db.execSQL(str);
2.怎样查找几条数据,但前几条跳过去?
SQLiteDatabase db = mHelper.getWritableDatabase();
String sql = "select * from logtable limit 1,2";//这个事查找两条数据这两条数据之前的一条跳过去。
String sql = "select * from logtable limit 1,2";//这个事查找两条数据这两条数据之前的一条跳过去。
Cursor c = db.rawQuery(sql, null);
3.怎样模糊查询之查询字段中包含“??”的数据?
//Cursor cccc=db.query("logtable", null, "name like '%"+88+"%'", null, null, null, null);
//Cursor cccc=db.query("logtable", null, "name like ?", new String[]{"%"+8+"%"} , null, null, null);
Cursor cccc=db.rawQuery("select * from logtable where name like '%"+"mlz"+"%'",null);
//Cursor cccc=db.query("logtable", null, "name like ?", new String[]{"%"+8+"%"} , null, null, null);
Cursor cccc=db.rawQuery("select * from logtable where name like '%"+"mlz"+"%'",null);
String[] selectioinArgs = {"%"+keyword+"%"};//注意:这里没有单引号
String sql = "select "+ TABLE_COLUMN_NAME +"," +TABLE_COLUMN_SYSTEM_NAME+ " from " + TABLE_NAME
+ " where " + TABLE_COLUMN_NAME + " like ? ";
Cursor cursor = db.rawQuery(sql,selectioinArgs);
String sql = "select "+ TABLE_COLUMN_NAME +"," +TABLE_COLUMN_SYSTEM_NAME+ " from " + TABLE_NAME
+ " where " + TABLE_COLUMN_NAME + " like ? ";
Cursor cursor = db.rawQuery(sql,selectioinArgs);
阅读全文
0 0
- SQLite由浅入深
- 正则由浅入深
- MakeFile由浅入深
- 由浅入深-string
- runtime 由浅入深
- JNI由浅入深
- Json由浅入深
- docker 由浅入深
- Glide由浅入深
- PS由浅入深
- SQLite
- SQLite
- SQLite
- SQLite
- SQLite
- sqlite
- sqlite
- SQLite
- jprobe
- Maven中添加Oracle11g JDBC驱动
- vjudge_contest15
- 微软Win10彻底封杀exFAT/FAT32磁盘,格式化只剩NTFS/REFS
- 关于libfacedetection解析及应用(待)
- SQLite由浅入深
- Tomcat maven 插件启动出现tomcat\conf\tomcat-users.xml cannot be read异常解决方法
- Java内存模型与GC
- A Story of Walden--The 13th MiniStory of AJ
- touchjs
- ~端口分类调研~
- Mybatis错误:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]
- 视频直播知识点(一)
- iptables防火墙相关命令