sqllite数据库的应用，建数据库，建表，操作数据库。

SQLlite 数据库

新建一个数据库的方法：

//第一步：创建数据库user.db并在数据库中建表user
package cn.csdn.service;//包名

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

public class DatabaseHelper extends SQLiteOpenHelper {
 static String name="user.db";
 static int dbVersion=1;
 public DatabaseHelper(Context context) {
  super(context, name, null, dbVersion);
 }
 //只在创建的时候用一次
 public void onCreate(SQLiteDatabase db) {
  String sql="create table user(id integer primary key autoincrement,username varchar(20),password varchar(20),age integer,sex varchar(2))";
  db.execSQL(sql);
 }
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

 }

}

//第二步对新建的表的操作

package cn.csdn.service;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import cn.csdn.domain.User;

public class UserService {
 private DatabaseHelper dbHelper;
 public UserService(Context context){
  dbHelper=new DatabaseHelper(context);
 }
 
 //登录用
 public boolean login(String username,String password){
  SQLiteDatabase sdb=dbHelper.getReadableDatabase();
  String sql="select * from user where username=? and password=?";
  Cursor cursor=sdb.rawQuery(sql, new String[]{username,password});  
  if(cursor.moveToFirst()==true){
   cursor.close();
   return true;
  }
  return false;
 }
 //注册用
 public boolean register(User user){
  SQLiteDatabase sdb=dbHelper.getReadableDatabase();
  String sql="insert into user(username,password,age,sex) values(?,?,?,?)";
  Object obj[]={user.getUsername(),user.getPassword(),user.getAge(),user.getSex()};
  sdb.execSQL(sql, obj); 
  return true;
 }
}

 

//第三步其中User 的代码：

package cn.csdn.domain;

import java.io.Serializable;

public class User implements Serializable{
 private int id;
 private String username;
 private String password;
 private int age;
 private String sex;
 public User() {
  super();
  // TODO Auto-generated constructor stub
 }
 public User(String username, String password, int age, String sex) {
  super();
  this.username = username;
  this.password = password;
  this.age = age;
  this.sex = sex;
 }
 public int getId() {
  return id;
 }
 public void setId(int id) {
  this.id = id;
 }
 public String getUsername() {
  return username;
 }
 public void setUsername(String username) {
  this.username = username;
 }
 public String getPassword() {
  return password;
 }
 public void setPassword(String password) {
  this.password = password;
 }
 public int getAge() {
  return age;
 }
 public void setAge(int age) {
  this.age = age;
 }
 public String getSex() {
  return sex;
 }
 public void setSex(String sex) {
  this.sex = sex;
 }
 @Override
 public String toString() {
  return "User [id=" + id + ", username=" + username + ", password="
    + password + ", age=" + age + ", sex=" + sex + "]";
 }
 
}