JDBC¸¦ ±âº»ÀûÀ¸·Î ±¸ÇöÇÑ ¿¹Á¦
JDBCTest.java
import java.sql.*;
public class JdbcTest {
public static void main(String[] args) throws SQLException, ClassNotFoundException {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:dbdsn", "id","password");
Statement stmt = conn.createStatement();
String sql = "Create table MyTest(name varchar(20), age int) ";
stmt.executeUpdate(sql);
System.out.println(" MyTest Å×ÀÌºí »ý¼º" );
PreparedStatement pstmt = conn.prepareStatement("Insert into MyTest values (?,?)");
pstmt.setString(1, "Jabook");
pstmt.setInt(2, 2);
pstmt.execute();
System.out.println(" MyTest Å×ÀÌºí¿¡ µ¥ÀÌÅÍ »ðÀÔ");
stmt = conn.createStatement();
sql = "Select * from MyTest ";
ResultSet rs = stmt.executeQuery(sql);
System.out.println(" MyTest Å×ÀÌºí¿¡¼ ResultSet °¡Á®¿À±â");
while(rs.next()){
System.out.println("name : " + "\t" + rs.getString(1));
System.out.println("age : " + "\t" + rs.getInt(2));
}
rs.close();
pstmt.close();
stmt.close();
conn.close();
}
}
C:\javaExample\19>javac JdbcTest.java
C:\javaExample\19>java JdbcTest
MyTest Å×ÀÌºí »ý¼º
MyTest Å×ÀÌºí¿¡ µ¥ÀÌÅÍ »ðÀÔ
MyTest Å×ÀÌºí¿¡¼ ResultSet °¡Á®¿À±â
name : Jabook
age : 2
ÀÚ¹Ù¿¡¼ÀÇ µ¥ÀÌÅͺ£À̽º ¿¬µ¿ ¼ø¼
1. µå¶óÀ̹ö ·Îµù
2. Connection °´Ã¼ »ý¼º
3. Statement °´Ã¼ »ý¼º
4. query¸¦ µ¥ÀÌÅͺ£À̽º·Î Àü¼Û
5. ResultSet °´Ã¼ »ý¼º
6. close()¸¦ »ç¿ëÇÏ¿© ³ªÁß¿¡ »ý¼ºµÈ °´Ã¼ºÎÅÍ ´Ý¾ÆÁÜ
jabookÀúÀÚ¸íÇÔ |
Á¦¸ñ:¼Ò¼³°°Àº¹Ì´ÏÄÚµå ÀÛ¼ºÀÚ:Àںϸâ¹ö ÇÑâÇå |