Пример #1
0
  public static int getNextUploadNo() throws SQLException {

    Connection con = null;
    PreparedStatement pstmt = null;
    ResultSet rset = null;

    int nextPostNo = 0;

    try {
      con = DBUtil.getConnection();
      pstmt = con.prepareStatement("SELECT max(dkswUploadNo) FROM dksw_upload");
      rset = pstmt.executeQuery();

      rset.next();
      nextPostNo = rset.getInt(1) + 1;

      return nextPostNo;

    } catch (SQLException se) {
      se.printStackTrace();
      throw se;

    } finally {
      try {
        DBUtil.close(con, pstmt, rset);
      } catch (SQLException sqle) {
        sqle.printStackTrace();
      }
    }
  }
Пример #2
0
  public static int addUploadFile(
      int inputUploadCategory,
      int inputUploadPostNo,
      long inputUploadDate,
      int inputMemberNo,
      String inputUploadFileName,
      String inputUploadFileSrc)
      throws SQLException {

    Connection con = null;
    PreparedStatement pstmt = null;
    ResultSet rset = null;

    int check = 0;

    try {
      con = DBUtil.getConnection();

      pstmt =
          con.prepareStatement(
              "INSERT INTO dksw_upload("
                  + "dkswUploadCategory, dkswUploadPostNo, dkswUploadDate, dkswMemberNo, dkswUploadFileName, dkswUploadFileSrc"
                  + ") values(?, ?, ?, ?, ?, ?)");

      pstmt.setInt(1, inputUploadCategory);
      pstmt.setInt(2, inputMemberNo);
      pstmt.setLong(3, inputUploadDate);
      pstmt.setInt(4, inputMemberNo);
      pstmt.setString(5, inputUploadFileName);
      pstmt.setString(6, inputUploadFileSrc);
      check = pstmt.executeUpdate();

      return check;

    } catch (SQLException se) {
      se.printStackTrace();
      throw se;

    } finally {
      try {
        DBUtil.close(con, pstmt, rset);
      } catch (SQLException sqle) {
        sqle.printStackTrace();
      }
    }
  }
Пример #3
0
  public static Upload getFile(int inputUploadNo) throws SQLException {

    Connection con = null;
    PreparedStatement pstmt = null;
    ResultSet rset = null;

    Upload file = null;

    try {
      con = DBUtil.getConnection();
      pstmt = con.prepareStatement("SELECT * FROM dksw_upload WHERE dkswUploadNo=?");
      pstmt.setInt(1, inputUploadNo);
      rset = pstmt.executeQuery();

      if (rset.next()) {
        file =
            new Upload(
                rset.getInt(1),
                rset.getInt(2),
                rset.getInt(3),
                rset.getLong(4),
                rset.getInt(5),
                rset.getString(6),
                rset.getString(7));
      }

      return file;

    } catch (SQLException se) {
      se.printStackTrace();
      throw se;

    } finally {
      try {
        DBUtil.close(con, pstmt, rset);
      } catch (SQLException sqle) {
        sqle.printStackTrace();
      }
    }
  }