dbboards.java

天乙代码src_531.rar 天乙代码src_531.rar 天乙代码src_531.rar 天乙代码src_531.rar

      return Sys.RESULT_RIGHT;
    }
    catch (ObjectException e) {
      logger.error(e);
      return Sys.RESULT_OBJECTEXCEPTION;
    }
    finally {
      if (aTranContext == null && myDBTrans != null) {
        myDBTrans.freeCon();
      }
    }
  }

  public void loadDB(TranContext myDB, String key, boolean isLoad) throws
      ObjectException, ObjectNoExistException {
    try {
      if (key.equals("ID")) {
        myDB.prepareStatement(LOAD_BOARDS);
        myDB.setLong(1, this.myBoardsInfo.getID());
      }
      if (key.equals("NAME")) {
        myDB.prepareStatement(LOAD_BOARDS_BYNAME);
        myDB.setString(1, this.myBoardsInfo.getBoardsName());
      }
      rs = myDB.executeQuery();
      if (rs.next()) {
        if (isLoad) {
          this.myBoardsInfo.setID(rs.getLong("ID"));
          this.myBoardsInfo.setBoardID(rs.getLong("BoardID"));
          this.myBoardsInfo.setBoardsName(rs.getString("BoardsName"));
          this.myBoardsInfo.setBoardsEName(rs.getString("BoardsEName"));
          this.myBoardsInfo.setMainMaster(rs.getString("MainMaster"));
          this.myBoardsInfo.setAssiMaster(rs.getString("AssiMaster"));
          this.myBoardsInfo.setHideMaster(rs.getString("HideMaster"));
          this.myBoardsInfo.setExplain(rs.getString("Explains"));
          this.myBoardsInfo.setBulletin(rs.getString("Bulletin"));
          this.myBoardsInfo.setUseStat(rs.getInt("UseStat"));
          this.myBoardsInfo.setOrders(rs.getInt("Orders"));
          this.myBoardsInfo.setMainPostNum(rs.getInt("MainPostNum"));
          this.myBoardsInfo.setPostNum(rs.getInt("PostNum"));
          this.myBoardsInfo.setPic(rs.getString("Pic"));
          this.myBoardsInfo.setLastPostTitle(rs.getString("LastPostTitle"));
          this.myBoardsInfo.setLastPostID(rs.getLong("LastPostID"));
          this.myBoardsInfo.setLastPostUser(rs.getString("LastPostUser"));
          this.myBoardsInfo.setLastPostUserID(rs.getLong("LastPostUserID"));
          this.myBoardsInfo.setLastPostTime(rs.getLong("LastPostTime"));
          this.myBoardsInfo.setAttrib1(rs.getInt("Attrib1"));
          this.myBoardsInfo.setAttrib2(rs.getInt("Attrib2"));
          this.myBoardsInfo.setAttrib3(rs.getInt("Attrib3"));
          this.myBoardsInfo.setAttrib4(rs.getInt("Attrib4"));
          this.myBoardsInfo.setAttrib5(rs.getInt("Attrib5"));
          this.myBoardsInfo.setAttrib6(rs.getInt("Attrib6"));
          this.myBoardsInfo.setAttrib7(rs.getInt("Attrib7"));
          this.myBoardsInfo.setAttrib8(rs.getInt("Attrib8"));
          this.myBoardsInfo.setAttrib9(rs.getInt("Attrib9"));
          this.myBoardsInfo.setAttrib10(rs.getInt("Attrib10"));
          this.myBoardsInfo.setUserCanIn(rs.getString("UserCanIn"));
        }
      }
      else {
        throw new ObjectNoExistException();
      }
    }
    catch (SQLException e) {
      throw new ObjectException(e.toString());
    }
    finally {
      try {
        if (rs != null) {
          rs.close();
          rs = null;
        }
      }
      catch (SQLException e) {
      }
      try {
        if (myDB != null) {
          myDB.close();
        }
      }
      catch (SQLException e) {
      }
    }
  }

  public List loadDBs(TranContext myDB, String key) throws ObjectException {
    List alist = ListFactory.getInstance(2);
    try {
      if (key.equals("BID")) {
        myDB.prepareStatement(LOAD_BOARDS_BYBID);
        myDB.setLong(1, this.myBoardsInfo.getBoardID());
        rs = myDB.executeQuery();
      }
      if (key.equals("Elite")) {
        myDB.prepareStatement(LOAD_BOARDS_ELITE);
        myDB.setLong(1, this.myBoardsInfo.getBoardID());
        rs = myDB.executeQuery();
      }
      if (key.equals("All")) {
        myDB.prepareStatement(LOAD_ALLBOARDS);
        rs = myDB.executeQuery();
      }

      if (key.equals("UserBoardSave")) {
        String userBoardSave = this.myUserInfo.getBoardSave();
        if (userBoardSave == null || userBoardSave.length() == 0) {
          userBoardSave = "0";
        }
        if (userBoardSave.endsWith(",")) {
          userBoardSave = userBoardSave.substring(0, userBoardSave.length() - 1);
        }
        SQL = "select * from boards where ID in (" + userBoardSave +
            ") and UseStat = 1";
        myDB.prepareStatement(SQL);
        rs = myDB.executeQuery();
      }
      if (key.equals("BoardsList")) {
        String userCanInBoards = this.myUserInfo.getCanInBoards();
        if (userCanInBoards == null || userCanInBoards.length() == 0) {
          userCanInBoards = "0";
        }
        if (userCanInBoards.endsWith(",")) {
          userCanInBoards = userCanInBoards.substring(0,
              userCanInBoards.length() - 1);
        }
        SQL = "select * from boards where BoardID = ? and UseStat = 1 and (Attrib3 = 0 or (Attrib3 =1 and ID in(" +
            userCanInBoards + "))) order by Orders";
        myDB.prepareStatement(SQL);
        myDB.setLong(1, this.myBoardsInfo.getBoardID());
        rs = myDB.executeQuery();
      }
      if (key.equals("BoardListDst")) {
        String userCanInBoards = this.myUserInfo.getCanInBoards();
        if (userCanInBoards == null || userCanInBoards.length() == 0) {
          userCanInBoards = "0";
        }
        if (userCanInBoards.endsWith(",")) {
          userCanInBoards = userCanInBoards.substring(0,
              userCanInBoards.length() - 1);
        }
        SQL = "select * from boards where UseStat = 1 and Attrib1 = 0 and (Attrib3 = 0 or (Attrib3 =1 and ID in(" +
            userCanInBoards + "))) order by ID,Orders";
        myDB.prepareStatement(SQL);
        //DBSQL.setLong(1, myBoards.getBoardID());
        rs = myDB.executeQuery();
      }
      if (key.equals("BoardListDstSuper")) {
        SQL = "select * from boards where UseStat = 1 order by ID,Orders";
        myDB.prepareStatement(SQL);
        //DBSQL.setLong(1, myBoards.getBoardID());
        rs = myDB.executeQuery();
      }
      if (key.equals("bynum")) {
        String SQLStr =
            "select * from boards where UseStat = 1 and Attrib3 = 0 order by MainPostNum desc,PostNum desc";
        this.pages.setTotals(10);
        this.pages.doPageBreak();
        //this.sListPageBreak = this.pages.getListPageBreak();
        this.pages.setSQL(SQLStr);
        myDB.prepareStatement(this.pages.getSQLString("ID"));
        rs = myDB.executeQuery();
      }
      while (rs.next()) {
        myBoardsInfo = new BoardsInfo();
        myBoardsInfo.setID(rs.getLong("ID"));
        myBoardsInfo.setBoardID(rs.getLong("BoardID"));
        myBoardsInfo.setBoardsName(rs.getString("BoardsName"));
        myBoardsInfo.setBoardsEName(rs.getString("BoardsEName"));
        myBoardsInfo.setMainMaster(rs.getString("MainMaster"));
        myBoardsInfo.setAssiMaster(rs.getString("AssiMaster"));
        myBoardsInfo.setHideMaster(rs.getString("HideMaster"));
        myBoardsInfo.setExplain(rs.getString("Explains"));
        myBoardsInfo.setBulletin(rs.getString("Bulletin"));
        myBoardsInfo.setUseStat(rs.getInt("UseStat"));
        myBoardsInfo.setOrders(rs.getInt("Orders"));
        myBoardsInfo.setMainPostNum(rs.getInt("MainPostNum"));
        myBoardsInfo.setPostNum(rs.getInt("PostNum"));
        myBoardsInfo.setPic(rs.getString("Pic"));
        myBoardsInfo.setLastPostTitle(rs.getString("LastPostTitle"));
        myBoardsInfo.setLastPostID(rs.getLong("LastPostID"));
        myBoardsInfo.setLastPostUser(rs.getString("LastPostUser"));
        myBoardsInfo.setLastPostUserID(rs.getLong("LastPostUserID"));
        myBoardsInfo.setLastPostTime(rs.getLong("LastPostTime"));
        myBoardsInfo.setAttrib1(rs.getInt("Attrib1"));
        myBoardsInfo.setAttrib2(rs.getInt("Attrib2"));
        myBoardsInfo.setAttrib3(rs.getInt("Attrib3"));
        myBoardsInfo.setAttrib4(rs.getInt("Attrib4"));
        myBoardsInfo.setAttrib5(rs.getInt("Attrib5"));
        myBoardsInfo.setAttrib6(rs.getInt("Attrib6"));
        myBoardsInfo.setAttrib7(rs.getInt("Attrib7"));
        myBoardsInfo.setAttrib8(rs.getInt("Attrib8"));
        myBoardsInfo.setAttrib9(rs.getInt("Attrib9"));
        myBoardsInfo.setAttrib10(rs.getInt("Attrib10"));
        myBoardsInfo.setUserCanIn(rs.getString("UserCanIn"));
        alist.add(myBoardsInfo);
        myBoardsInfo = null;
      }

      return alist;
    }
    catch (SQLException e) {
      throw new ObjectException(e.toString());
    }
    finally {
      try {
        if (rs != null) {
          rs.close();
          rs = null;
        }
      }
      catch (SQLException e) {
      }
      try {
        if (myDB != null) {
          myDB.close();
        }
      }
      catch (SQLException e) {
      }
    }
  }

  public void insertDB(TranContext myDB) throws ObjectException {
    try {
      myDB.prepareStatement(INSERT_BOARDS);
      myDB.setLong(1, this.myBoardsInfo.getID());
      myDB.setLong(2, this.myBoardsInfo.getBoardID());
      myDB.setString(3, this.myBoardsInfo.getBoardsName());
      myDB.setString(4, this.myBoardsInfo.getBoardsEName());
      myDB.setString(5, this.myBoardsInfo.getMainMaster());
      myDB.setString(6, this.myBoardsInfo.getAssiMaster());
      myDB.setString(7, this.myBoardsInfo.getHideMaster());
      myDB.setString(8, this.myBoardsInfo.getExplain());
      myDB.setString(9, this.myBoardsInfo.getBulletin());
      myDB.setInt(10, this.myBoardsInfo.getUseStat());
      myDB.setInt(11, this.myBoardsInfo.getOrders());
      myDB.setInt(12, this.myBoardsInfo.getMainPostNum());
      myDB.setInt(13, this.myBoardsInfo.getPostNum());
      myDB.setString(14, this.myBoardsInfo.getPic());
      myDB.setInt(15, this.myBoardsInfo.getAttrib1());
      myDB.setInt(16, this.myBoardsInfo.getAttrib2());
      myDB.setInt(17, this.myBoardsInfo.getAttrib3());
      myDB.setInt(18, this.myBoardsInfo.getAttrib4());
      myDB.setInt(19, this.myBoardsInfo.getAttrib5());
      myDB.setInt(20, this.myBoardsInfo.getAttrib6());
      myDB.setInt(21, this.myBoardsInfo.getAttrib7());
      myDB.setInt(22, this.myBoardsInfo.getAttrib8());
      myDB.setInt(23, this.myBoardsInfo.getAttrib9());
      myDB.setInt(24, this.myBoardsInfo.getAttrib10());
      myDB.setString(25, this.myBoardsInfo.getUserCanIn());
      myDB.executeUpdate();

    }
    catch (SQLException e) {
      throw new ObjectException(e.toString());
    }
    finally {
      try {
        if (myDB != null) {
          myDB.close();
        }
      }
      catch (SQLException e) {
      }
    }
  }

  public void updateDB(TranContext myDB, String key) throws ObjectException {
    try {
      if (key.equals("Boards")) {
        myDB.prepareStatement(UPDATE_BOARDS);
        myDB.setString(1, this.myBoardsInfo.getBoardsName());
        myDB.setString(2, this.myBoardsInfo.getBoardsEName());
        myDB.setString(3, this.myBoardsInfo.getMainMaster());
        myDB.setString(4, this.myBoardsInfo.getAssiMaster());
        myDB.setString(5, this.myBoardsInfo.getHideMaster());
        myDB.setString(6, this.myBoardsInfo.getExplain());
        myDB.setString(7, this.myBoardsInfo.getBulletin());
        myDB.setInt(8, this.myBoardsInfo.getUseStat());
        myDB.setInt(9, this.myBoardsInfo.getOrders());
        myDB.setString(10, this.myBoardsInfo.getPic());
        myDB.setInt(11, this.myBoardsInfo.getAttrib1());
        myDB.setInt(12, this.myBoardsInfo.getAttrib2());
        myDB.setInt(13, this.myBoardsInfo.getAttrib3());
        myDB.setInt(14, this.myBoardsInfo.getAttrib4());
        myDB.setInt(15, this.myBoardsInfo.getAttrib5());
        myDB.setInt(16, this.myBoardsInfo.getAttrib6());
        myDB.setInt(17, this.myBoardsInfo.getAttrib7());
        myDB.setInt(18, this.myBoardsInfo.getAttrib8());
        myDB.setInt(19, this.myBoardsInfo.getAttrib9());
        myDB.setInt(20, this.myBoardsInfo.getAttrib10());
        myDB.setLong(21, this.myBoardsInfo.getID());
      }
      if (key.equals("LastPost")) {
        myDB.prepareStatement(UPDATE_BOARDS_LASTPOST);
        myDB.setString(1, this.myBoardsInfo.getLastPostTitle());
        myDB.setLong(2, this.myBoardsInfo.getLastPostID());
        myDB.setString(3, this.myBoardsInfo.getLastPostUser());
        myDB.setLong(4, this.myBoardsInfo.getLastPostUserID());
        myDB.setLong(5, this.myBoardsInfo.getLastPostTime());
        myDB.setLong(6, this.myBoardsInfo.getID());
      }
      if (key.equals("PostNum")) {
        myDB.prepareStatement(UPDATE_BOARDS_POSTNUM);
        myDB.setInt(1, this.myBoardsInfo.getMainPostNum());
        myDB.setInt(2, this.myBoardsInfo.getPostNum());
        myDB.setLong(3, this.myBoardsInfo.getID());
      }
      if (key.equals("PostMainNum")) {
        myDB.prepareStatement(UPDATE_BOARDS_POSTMNUM);
        myDB.setLong(1, this.myBoardsInfo.getID());
      }
      if (key.equals("PostNums")) {
        myDB.prepareStatement(UPDATE_BOARDS_POSTNUMS);
        myDB.setLong(1, this.myBoardsInfo.getID());
      }
      if (key.equals("DecPostMainNum")) {
        myDB.prepareStatement(UPDATE_BOARDS_DECPOSTMNUM);
        myDB.setLong(1, this.myBoardsInfo.getID());
      }
      if (key.equals("DecPostNums")) {
        myDB.prepareStatement(UPDATE_BOARDS_DECPOSTNUMS);
        myDB.setLong(1, this.myBoardsInfo.getID());
      }
      if (key.equals("PostNumAll")) {
        myDB.prepareStatement(UPDATE_BOARDS_POSTNUM_ALL);
        myDB.setInt(1, this.myBoardsInfo.getMainPostNum());
        myDB.setInt(2, this.myBoardsInfo.getPostNum());
        myDB.setLong(3, this.myBoardsInfo.getID());
      }
      if (key.equals("UserCanIn")) {
        myDB.prepareStatement(UPDATE_BOARDS_USERCANIN);
        myDB.setString(1, this.myBoardsInfo.getUserCanIn());
        myDB.setLong(2, this.myBoardsInfo.getID());
      }
      myDB.executeUpdate();
    }
    catch (SQLException e) {
      throw new ObjectException(e.toString());
    }
    finally {
      try {
        if (myDB != null) {
          myDB.close();
        }
      }
      catch (SQLException e) {
      }
    }
  }

  public void delDB(TranContext myDB, String key) throws ObjectException {
    try {
      myDB.prepareStatement(DELETE_BOARDS);
      myDB.setLong(1, this.myBoardsInfo.getID());
      myDB.executeUpdate();
      myDB.close();
    }
    catch (SQLException e) {
      throw new ObjectException(e.toString());
    }
    finally {
      try {
        if (myDB != null) {
          myDB.close();
        }
      }
      catch (SQLException e) {
      }
    }
  }

}