callstmt.java

来自「JDBC,指定数据库,打开数据库连接 数据库查询、修改、增加或删除等」· Java 代码 · 共 21 行

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:@192.168.100.124:1521:ora9","scott","tiger");
		    CallableStatement stmt=conn.prepareCall("{call chang_salary}");
                  double b = 0.0;
			stmt.setInt(1,7369);	    
		    stmt.setInt(2,5000);
		    stmt.setDouble(3,b);	
		    stmt.execute();
			stmt.close();
			conn.close();
                  System.out.println(b);
		}catch(SQLException e){
		    System.err.println(e);
		}
    }
}