개발/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]%>
<% }
} %>