public Boolean call(String procedure) { Boolean result = false; Connection conn = null; CallableStatement cstmt = null; try { conn = dataSource.getConnection(); cstmt = conn.prepareCall("{call " + procedure + "(?,?)}"); cstmt.setDate(1, new Date());// 输入参数 cstmt.setDate(2, new Date()); cstmt.execute(); result = true; } catch (Exception ex) { ex.printStackTrace(); result = false; } finally { try { if (cstmt != null) { cstmt.close(); } if (conn != null) { conn.close(); } } catch (Exception ex) { ex.printStackTrace(); } } return result; }
参考文档:点击打开链接