public static final String DBDRIVE = "oracle.jdbc.driver.OracleDriver";
public static final String DBURL = "jdbc:oracle:thin:@169.254.24.29:1521:orcl";
public static final String DBUSER = "scott";
public static final String DBPASSWORD= "tiger";
public static void main(String[] args)
{
Connection conn =null;
CallableStatement cstmt = null;
String sql = "{CALL myproc(?,?,?)}";
try {
Class.forName(DBDRIVE);
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
cstmt =conn.prepareCall(sql);
cstmt.setInt(1,70);
cstmt.setInt(2, 80);
cstmt.registerOutParameter(2, Types.INTEGER);
cstmt.registerOutParameter(3, Types.INTEGER);
cstmt.execute();
cstmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
二、JDBC调用存储过程
最新推荐文章于 2024-07-26 14:53:47 发布