android 数据库sqlite的使用

android开发的过程中，不可避免的有需要存储数据的时候。


android的数据存取机制有很多，其中最重要的大概就是sqlite数据库了


sqlite 数据库是android自带的数据库。不需要任何别的插件。


sqlite的使用步骤大概有两步


<span style="color: #ff0000;">1.编写SQLiteOpenHelper类</span>


这个类用户封装数据库表的建立、数据库的获得等操作


<span style="color: #ff0000;">2.编写TableManager类</span>


这个类用户封装某个表的各种操作


1、SQLiteOpenHelper类


<!--more-->


[java]
public class MySqliteOpenHelper extends SQLiteOpenHelper {


public MySqliteOpenHelper(Context context, String name,
CursorFactory factory, int version) {
super(context, name, factory, version);
// TODO Auto-generated constructor stub
}


@Override
public void onCreate(SQLiteDatabase arg0) {
// TODO Auto-generated method stub
                //以下创建表的语句，执行括号中的sql语句，创建表。同一个数据库中的所有表都在这里创建，
arg0.execSQL("CREATE TABLE IF NOT EXISTS tb_Depot"
+ "(id interger PRIMARY KEY,DepotSite varchar,DepotAcreage interger,DepotPrice interger,Linkman varchar,Phone varchar,Content varchar)");
arg0.execSQL("CREATE TABLE IF NOT EXISTS tb_Freight"
+ "(id interger PRIMARY KEY,start varchar,terminal varchar,FreightType varchar,FreightWeight int,linkman varchar,phone varchar, content varchar)");
arg0.execSQL("CREATE TABLE IF NOT EXISTS tb_User"
+ "(id interger PRIMARY KEY,UserName varchar,UserPass varchar,CompanyName varchar,address varchar,phone varchar,email varchar,permission varchar)");
arg0.execSQL("CREATE TABLE IF NOT EXISTS tb_Chauffeur"
+ "(id interger primary key,ChauffeurName varchar,trucktype varchar,tel varchar,effectdate varchar,content varchar)");
arg0.execSQL("CREATE TABLE IF NOT EXISTS tb_Truck"
+ "(id interger primary key,TruckNumber varchar,TruckWeight varchar,TruckPrice varchar,Start varchar,Whither varchar,linkman varchar,phone varchar)");


}


@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
// TODO Auto-generated method stub
//如果需要用到更新数据库的话，在这里进行操作
}


}


[/java]


然后是封装了数据库表操作的manager类


[java]
public class DepotDBManager {
private MySqliteOpenHelper helper ;
private SQLiteDatabase db;


public DepotDBManager(Context context){
//实例化一个sqliteopenhelpr 类
helper = new MySqliteOpenHelper(context,"depot.db",null,1);
//获得一个可读写的数据库
db = helper.getWritableDatabase();
}


public void add(DepotValue depotValue){
//这是往表里增加数据的类,系统为我们封装好了一套工具，我们可以不用再写sql语句了
ContentValues newValues = new ContentValues();
newValues.put("Id", depotValue.getId());
newValues.put("DepotSite", depotValue.getDepotSite());
newValues.put("DepotAcreage", depotValue.getDepotAcreage());
newValues.put("DepotPrice", depotValue.getDepotPrice());
newValues.put("Linkman", depotValue.getLinkman());
newValues.put("Phone", depotValue.getPhone());
newValues.put("Content", depotValue.getContent());


db.insert("tb_Depot",null, newValues);
}


public List<DepotValue> query(){
//这是查询操作 返回值是一个封装了数据库表信息的value类的链表
ArrayList<DepotValue> depotvalues = new ArrayList<DepotValue>();
Cursor c=queryTheCursor();


while(c.moveToNext()){
DepotValue depot = new DepotValue();
depot.setId(c.getInt(c.getColumnIndex("id")));


depot.setDepotSite(c.getString(c.getColumnIndex("DepotSite")));
Log.i("chacuo","3332");
depot.setDepotAcreage(c.getInt(c.getColumnIndex("DepotAcreage")));
depot.setDepotPrice(c.getInt(c.getColumnIndex("DepotPrice")));
depot.setLinkman(c.getString(c.getColumnIndex("Linkman")));
depot.setPhone(c.getString(c.getColumnIndex("Phone")));
depot.setContent(c.getString(c.getColumnIndex("Content")));


depotvalues.add(depot);
Log.i("hahaha",depot.getId()+depot.getContent());
}
c.close();
return depotvalues;
}
public void deletebyid(int id){
db.execSQL("delete from tb_Depot where id="+id);
}
public Cursor queryTheCursor(){
Cursor c = db.rawQuery("select * from tb_Depot", null);
return c;
}
}
[/java]