SQLite数据库是Android中自带的数据库
首先要自定义一个类继承SQLiteOpenHelper
public class MyHelp extends SQLiteOpenHelper {
public MyHelp(Context context) {
super(context, "student.db", null, 3);//第一个是版本,第二个是文件名,因为是数据库,所以db为扩展名,最后一个是版本号
// TODO Auto-generated constructor stub
}
@Override //创建数据库
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL("create table student(no String primary key,name varchar(20),sex verchar(20),age integer)");
}
@Override //这个是当数据库版本发生改变的时候,一般不去用它
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
自定义一个学生类,学生中的信息就自定义吧
在studentdao中,处理增删改查的方法
public class studentDao {
private MyHelp myhelp;
public studentDao(Context context) {
myhelp = new MyHelp(context);
}
public void createDB()
{
SQLiteDatabase db=myhelp.getWritableDatabase();//获得数据库的修改功能
}
public void addStudent(String no , String name ,String sex ,int age)
{
SQLiteDatabase db=myhelp.getWritableDatabase();
ContentValues values =new ContentValues();//存储键值对
values.put("no", no);
values.put("name", name);
values.put("sex", sex);
values.put("age", age);
db.insert("student", null, values);
db.close();
}
public void deleteStudent(String no)
{
SQLiteDatabase db=myhelp.getWritableDatabase();
db.delete("student", "no=?", new String[]{no});
db.close();
}
public void updateStudent(String no , String name , String sex,int age)
{
SQLiteDatabase db=myhelp.getWritableDatabase();
ContentValues values =new ContentValues();
values.put("name", name);
values.put("sex", sex);
values.put("age", age);
db.update("student", values,"no=?", new String[]{no});
db.close();
}
public void queryStudent(String no)
{
SQLiteDatabase db=myhelp.getWritableDatabase();
Cursor cs = db.query("student", null, "no = ?",new String[]{no}, null, null, null, null);
if(cs.moveToNext())
{
System.out.println(cs.getInt(0)+" "+cs.getInt(1)+" "+cs.getInt(2)+" "+cs.getInt(3));
}
else
{
System.out.println("查无此人");
}
cs.close();
db.close();
}
public ArrayList<Student> returnAll()
{
ArrayList<Student> list =new ArrayList<Student>();
SQLiteDatabase db=myhelp.getWritableDatabase();
Cursor cs = db.query("student", null, null, null, null, null, null, null);
while(cs.moveToNext())
{
Student stu = new Student(cs.getString(cs.getColumnIndex("no")),cs.getString(cs.getColumnIndex("name")),cs.getString(cs.getColumnIndex("sex")),cs.getInt(cs.getColumnIndex("age")));
list.add(stu);
stu=null;
}
cs.close();
db.close();
return list;
}
在MainActivity中
public class MainActivity extends Activity {
studentDao sd ;
TextView tv;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
tv = (TextView) findViewById(R.id.tv);
sd =new studentDao(this);
Random rd =new Random();
// 添加学生用来测试,注意不要添加重复的id值。因为那个设置为了关键字
// for(int i =1;i<=20;i++)
// {
// sd.addStudent(i+"", "zhangsan"+i, rd.nextBoolean()?"男":"女", i+10);
// }
sd.addStudent("30", "zhangsan", "男", 20);
}
public void add(View v)
{
sd.addStudent("26", "wangwu", "男", 23);
}
public void delete(View v)
{
sd.deleteStudent("1");
}
public void update(View v)
{
sd.updateStudent("2", "lucy", "女", 22);
}
public void query(View v)
{
ArrayList<Student> list = sd.returnAll();
tv.setText(list.toString());
}
}