// 查找单个项目
public Girl queryOne(Integer id) throws SQLException {
Connection conn = DBUtil.getConnection();
Girl g = null;
String sql = "" + "select * from girls where id=?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, id);
ResultSet rs = ps.executeQuery();
while(rs.next()){
g = new Girl();
g.setId(rs.getInt("id"));
g.setSex(rs.getInt("sex"));
g.setBirthday(rs.getDate("birthday"));
g.setUser_name(rs.getString("user_name"));
g.setAge(rs.getInt("age"));
g.setEmail(rs.getString("email"));
g.setMobile(rs.getString("mobile"));
g.setCreate_date(rs.getDate("create_date"));
g.setCreate_user(rs.getString("create_user"));
g.setUpdate_date(rs.getDate("uptate_date"));
g.setUpdate_user(rs.getString("uptate_user"));
g.setIsdel(rs.getInt("isdel"));
}
return g;
}
public class GirlAcition {
public static void main(String[] args) throws Exception {
GirlDao gd = new GirlDao();
// Girl g1 = new Girl();
// g1.setUser_name("小花");
// g1.setAge(15);
// g1.setSex(0);
// g1.setBirthday(new Date());
// g1.setEmail("qwer@qq.com");
// g1.setMobile("13556781290");
// g1.setCreate_user("Admin");
// g1.setUpdate_user("Admin");
// g1.setUpdate_user("BNBNBN");
// g1.setIsdel(1);
// g1.setId(2);
//添加
//gd.addGirl(g1);
//List<Girl> gs = new ArrayList<Girl>();
//查询所有
//gs = gd.query();
//for(Girl girl : gs){
// System.out.println(girl.getUser_name() + girl.getAge());
//}
//修改
//gd.updateGirl(g1);
//删除
//gd.delGirl(5);
//查询单个女生
Girl oneGirl = gd.queryOne(2);
System.out.println(oneGirl.toString());
}
}
原来是我把update写成了uptate 好二逼啊 找了俩小时的错误
图片发错了