示例#1
0
  public int addObjectReturnId(Connection conn, Leave bean) throws Exception {
    StringBuffer sql = new StringBuffer();
    sql.append("insert into t_leave (");
    sql.append("date,hours,reason,mark");
    sql.append(") values (");
    sql.append("?,?,?,?");
    sql.append(")");

    PreparedStatement ps = null;
    ResultSet rs = null;
    try {
      DatabaseMetaData dmd = conn.getMetaData();
      ps = conn.prepareStatement(sql.toString(), new String[] {"id"});
      ps.setDate(1, DateUtils.formatToSqlDate(bean.getDate()));
      ps.setDouble(2, bean.getHours());
      ps.setString(3, bean.getReason());
      ps.setString(4, bean.getMark());

      ps.execute();
      if (dmd.supportsGetGeneratedKeys()) {
        rs = ps.getGeneratedKeys();
        while (rs.next()) {
          bean.setId(rs.getInt(1));
        }
      }
    } catch (Exception e) {
      e.printStackTrace();
      throw e;
    }

    return bean.getId();
  }
示例#2
0
 @Override
 public Leave mapRow(ResultSet rs, int index) throws SQLException {
   Leave leave = new Leave();
   leave.setDate(rs.getDate("date"));
   leave.setHours(rs.getDouble("hours"));
   leave.setId(rs.getInt("id"));
   leave.setMark(rs.getString("mark"));
   leave.setReason(rs.getString("reason"));
   return leave;
 }