개발/jsp

jsp페이지에서 query 실행

솔이홀 2020. 2. 5. 14:59

<%
 StringBuffer SQLp = new StringBuffer();
 SQLp.append("SELECT TOP 1 SEQ, '', TITLE ");
 SQLp.append(" FROM T_D ");
 SQLp.append(" ORDER BY SEQ DESC  "); 
 Vector paramp = new Vector();
 String[][] listArrp = inrSql.executeSQLaa(SQLp, 1, 3, paramp);

 int cutStr = 0;
 
 for(int i=0; i < 1; i++) {
  if(listArrp[i][0] != null)
  { 
    cutStr = listArrp[i][1].length();
    if(cutStr > 20){
     cutStr = 20;
    }
   %>   
   <%=listArrp[i][2]%>
<%  }
 } %>