第一步,在pl/sql中写一个 存储过程:
create or replace procedure empid_name_address(
p_empid in t_emp.empid%type, --输入型参数
p_empname out t_emp.empname%type,--输出型参数
p_empaddress out t_emp.empadress%type
)
as
begin
select empname,empadress into p_empname,p_empaddress from t_emp where t_emp.empid = p_empid;
end;
第二步:写java 代码:
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;s
import java.sql.SQLException;
import oracle.jdbc.OracleTypes;
public class JdbcTest {
private final static String USERNAME = "szq";
private final static String PASSWORD = "szq";
private final static String URL = "jdbc:Oracle:thin:@localhost:1521:orcl";
private final static String DRIVER = "oracle.jdbc.driver.OracleDriver";
public static void main(String[] arg0){
testProcedual();
}
public static void testProcedual(){
Connection conn = null;
//定义调用存储过程的对象
CallableStatement call = null;
try {
Class.forName(DRIVER);
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
call = conn.prepareCall("{call empid_name_address(?,?,?)}");
//为输入型参数设值
call.setString(1, "11104");
//注册输出型参数
call.registerOutParameter(2, OracleTypes.VARCHAR);
call.registerOutParameter(3, OracleTypes.VARCHAR);
//执行存储过程
call.execute();
//获取返回值
String name = call.getString(2);
String address = call.getString(3);
System.out.println("11104员工的姓名是"+name+",该员工的住址是"+address);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
}
输出的结果为:
11104员工的姓名是肖小军,该员工的住址是河南
java中的代码注意几点:
1.对于输出型的参数,一定要注册,否则会默认为输入型参数。
2.注册时括号中的 OracleTypes 后面有“s”,不要丢了。