搭建数据库 Msql

• 创建一个类继承SQLiteOpenHelper

package com.example.sqlit;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class Sqli extends SQLiteOpenHelper {

	public Sqli(Context context) {
		// (context 上下文, name 数据库名, factory 工厂 null, version 数据库级别 1)
		super(context, "bawei.db", null, 1);
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
		// 创建表execSQL("sql语句")
		db.execSQL("create table liu (id integer primary key autoincrement,name varchar(20),price varchar(20),address varchar(100))");
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO Auto-generated method stub

	}

}

• 创建Dao层

package com.example.sqldao;

import com.example.sqlit.Sqli;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class SqlDao {

	private SQLiteDatabase db;

	// 创建有参构造
	public SqlDao(Context context) {
		// 创建数据库对象
		Sqli sqli = new Sqli(context);
		// 获得数据库管理类
		db = sqli.getWritableDatabase();
	}

	// 添加
	public long insert(String table, String nullColumnHack, ContentValues values) {
		// (table 表名, nullColumnHack 列, values 值)
		return db.insert(table, nullColumnHack, values);
	}

	// 删除
	public long delete(String table, String whereClause, String[] whereArgs) {
		// (table 表名, whereClause 条件, whereArgs 条件值)
		return db.delete(table, whereClause, whereArgs);
	}

	// 修改
	public long updata(String table, ContentValues values, String whereClause,
			String[] whereArgs) {
		// (table 表名, values 值, whereClause 条件, whereArgs 条件值)
		return db.update(table, values, whereClause, whereArgs);
	}

	// 查询
	public Cursor query(String table, String[] columns, String selection,
			String[] selectionArgs, String groupBy, String having,
			String orderBy) {
		// (table 表名, columns null, selection 条件, selectionArgs 条件值, groupBy 分组,
		// having ..., orderBy 排序)
		return db.query(table, columns, selection, selectionArgs, groupBy,
				having, orderBy);
	}
}

• MainActivity

package com.example.lianxi10sql;

import java.util.ArrayList;

import com.example.adapter.BAdapter;
import com.example.bean.WuBean;
import com.example.sqldao.SqlDao;

import android.os.Bundle;
import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.ListView;
import android.widget.Toast;

public class MainActivity extends Activity implements OnClickListener {

	private SqlDao sqlDao;
	private int count = 1;

	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);

		findViewById(R.id.button1).setOnClickListener(this);
		findViewById(R.id.button2).setOnClickListener(this);
		findViewById(R.id.button3).setOnClickListener(this);
		findViewById(R.id.button4).setOnClickListener(this);

		sqlDao = new SqlDao(this);

	}

	@Override
	public void onClick(View v) {
		// TODO Auto-generated method stub
		switch (v.getId()) {
		case R.id.button1://添加
			ContentValues values = new ContentValues();
			values.put("name", "黛尔");
			values.put("price", "5600");
			values.put("address", "深圳");
			long insert = sqlDao.insert("liu", null, values);
			if(insert>0){
				Toast.makeText(MainActivity.this, "添加成功", 0).show();
			}
			break;
		case R.id.button2://删除
			count++;
			long delete = sqlDao.delete("liu", "id=?", new String[]{""+count});
			if(delete>0){
				Toast.makeText(MainActivity.this, "删除成功", 0).show();
			}
			break;
		case R.id.button3://修改
			ContentValues values2 = new ContentValues();
			values2.put("name", "联想");
			values2.put("price", "5700");
			values2.put("address", "广东");
			sqlDao.updata("liu", values2, "id=?", new String[]{"5"});
			break;
		case R.id.button4://查询
			ArrayList<WuBean>list=new ArrayList<WuBean>();
			Cursor query = sqlDao.query("liu", null, null, null, null, null, null);
			if(query.moveToFirst()){
				do{
					int id = query.getInt(query.getColumnIndex("id"));
					String name = query.getString(query.getColumnIndex("name"));
					String price = query.getString(query.getColumnIndex("price"));
					String address = query.getString(query.getColumnIndex("address"));
					list.add(new WuBean(id, name, price, address));
				}while(query.moveToNext());
			}
			query.close();
			ListView findViewById = (ListView) findViewById(R.id.listView1);
			findViewById.setAdapter(new BAdapter(this, list));
			break;
		}
	}
}