public boolean create(ItemMemberEntity entity) {
ItemMemberEntity imEntity = (ItemMemberEntity)entity;
boolean isSuccess = false;
String selectSql = "SELECT * FROM item_member WHERE member_id=?";
PreparedStatement preSmt = null;
ResultSet rs = null;
try {
preSmt = conn
.prepareStatement(selectSql,
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
preSmt.setInt(1, imEntity.getMember_id());
rs = preSmt.executeQuery();
if (!rs.next()) {
rs.moveToInsertRow();
rs.updateInt("member_id",imEntity.getMember_id());
rs.updateInt("consumptive_count",imEntity.getConsumptive_count());
rs.updateString("first_login_time",imEntity.getFirst_login_time());
rs.updateString("last_login_time",imEntity.getLast_login_time());
rs.updateInt("login_count",imEntity.getLogin_count());
rs.updateInt("read_count",imEntity.getRead_count());
rs.updateInt("integral",imEntity.getIntegral());
rs.updateBoolean("allow", imEntity.isAllow());
rs.updateInt("fill_value", imEntity.getFill_value());
rs.insertRow();
isSuccess = true;
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (preSmt != null) {
preSmt.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
return isSuccess;
}
是这段代码抛的错,但我已经设preSmt = conn.prepareStatement(selectSql, ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
咋还会有问题呢?
ItemMemberEntity imEntity = (ItemMemberEntity)entity;
boolean isSuccess = false;
String selectSql = "SELECT * FROM item_member WHERE member_id=?";
PreparedStatement preSmt = null;
ResultSet rs = null;
try {
preSmt = conn
.prepareStatement(selectSql,
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
preSmt.setInt(1, imEntity.getMember_id());
rs = preSmt.executeQuery();
if (!rs.next()) {
rs.moveToInsertRow();
rs.updateInt("member_id",imEntity.getMember_id());
rs.updateInt("consumptive_count",imEntity.getConsumptive_count());
rs.updateString("first_login_time",imEntity.getFirst_login_time());
rs.updateString("last_login_time",imEntity.getLast_login_time());
rs.updateInt("login_count",imEntity.getLogin_count());
rs.updateInt("read_count",imEntity.getRead_count());
rs.updateInt("integral",imEntity.getIntegral());
rs.updateBoolean("allow", imEntity.isAllow());
rs.updateInt("fill_value", imEntity.getFill_value());
rs.insertRow();
isSuccess = true;
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (preSmt != null) {
preSmt.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
return isSuccess;
}
是这段代码抛的错,但我已经设preSmt = conn.prepareStatement(selectSql, ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
咋还会有问题呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货