oracle存贮过程

建表：create table student ( username varchar(20), pass varchar(20) );--插入数据存贮过程create or  replace procedure test_stu( param1  IN varchar2)  asbegin    insert into student(username) values (param1);end test_stu;--有返回字段值的存贮过程create or  replace procedure test_stu_backpass(param_in IN varchar2,param_out OUT varchar2)  asbegin    select pass into param_out from student where username= param_in; end test_stu_backpass;

?

package com;import java.sql.*;import java.sql.ResultSet;/** * 调用存贮过程 * @author jinchun * */public class TestProcedureOne {public TestProcedureOne() {}/**     *             插入值的存贮过程     */    public static void  test_ProcedureOne()    {    String driver = "oracle.jdbc.driver.OracleDriver";String strUrl = "jdbc:oracle:thin:@127.0.0.1:1521:mldn";//数据库名称mldnStatement stmt = null;ResultSet rs = null;Connection conn = null;CallableStatement cstmt = null;try {Class.forName(driver);conn = DriverManager.getConnection(strUrl, "user1", "user1");//用户名和密码user1CallableStatement proc = null;               //存贮过程名称test_stuproc = conn.prepareCall("{ call test_stu(?)}");proc.setString(1, "king");proc.execute();} catch (SQLException ex2) {ex2.printStackTrace();} catch (Exception ex2) {ex2.printStackTrace();} finally {try {if (rs != null) {rs.close();if (stmt != null) {stmt.close();}if (conn != null) {conn.close();}}} catch (SQLException ex1) {}}    }    /**     *             有返回字段值的存贮过程     */    public static void test_ProcedureTwo()    {     String driver = "oracle.jdbc.driver.OracleDriver";        String strUrl = "jdbc:oracle:thin:@127.0.0.1:1521:mldn";        Statement stmt = null;        ResultSet rs = null;        Connection conn = null;        try {          Class.forName(driver);      conn = DriverManager.getConnection(strUrl, "user1", "user1");//用户名和密码user1          CallableStatement proc = null;          proc = conn.prepareCall("{ call test_stu_backpass(?,?) }");          proc.setString(1, "king");          proc.registerOutParameter(2, Types.VARCHAR);          proc.execute();          String testPrint = proc.getString(2);          System.out.println("=testPrint=is="+testPrint);        }        catch (SQLException ex2) {          ex2.printStackTrace();        }        catch (Exception ex2) {          ex2.printStackTrace();        }        finally{          try {            if(rs != null){              rs.close();              if(stmt!=null){                stmt.close();              }              if(conn!=null){                conn.close();              }            }          }          catch (SQLException ex1) {          }        }      }public static void main(String[] args) {test_ProcedureTwo();}}

?