Android操作SQLite的几个常见方法
来源:互联网 发布:李阳前妻kim现状 知乎 编辑:程序博客网 时间:2024/06/07 02:23
建立数据表
public void onCreate(SQLiteDatabase db) {
//拼接建立数据表的SQL语句
StringBuilder createNewsTable = new StringBuilder();
createNewsTable.append("create table ");
createNewsTable.append(NEWS_TAB);
createNewsTable.append("(");
createNewsTable.append(" id integer primary key autoincrement,");
createNewsTable.append(" title varchar(100) ,");
createNewsTable.append(" author varchar(100) ");
createNewsTable.append(")");
db.execSQL(createNewsTable.toString());
}
Android操作SQlite的几个常用方法:
//添加数据
public void addNews(String title,String author){
SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
String insertSQL="insert into "+MySQLiteOpenHelper.NEWS_TAB
+"(title,author) values(?,?)";
db.execSQL(insertSQL, new Object[]{title,author});
db.close();
}
//修给数据
public void updateNews(int id,String title,String author){
SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("title", title);
values.put("author", author);
db.update(MySQLiteOpenHelper.NEWS_TAB, values, " id = ?", new String[]{id+""});
db.close();
}
//删除数据
public void DelNews(int id){
SQLiteDatabase db=dbOpenHelper.getWritableDatabase();
db.delete(MySQLiteOpenHelper.NEWS_TAB, " id = ?", new String[]{id+""});
}
//通过游标查询数据
public ArrayList<News> findNews(){
ArrayList<News> list = new ArrayList<News>();
SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
Cursor cursor= db.query(MySQLiteOpenHelper.NEWS_TAB,
new String[]{"id","title","author"},
null,
null,
null,
null,
null);
while(cursor.moveToNext()){
int id=cursor.getInt(cursor.getColumnIndex("id"));
String title=cursor.getString(cursor.getColumnIndex("title"));
String author= cursor.getString(cursor.getColumnIndex("author"));
News n = new News();
n.setId(id);
n.setAuthor(author);
n.setTitle(title);
list.add(n);
}
cursor.close();
db.close();
return list;
}
}
public void onCreate(SQLiteDatabase db) {
//拼接建立数据表的SQL语句
StringBuilder createNewsTable = new StringBuilder();
createNewsTable.append("create table ");
createNewsTable.append(NEWS_TAB);
createNewsTable.append("(");
createNewsTable.append(" id integer primary key autoincrement,");
createNewsTable.append(" title varchar(100) ,");
createNewsTable.append(" author varchar(100) ");
createNewsTable.append(")");
db.execSQL(createNewsTable.toString());
}
Android操作SQlite的几个常用方法:
//添加数据
public void addNews(String title,String author){
SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
String insertSQL="insert into "+MySQLiteOpenHelper.NEWS_TAB
+"(title,author) values(?,?)";
db.execSQL(insertSQL, new Object[]{title,author});
db.close();
}
//修给数据
public void updateNews(int id,String title,String author){
SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("title", title);
values.put("author", author);
db.update(MySQLiteOpenHelper.NEWS_TAB, values, " id = ?", new String[]{id+""});
db.close();
}
//删除数据
public void DelNews(int id){
SQLiteDatabase db=dbOpenHelper.getWritableDatabase();
db.delete(MySQLiteOpenHelper.NEWS_TAB, " id = ?", new String[]{id+""});
}
//通过游标查询数据
public ArrayList<News> findNews(){
ArrayList<News> list = new ArrayList<News>();
SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
Cursor cursor= db.query(MySQLiteOpenHelper.NEWS_TAB,
new String[]{"id","title","author"},
null,
null,
null,
null,
null);
while(cursor.moveToNext()){
int id=cursor.getInt(cursor.getColumnIndex("id"));
String title=cursor.getString(cursor.getColumnIndex("title"));
String author= cursor.getString(cursor.getColumnIndex("author"));
News n = new News();
n.setId(id);
n.setAuthor(author);
n.setTitle(title);
list.add(n);
}
cursor.close();
db.close();
return list;
}
}
0 0
- Android操作SQLite的几个常见方法
- sqlite的几个常用方法
- sqlite的几个常用方法
- Android SQLite 最常用的几个类和那些方法
- Android Bitmap 常见的几个操作:缩放,裁剪,旋转,偏移
- Android Bitmap 常见的几个操作:缩放,裁剪,旋转,偏移
- git常见的几个操作
- android中操作SQLite常见错误
- android中操作SQLite常见错误
- android中操作SQLite常见错误
- Throwable的几个常见方法
- sqlite的一些常见操作语句
- 数据库 Sqlite的几个常用方法
- 数据库 Sqlite的几个常用方法
- Android中Sqlite的操作(SQLiteDataBase自带方法)
- sqlite常见操作
- 记几个常见的c文件操作
- android Sqlite数据库的操作
- AIX 5L安装启动说明书
- JavaScript绝句的小研究
- Android 软件测试日志文件抓取
- Oracle分析函数
- 入住csdn
- Android操作SQLite的几个常见方法
- PagerAdapter
- Ubuntu Server 命令行下的默认语言 中文乱码 菱形<转>
- hdu4731(字符串构造+找规律)
- ado.net、DataList、DetailsView、FormView、GridView、ListView、Repeater直观印象
- Linux文件名编码转换
- 关于android异步消息机制的描述图
- myeclipse10 配置python环境
- 怎么直接访问在WEB-INF下面的文件