// 查找單個(gè)項(xiàng)目
?? ?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);
?? ??? ?//查詢單個(gè)女生
?? ??? ?Girl oneGirl = gd.queryOne(2);
?? ??? ?System.out.println(oneGirl.toString());
?? ??? ?
?? ?}
}