[´äº¯] ÇÑ ÁÙÀ» Ãß°¡ÇØ º¸¼¼¿ä.


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]

±Û¾´ÀÌ :±èÇÊÈ£ 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);
}
}




´ÙÀ½ ±Ûµé:



À̾ ±Û¿Ã¸®±â(´äÇϱâ)

À̸§:
E-Mail:
Á¦¸ñ:
³»¿ë:
°ü·Ã URL(¼±ÅÃ):
URL Á¦¸ñ(¼±ÅÃ):
°ü·Ã À̹ÌÁö URL:


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]