public class InfoDao {
private DbUtils create;
public InfoDao(Context context) {
super();
create = DbUtils.create(context, "logininfo");
try {
create.createTableIfNotExist(Info.class);
} catch (DbException e) {
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) {
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();
}
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;
}
}