ResultSetÀ» »ç¿ëÇØ¼ NorthwindÀÇ Products Å×ÀÌºí¿¡¼ProductID¿Í ProductNameÀ» ±¸ÇØ¿À´Â ¿¹Á¦
ResultSetTest.java
import java.sql.*;
public class ResultSetTest {
public static void main(String[] args) {
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String url = "sun.jdbc.odbc.JdbcOdbcDriver";
String dsn = "jdbc:odbc:jabook";
String id = "jabook";
String password = "password";
String sql = null;
try{
Class.forName(url);
con = DriverManager.getConnection(dsn, id, password);
stmt = con.createStatement();
sql = "select ProductID, ProductName from Products where CategoryID = 2 ";
rs = stmt.executeQuery(sql);
System.out.println("ResultSetÀÎÅÍÆäÀ̽ºÀÇ °´Ã¼ rs »ý¼º" + "\n");
System.out.println("* »óǰID *" +"\t"+ " * »óǰ¸í * ");
while(rs.next()){
System.out.println(" " + rs.getInt("ProductID") + "\t " + rs.getString("ProductName"));
}
rs.close();
stmt.close();
con.close();
}catch(Exception e) {System.out.println(e);}
}
}
C:\javaExample\19>javac ResultSetTest.java
C:\javaExample\19>java ResultSetTest
ResultSetÀÎÅÍÆäÀ̽ºÀÇ °´Ã¼ rs »ý¼º
* »óǰID * * »óǰ¸í *
3 Aniseed Syrup
4 Chef Anton's Cajun Seasoning
5 Chef Anton's Gumbo Mix
6 Grandma's Boysenberry Spread
8 Northwoods Cranberry Sauce
15 Genen Shouyu
44 Gula Malacca
61 Sirop d'erable
63 Vegie-spread
65 Louisiana Fiery Hot Pepper Sauce
66 Louisiana Hot Spiced Okra
77 Original Frankfurter grune So©¬e
ResultSetÀº StatementÀÇ executeQuery()°¡ ¹ÝȯÇÏ´Â °á°ú·Î ¾òÀº µ¥ÀÌÅ͸¦ ÀúÀåÇØ ³õÀº °ÍÀÔ´Ï´Ù.
jabookÀúÀÚ¸íÇÔ |
Á¦¸ñ:¼Ò¼³°°Àº¹Ì´ÏÄÚµå ÀÛ¼ºÀÚ:Àںϸâ¹ö ÇÑâÇå |