今天第一次在java中调用数据库的存储过程,直接上代码
public void insertSql(String taskCode, String exeSql)
throws Exception{
java.sql.Connection conn = null;
CallableStatement call = null;
String sql = "{call reinscheckdata.insertsql(?,?)}";
DBManager dbManager = new DBManager();
BLCheckresultAction blCheckresultAction = new BLCheckresultAction();
try{
dbManager.open("ddccDataSource");
conn = dbManager.getConnection();
dbManager.beginTransaction();
//为存储过程传参
call = conn.prepareCall(sql);
call.setString(1, exeSql);
call.setString(2, taskCode);
call.registerOutParameter(3, Types.VARCHAR);
call.execute();
String flag = call.getString(3);
System.out.println("返回参数"+flag);
if("0".equals(flag)){
dbManager.commitTransac