コード例 #1
0
  /**
   * 说明:更新给定的部门对象
   *
   * @param con 数据库连接对象
   * @param source 部门对象
   * @throws LawyerException
   */
  public void updateDepartment(Connection con, Department source) throws LawyerException {
    String sql =
        "UPDATE "
            + DEPTABLE
            + " SET NAME=?,STATUS=?,SDATE=?,EDATE=?,REMARKS=?,PRINCIPAl=? WHERE ID='"
            + source.getId()
            + "' AND SYSID='"
            + source.getSysID()
            + "'";
    PreparedStatement psment = null;
    try {
      psment = con.prepareStatement(sql);
      // 清除参数
      psment.clearBatch();

      psment.setString(1, source.getName());
      psment.setString(2, source.getStatus());
      psment.setDate(
          3,
          null == source.getSdate()
              ? new java.sql.Date(new Date().getTime())
              : new java.sql.Date(source.getSdate().getTime()));
      psment.setDate(
          4,
          null == source.getEdate()
              ? new java.sql.Date(new Date().getTime())
              : new java.sql.Date(source.getEdate().getTime()));
      psment.setString(5, source.getRemarks());
      psment.setString(6, source.getPrincipal());

      psment.addBatch();

      // 执行数据库插入处理
      psment.execute();
    } catch (SQLException e) {
      throw new LawyerException("Update Department is error! " + e.getMessage());
    } finally {
      try {
        psment.close();
      } catch (SQLException e) {
      }
      psment = null;
    }
  }
コード例 #2
0
  /**
   * 说明:存储给定的部门对象
   *
   * @param con 数据库连接对象
   * @param source 部门对象
   * @throws LawyerException
   */
  public void saveDepartment(Connection con, Department source) throws LawyerException {
    String sql =
        "INSERT INTO "
            + DEPTABLE
            + "(ID,NAME,STATUS,SDATE,EDATE,REMARKS,PRINCIPAl,SYSID) VALUES(?,?,?,?,?,?,?,?)";
    PreparedStatement psment = null;
    try {
      psment = con.prepareStatement(sql);
      // 清除参数
      psment.clearBatch();

      psment.setString(1, source.getId());
      psment.setString(2, source.getName());
      psment.setString(3, source.getStatus());
      psment.setDate(
          4,
          null == source.getSdate()
              ? new java.sql.Date(new Date().getTime())
              : new java.sql.Date(source.getSdate().getTime()));
      psment.setDate(
          5,
          null == source.getEdate()
              ? new java.sql.Date(new Date().getTime())
              : new java.sql.Date(source.getEdate().getTime()));
      psment.setString(6, source.getRemarks());
      psment.setString(7, source.getPrincipal());
      psment.setString(8, source.getSysID());

      psment.addBatch();

      // 执行数据库插入处理
      psment.execute();
    } catch (SQLException e) {
      throw new LawyerException("Save Department is error! " + e.getMessage());
    } finally {
      try {
        psment.close();
      } catch (SQLException e) {
      }
      psment = null;
    }
  }