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
}
}
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);
}
}
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;
}
}
}