java 调用存储过程

java 调用存储过程

package com.jlwang.db;import java.sql.CallableStatement;import java.sql.Connection;import java.sql.DriverManager;public class TestOracle {/** * @param args */public static void main(String[] args) {try {Class.forName("oracle.jdbc.driver.OracleDriver");Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL", "******","******");if (null == connection) {return;}CallableStatement cs = connection.prepareCall("{call jl_pro3(?,?)}");cs.setString(1, "123");cs.setInt(2, 3800);cs.execute();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}}