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 block
e.printStackTrace();
}
}
}