1.Oracle的存储过程
--练习:使用out参数类型实例返回指定员工的姓名和工资
create or replace procedure findinfo (v_classid in varchar2,v_name out varchar2,v_salary out varchar2)
as
begin
select classname,salary into v_name,v_salary from classinfo where classid=v_classid;
end;
/
2.JDBC调用Oracle的存储过程的Java代码
package cn.itcast.procedure;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
public class Main {
//使用JDBC调用存储过程
public static void main(String[] args) throws Exception{
/**
* mysql:
* com.mysql.jdbc.Driver
* jdbc:mysql//localhost
* root
* root
*
* Oracle
* oracle.jdbc.OracleDriver
* jdbc:oracle:thin:@localhost:1521:orcl
* SCOTT
* Root123*/
//1.定义变量
String driverClass="oracle.jdbc.OracleDriver";
String url="jdbc:oracle:thin:@