java调用存储过程

DBOperator db = new DBOperator();
       String procname = "{call timecard_report()}";
       
             CallableStatement smt=null;
    try {  
     db.conn.setAutoCommit(false);
     smt = db.conn.prepareCall(procname);
     smt.execute();
     db.conn.commit();
    } catch (SQLException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
     try {
      db.conn.rollback();
     } catch (SQLException e1) {
      // TODO Auto-generated catch block
      e1.printStackTrace();
     }
    }
             finally{
              try {
      smt.close();
     } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
     }
     db.close();
             }

 

附件里是存储过程

 

 

如果要参数:

String year = (String)req.getParameter("year");
  String month = (String)req.getParameter("month");
  String alertInfo = "初始化成功！";
  //System.out.println("month: "+month);
  DBOperator db = new DBOperator();
     String procname = "{call timecard_report(?,?)}";
     CallableStatement smt=null;
     try { 
      db.conn.setAutoCommit(false);
      smt = db.conn.prepareCall(procname);
      smt.setString(1, year);
      smt.setString(2, month);
      smt.execute();
      db.conn.commit();
     }catch (SQLException e) {
      e.printStackTrace();
      alertInfo = "初始化失败！";
      try {
       db.conn.rollback();
      } catch (SQLException e1) {
       e1.printStackTrace();
      }
     }finally{
       try {
       smt.close();
      } catch (SQLException e) {
       e.printStackTrace();
      }
      db.close();
     }