PreparedStatemet¸¦ »ç¿ëÇØ µ¥ÀÌÅͺ£À̽º¿¡ ·¹Äڵ带 »ðÀÔÇÏ´Â ¿¹Á¦
PreparedStatementTest.java
import java.sql.*;
public class PreparedStatementTest {
public static void main(String[] args) {
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:dbdsn", "id", "password");
String sql = "insert MyTest values (?, ?)";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, "È«±æµ¿"); pstmt.setInt(2, 20);
pstmt.executeUpdate();
pstmt.setString(1, "¼ºÃáÇâ"); pstmt.setInt(2, 16);
pstmt.executeUpdate();
pstmt.setString(1, "À̸ù·æ"); pstmt.setInt(2, 17);
pstmt.executeUpdate();
pstmt.setString(1, "½É û"); pstmt.setInt(2, 15);
pstmt.executeUpdate();
pstmt.setString(1, "½ÉÇбÔ"); pstmt.setInt(2, 55);
pstmt.executeUpdate();
pstmt.close();
con.close();
System.out.println("µ¥ÀÌÅÍ ¾÷µ¥ÀÌÆ® ¿Ï·á!!");
}catch(Exception e) {System.out.println(e);}
}
}
C:\javaExample\19>javac PreparedStatementTest.java
C:\javaExample\19>java PreparedStatementTest
µ¥ÀÌÅÍ ¾÷µ¥ÀÌÆ® ¿Ï·á!!
PreparedStatement´Â µ¿ÀÏÇÑ query¹®À» ¿©·¯ ¹ø ¹Ýº¹ÇÏ¿© »ç¿ëÇϰíÀÚ ÇÒ °æ¿ì¿¡ »ç¿ëÇÏ´Â ÀÎÅÍÆäÀ̽ºÀÌ´Ù.
jabookÀúÀÚ¸íÇÔ |
Á¦¸ñ:¼Ò¼³°°Àº¹Ì´ÏÄÚµå ÀÛ¼ºÀÚ:Àںϸâ¹ö ÇÑâÇå |