62,614
社区成员
发帖
与我相关
我的任务
分享
import java.sql.*;
public class Test {
public static void main(String[] args) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:myora";
String userName = "scott";
String password = "tiger";
Connection conn =
DriverManager.getConnection (url, userName, password);
System.out.println(conn);
CallableStatement cs = conn.prepareCall("{call sp_001(?,?)}");
cs.setString(1, "SCOTT");
cs.setInt(2, 2900);
cs.execute();
cs.close();
conn.close();
//ok打印不出来,改成SIMTH就可以了
System.out.println("ok!");
} catch (Exception e) {
e.printStackTrace();
}
}
}
create or replace procedure sp_001(empName varchar2, newSal number) is
begin
update emp set sal=newSal where ename=empName;
end;