prepstmt.java

来自「概括的介绍java及其网络开发」· Java 代码 · 共 19 行

import java.sql.*;
public class PrepStmt{
	public static void main(String[] args){
		try{
			new oracle.jdbc.driver.OracleDriver();//另外一种注册驱动程序的方法
			Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ora9","scott","tiger");
			PreparedStatement pstmt=conn.prepareStatement("insert into dept values(?,?,?)");
			pstmt.setInt(1,23);
			pstmt.setString(2,"Kit");
			pstmt.setString(3, "hi");	
			pstmt.executeUpdate();
           pstmt.close();
           conn.close();
		}catch(SQLException e){
			System.err.println(e);
		}
	}
}