Dbutils 创建数据库

来源：互联网发布：c 游戏编程教程编辑：程序博客网时间：2024/05/16 11:29

public class InfoDao {    private DbUtils create;    public InfoDao(Context context) {        super();        //建库        create = DbUtils.create(context, "logininfo");        try {            //建表            create.createTableIfNotExist(Info.class);        } catch (DbException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }    }//添加    public void add(Info info) {        try {            create.save(new Info(info.getId(), info.getUser(), info.getPwd(),                    info.getPnum(), info.getEmail()));        } catch (DbException e) {            e.printStackTrace();        }    }    //查询    public List<Info> query(String name) {        List<Info> list=new ArrayList<Info>();        try {            list=create.findAll(Selector.from(Info.class).where("user","like","%"+name+"%"));        } catch (DbException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        return list;    }}

package com.bwie.bean;import com.lidroid.xutils.db.annotation.Table;//改名@Table(name="user")public class Info {    private int id;    private String user;    private String pwd;    private String pnum;    private String email;    public Info() {        super();        // TODO Auto-generated constructor stub    }    public Info(int id, String user, String pwd, String pnum, String email) {        super();        this.id = id;        this.user = user;        this.pwd = pwd;        this.pnum = pnum;        this.email = email;    }    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public String getUser() {        return user;    }    public void setUser(String user) {        this.user = user;    }    public String getPwd() {        return pwd;    }    public void setPwd(String pwd) {        this.pwd = pwd;    }    public String getPnum() {        return pnum;    }    public void setPnum(String pnum) {        this.pnum = pnum;    }    public String getEmail() {        return email;    }    public void setEmail(String email) {        this.email = email;    }    @Override    public String toString() {        return "姓名:"+user+"\n电话号码："+pnum+"\n邮箱："+email;    }}

0 0