String sql = "insert into PetInfo(pet_name,pet_sex,pet_strength,pet_cute," +
" pet_love,pet_intro,pet_Owner_email,pet_owner_name,pet_password," +
" pet_pic,pet_type)" +
" values (?,?,?,?,?,?,?,?,?,?,?);select @@identity";
pstmt = conn.prepareStatement(sql);
// 设置参数值
pstmt.setString(index++, item.getPetName());
pstmt.setString(index++, item.getPetSex());
pstmt.setInt(index++, item.getPetStrength());
pstmt.setInt(index++, item.getPetCute());
pstmt.setInt(index++, item.getPetLove());
pstmt.setString(index++, item.getPetIntro());
pstmt.setString(index++, item.getPetOwnerEmail());
pstmt.setString(index++, item.getPetOwnerName());
pstmt.setString(index++, item.getPetPassword());
pstmt.setString(index++, item.getPetPic());
pstmt.setInt(index++, item.getPetType());
// 执行Sql
rs = pstmt.executeQuery();(提示没有返回结果集)
if (rs.next()){
item.setPetId(rs.getInt(1));
}
" pet_love,pet_intro,pet_Owner_email,pet_owner_name,pet_password," +
" pet_pic,pet_type)" +
" values (?,?,?,?,?,?,?,?,?,?,?);select @@identity";
pstmt = conn.prepareStatement(sql);
// 设置参数值
pstmt.setString(index++, item.getPetName());
pstmt.setString(index++, item.getPetSex());
pstmt.setInt(index++, item.getPetStrength());
pstmt.setInt(index++, item.getPetCute());
pstmt.setInt(index++, item.getPetLove());
pstmt.setString(index++, item.getPetIntro());
pstmt.setString(index++, item.getPetOwnerEmail());
pstmt.setString(index++, item.getPetOwnerName());
pstmt.setString(index++, item.getPetPassword());
pstmt.setString(index++, item.getPetPic());
pstmt.setInt(index++, item.getPetType());
// 执行Sql
rs = pstmt.executeQuery();(提示没有返回结果集)
if (rs.next()){
item.setPetId(rs.getInt(1));
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货