【4】Oracle_Java程序调用存储过程和存储函数

1、Java连接oracle的jar包

ojdbc14-10.2.0.1.0.jar    

2、数据库连接字符串

      String driver = "oracle.jdbc.driver.OracleDriver";

        String url = "jdbc:oracle:thin:@192.168.106.128:1521:orcl"; 

        String user = "scott";

        String password = "orcl";   
说明：url连接的是虚拟机主机的ip地址

Oracle的连接初始化：

private Connection conn;

    private CallableStatement cs;

    private ResultSet rs;

    

    @Before

    public void init() throws Exception{

        String driver = "oracle.jdbc.driver.OracleDriver";

        String url = "jdbc:oracle:thin:@192.168.106.128:1521:orcl";

        String user = "scott";

        String password = "orcl";

        Class.forName(driver);

        // 获取连接对象

        conn = DriverManager.getConnection(url,user,password);

    }

    

    @After

    public void destroy() throws Exception{

        if (rs != <