我是以scott用户连接的,修改scott的工资就不可以,cs.setString(1, "SCOTT"); 这句话改成SMITH就可以修改了
怎么用scott连接再修改scott的工资呢?
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;
怎么用scott连接再修改scott的工资呢?
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;
然后再来执行该段代码~