jdbc调用无参数输出的存储过程

来源:互联网 发布:面板数据固定效应模型 编辑:程序博客网 时间:2024/06/06 03:33

CallableStmtDemo.java :

public class CallableStmtDemo {public static void main(String[] args) {callSpWithoutOutParam();}public static void callSpWithoutOutParam(){try {Class.forName("oracle.jdbc.driver.OracleDriver");Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");CallableStatement callStmt=conn.prepareCall("{call insert_stu(?,?,?,?)}");callStmt.setInt(1,2);callStmt.setString(2,"tom");callStmt.setInt(3,20);callStmt.setString(4,"M");callStmt.execute();} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();}}}


原创粉丝点击