±Û¾´ÀÌ :lucps 1999³â 9¿ù 09ÀÏ 20:27:31
In Reply to: JDBC driver¸¦... posted by °û¿øö on 1999³â 9¿ù 02ÀÏ 18:17:56:
°û¿øö´Ô, ÇØ°áÀÇ ±â¹Ì°¡ ÀüÇô º¸ÀÌÁö ¾Ê±º¿ä.
ÁöÀûÇϽŠºÎºÐÀ» üũÇÏ°í ¸î¹øÀÌ°í ´Ù½Ã ½ÃµµÇÏ¿´Áö¸¸ ¸¶Âù°¡ÁöÀÔ´Ï´Ù.
¿¹Á¦ ¼Ò½º(¾Æ·¡¿¡)·Î ¿À¶óŬ ¿¬°áÀ» ½ÃµµÇÏ¿´Áö¸¸ c:\>java ConnectÇÏ°í ½ÇÇà½ÃÅ°¸é ¿¡·¯µµ ³ªÁö ¾Ê´Âµ¥ ½ÇÇàÀ» ¸ØÃßÁö ¸øÇϴ±º¿ä.
Nt Server4.0, jdk1.2, Oracle7.3, jdbc thin driver ¸ðµÎ ÇÑ ÄÄÇ»ÅÍ¿¡ µÎ°í Å×½ºÆ®ÇÏ¿´½À´Ï´Ù. ¿Ö ÀڷḦ »Ñ¸®Áö ¸øÇÒ±î¿ä? ÀÚ¼¼ÇÑ ¼³¸í ºÎŹµå¸³´Ï´Ù.
import java.sql.*;
class Connect {
public static void main(String args[]) throws SQLException {
int i;
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@server:1521:ORCL");
Statement stmt = conn.createStatement();
String query = "select * from DEPT";
ResultSet rset = stmt.executeQuery(query);
ResultSetMetaData rsmd = rset.getMetaData();
int numCols = rsmd.getColumnCount();
System.out.println(query);
while(rset.next()) {
for (i=2; i<=numCols; i++) {
System.out.print(rset.getString(i));
System.out.print(" ");
}
System.out.println("");
}
rset.close();
}
}