Dbutils 创建数据库

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


}