게시판을 이용해 주셔서 감사합니다.
다음양식에 맞게 입력해주세요.

* 고객시스템명 : 대전도시공사
* GAUCE 버전 : 5.2
* WAS 종류(WebLogic 등등) : 톰캣
* DB 종류 : 오라클
* 문의 유형(질문/요청/참조) : clob처리문제
* 내용 :
                        conn = CITConnectionManager.getConnection(false);
                        
                        String strPARA1 = CITCommon.toKOR(request.getParameter("PARA1"));                // 지표레벨
                        String strPARA2 = CITCommon.toKOR(request.getParameter("PARA2"));                // 상위지표코드

                        strSql  = "SELECT 상위지표코드,지표명,지표코드  FROM TB18_경영평가지표 WHERE 지표레벨 = 2 AND 상위지표코드 = ? ";
                        
                        // content 내용 불러오기(S)

                        System.out.println("============="+strSql);
                                pstmt = conn.prepareStatement(strSql);
                                
                                lrDataset = new GauceDataSet();
                                GauceInfo.response.enableFirstRow(lrDataset);
                                lrDataset.addDataColumn(new GauceDataColumn("지표명", GauceDataColumn.TB_STRING));
                                lrDataset.addDataColumn(new GauceDataColumn("지표코드", GauceDataColumn.TB_STRING));
                                lrDataset.addDataColumn(new GauceDataColumn("URL", GauceDataColumn.TB_STRING, 255));
                                lrDataset.addDataColumn(new GauceDataColumn("URL_INFO", GauceDataColumn.TB_URL, 255));
                                
                        //pstmt.setInt(1,Integer.parseInt(strPARA1));
                        pstmt.setString(1,strPARA2);
                                System.out.println("=======444======");
                                
                        
                        try{
                                
                                rs = pstmt.executeQuery();
                                  if(rs != null)
                                  {                                
                                        while(rs.next()) {
                                                  GauceDataRow row = lrDataset.newDataRow();  
                                                  row.addColumnValue(rs.getString("지표명"));
                                                  row.addColumnValue(rs.getString("지표코드"));
                                                  row.addColumnValue("select.jsp?PARA1=" + rs.getString("상위지표코드"));
                                                  row.addColumnValue("select.jsp?PARA1=" + rs.getString("상위지표코드"));
                                                  lrDataset.addDataRow(row);
                                         System.out.println("rs.getStri=="+rs.getString("지표명"));
                                                  
                                }
                                  }
                        lrDataset.flush();


참 전화했는데 안받으시는데 전화가능하시면 전화주세요.
010-8815-1015 조웅기