%@ page contentType="text/html;charset=euc-kr" %>
<%@ include file="/include/in_Import.jsp" %>
<%@ include file="/include/in_Function.jsp" %>
<%
String menuId = request.getParameter("menuId");
if(menuId == null || menuId.equals("")) menuId = "33";
String tuksik = "";
String printTuksik = "";
String menuCnt = "14"; // ¸Þ´º°¹¼ö (¸Þ´ºÁ¶Á¤½Ã °¹¼ö ¸¶ÃçÁÖ¼¼¿ä)
%>
<%
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
StringBuffer query = new StringBuffer();
query.append(" SELECT * FROM COMMON_CODE WHERE GROUP_ID = '001' ");
conn = DriverManager.getConnection("jdbc:jdc:jdcpool");
stmt = conn.createStatement();
rs = stmt.executeQuery(query.toString());
while(rs.next()) {
tuksik = rs.getString(5);
printTuksik = rs.getString(5);
}
if(tuksik != null) {
String tmpTuksik = tuksik;
int tuksikLength = tuksik.length();
int loolp = tuksikLength/3;
int namuji = tuksikLength%3;
if(tuksikLength > 3) {
if(namuji >0) {
tuksik = tmpTuksik.substring(0,namuji)+",";
tmpTuksik = tmpTuksik.substring(namuji,tmpTuksik.length());
}
for(int i = 0; loolp > i; i++) {
tuksik += tmpTuksik.substring(0,3);
tmpTuksik = tmpTuksik.substring(3,tmpTuksik.length());
if(loolp != (i+1)) tuksik += ",";
}
}
}
%>
<%@ page contentType="text/html;charset=euc-kr" %>