java调用存储过程

 

Connection conn = null;
  CallableStatement proc = null;
  try {
   conn = ConnectionFactory.getConnection();
   proc = conn.prepareCall("{  call WSSP.PROC_SELECT_DM_slh(?,?,?,?) }");
   proc.setString(1, fqsqForm.getNsrsbh());
   proc.setString(2, fqsqForm.getSpxl());
   proc.setString(3,"1");
   proc.registerOutParameter(4, Types.VARCHAR);
   proc.execute();
   slh = proc.getString(4);
  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   try {
    if (null != proc) {
     proc.close();
    }
    if (null != conn) {
     conn.close();
    }
   } catch (Exception e) {
    logger.info(e.toString());
   }
  }