callstmt.java

来自「这是一个关于jsp的学习文档.为学习jsp的朋友提供方便」· Java 代码 · 共 19 行

import java.sql.*;
public class CallStmt{
    public static void main(String[] args){
		try{
		    new oracle.jdbc.driver.OracleDriver();
		    Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ora9","scott","tiger");
		    CallableStatement stmt=conn.prepareCall("{call MyProcedure(?,?,?)}");		
			stmt.setInt(1,77);	    
		    stmt.setString(2,"Ruby");
		    stmt.setInt(3,45);				
		    stmt.executeUpdate();
			stmt.close();
			conn.close();
		}catch(SQLException e){
		    System.err.println(e);
		}
    }
}