JDBC增删改查(三)

return DBUtil.execute(sql);

}

public boolean delete(int id) {

String sql = "delete from customer where id=" + id;

return DBUtil.execute(sql);

}

public List query(Customer c){

List> values=DBUtil.executeQuery(Customer.makeSql(c));

return Customer.fillList(values);

}

public ExistsStatus findById(int id) {

Customer c=new Customer();

c.setId(id);

List list =query(c);

ExistsStatus result = new ExistsStatus();

if (list.size() > 0) {

Customer customer =list.get(0);

result.setT(customer);

result.setExists(true);

}

return result;

}

public PageBean getPage(Customer c,int pageId,int pageSize){

String sql=Customer.makeSql(c);

PageBean> page=DBUtil.executePage(sql,pageId,pageSize);

PageBean result=new PageBean();

result.setPageId(page.getPageId());

result.setPageTotal(page.getPageTotal());

result.setPageContent(Customer.fillList(page.getPageContent()));

return result;

}

}

public class Test {

public static void main(String[] args) {

String sql = "select * from customer ";

int pageSize = 3;

int pageId = 2;

PageBean> pageBean=DBUtil.executePage(sql, pageSize,pageId);

List> list = pageBean.getPageContent();

System.out.println(sql);

System.out.println(list.size());

for (int i = 0; i < list.size(); i++) {

Map map = list.get(i);

Integer id = (Integer) map.get("id");

String username = (String) map.get("username");

String password = (String) map.get("password");

System.out.println(id + " " + username + " " + password);

}

}

}

本文出自 “体系架构” 博客