±Û¾´ÀÌ :±èÇÊÈ£ 1998³â 5¿ù 13ÀÏ 19:58:36
In Reply to: [Help me! ]jdbc ¹®Á¦°°Àºµ¥ ²ÀÁ» ¾ËÄÑ ÁÖ¼¼¿ä posted by ÀüÁø¹è on 1998³â 5¿ù 13ÀÏ 18:33:29:
¾Æ·¡ÀÇ °íÄ£ ¼Ò½ºÃ³·³ while ¹® Á÷Àü¿¡ ¹«Á¶°Ç ÇÑ ÁÙÀ» Ãß°¡ÇØ º¸¼¼¿ä.
°íÄ£ ¼Ò½º:
String sqlText = "select aa,bb,cc,dd " +
"from ee " +
"where ff='ff' " +
"order by aa";
PreparedStatement pstmt =
conn.prepareStatement(sqlText);
ResultSet rset = pstmt.executeQuery();
ResultSetMetaData rsmd = rset.getMetaData();
int numCols = rsmd.getColumnCount();
int dataType = 0;
rset.next(); // ¹«Á¶°Ç ÀÌ ÇÑ ÁÙÀ» Ãß°¡ !!
while (rset.next()) { <--- ¿ä±â¼ SQLException ¹ß»ý
// for one record
for (int i=1; i<=numCols; i++) {
dataType = rsmd.getColumnType(i);
sendElement(rset, rsmd.getColumnType(i),i);
}
}