µ¥ÀÌÅͺ£À̽º¿¡ query¸¦ ³¯¸®±â À§ÇÑ Statement °´Ã¼¸¦ »ý¼ºÇÏ´Â ¿¹Á¦
StatementTest.java
import java.sql.*;
public class StatementTest {
public static void main(String[] args) {
Connection con = null;
Statement stmt = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:dbdsn", "id","password");
stmt = con.createStatement();
System.out.println("Statement°´Ã¼ stmt »ý¼º");
stmt.close();
System.out.println("»ý¼ºÇÑ °´Ã¼ stmt¸¦ ´ÝÀ½");
con.close();
System.out.println("µ¥ÀÌÅͺ£À̽º¿Í ¿¬°áÀ» ²÷À½");
}catch(Exception e){}
}
}
C:\javaExample\19>javac ConnectionTest.java
C:\javaExample\19>java ConnectionTest
ConnectionŬ·¡½ºÀÇ °´Ã¼ con »ý¼º
µ¥ÀÌÅͺ£À̽º¿Í ¿¬°áÀ» ²÷À½
Statement´Â ConnectionÀÎÅÍÆäÀ̽ºÀÇ createStatement()¸¦ »ç¿ëÇÏ¿© °´Ã¼¸¦ »ý¼ºÇÒ ¼ö ÀÖ´Ù.
jabookÀúÀÚ¸íÇÔ |
Á¦¸ñ:¼Ò¼³°°Àº¹Ì´ÏÄÚµå ÀÛ¼ºÀÚ:Àںϸâ¹ö ÇÑâÇå |