CategoryDAO
1Connection 和执行接口都写在括号里面
查询excuteQuery();其他是excute()
2
如果查询结果只有 一条记录 用 if(rs.next())
如果查询结果有 多条记录 用 while(rs.next())
String sql = "update category set name= ? where id = ?";
List<Category> beans = new ArrayList<Category>();
String sql = "select * from Category order by id desc limit ?,? ";
这个还是要学习一下
public List<Category> list(int start, int count) {
List<Category> beans = new ArrayList<Category>();
String sql = "select * from Category order by id desc limit ?,? ";
try (Connection c = DBUtil.getConnection(); PreparedStatement ps = c.prepareStatement(sql);) {
ps.setInt(1, start);
ps.setInt(2, count);
//这两步合起来写比较好
ResultSet rs = ps.executeQuery();
while (rs.next()) {
Category bean = new Category();
int id = rs.getInt(1);
String name = rs.getString(2);
bean.setId(id);
bean.setName(name);
beans.add(bean);
}
} catch (SQLException e) {
e.printStackTrace();
}
return beans;
}