la terre en paix, on y peut reposer son âme.

  SELECT                /*[COLLECTIONDAO.XML][COLLECTION.GETGDSLIST][20100329]*/
           TPDG.PLN_DISP_CLS_SEQ AS PLNDISPCLSSEQ, TPDG.PRIR AS GDSPRIR,
           TG.GDS_CD AS GDSCD, TG.GDS_NM AS GDSNM, TG.SALE_PRC AS SALEPRC,
           TSG.SHOP_GDS_CD AS SHOPGDSCD, TSG.DC_AMT AS DCAMT
      FROM TBL_PLN_DISP_GDS TPDG JOIN TBL_GDS TG ON TPDG.GDS_NO = TG.GDS_CD
           LEFT OUTER JOIN TBL_SHOP_GDS TSG ON TG.GDS_CD = TSG.GDS_CD
     WHERE TPDG.PLN_DISP_CLS_SEQ = #seq#
  ORDER BY TPDG.PRIR


SELECT                /*[COLLECTIONDAO.XML][COLLECTION.GETGDSLIST][20100329]*/
         TPDG.PLN_DISP_CLS_SEQ AS PLNDISPCLSSEQ, TPDG.PRIR AS GDSPRIR,
         TG.GDS_CD AS GDSCD, TG.GDS_NM AS GDSNM, TG.SALE_PRC AS SALEPRC,
         TSG.SHOP_GDS_CD AS SHOPGDSCD, TSG.DC_AMT AS DCAMT
    FROM TBL_PLN_DISP_GDS TPDG JOIN TBL_GDS TG ON TPDG.GDS_NO = TG.GDS_CD
         JOIN TBL_SHOP_GDS TSG ON TG.GDS_CD = TSG.GDS_CD
   WHERE TPDG.PLN_DISP_CLS_SEQ = #seq#
ORDER BY TPDG.PRIR

...
Connection con = null;
PreparedStatement pstmt = null;
...

try{
...(커넥션 얻기)
StringBuffer addCount = new StringBuffer();
addCount.append("update board set readcount = readcount+1 where num=?");
pstmt = con.prepareStatement(addCount.toString());
pstmt.setInt(1,num);
pstmt.executeUpdate();
...
}
...

이것은 누구나 아는 방법.
보통 글 번호에 따른 게시물을 읽는 코드와 같이 쓴다.(파라미터로 글 번호를 받기 때문에)