return result;
}
}
class Customer {
private int id;
private String username;
private String password;
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 static Customer fillMap(Map
Customer c = new Customer();
c.setId((Integer) values.get("id"));
c.setUsername((String) values.get("username"));
c.setPassword((String) values.get("password"));
return c;
}
public static List
List
for (int i = 0; i < values.size(); i++) {
result.add(fillMap(values.get(i)));
}
return result;
}
public static String makeSql(Customer c){
StringBuilder sql=new StringBuilder();
boolean whereExists=false;
sql.append("select * from customer ");
if(c.getId()>0){
sql.append(whereExists (" or id="+c.getId()):" where id="+c.getId());
if(!whereExists){whereExists=true;}
}
String username=c.getUsername();
if(username!=null&&!username.equals("")){
sql.append(whereExists (" or username like '%"+username)+"%'":" where username like '%"+username+"%'");
if(!whereExists){whereExists=true;}
}
String password=c.getPassword();
if(password!=null&&!password.equals("")){
sql.append(whereExists (" or password like '%"+password+"%'"):" where password like '%"+password+"%'");
if(!whereExists){whereExists=true;}
}
return sql.toString();
}
}
class ExistsStatus
private boolean exists;
private T t;
public boolean isExists() {
return exists;
}
public void setExists(boolean exists) {
this.exists = exists;
}
public T getT() {
return t;
}
public void setT(T t) {
this.t = t;
}
}
class PageBean
private List
private long pageId;
private long pageTotal;
public List
return pageContent;
}
public void setPageContent(List
this.pageContent = pageContent;
}
public long getPageId() {
return pageId;
}
public void setPageId(long pageId) {
this.pageId = pageId;
}
public long getPageTotal() {
return pageTotal;
}
public void setPageTotal(long pageTotal) {
this.pageTotal = pageTotal;
}
}
class CustomerDao {
public boolean insert(Customer customer) {
String sql = "insert into customer(username,password)values('"
+ customer.getUsername() + "','" + customer.getPassword()
+ "');";
return DBUtil.execute(sql);
}
public boolean update(Customer customer) {
String sql = "update customer set username='" + customer.getUsername()
+ "',passwor