基于HTML、CSS、Java、JavaScript的周转件及特种设备润滑预防性维修模块设计源码

package com.newangels.rotables.repository; import com.newangels.rotables.util.ProcedureUtils; import oracle.jdbc.OracleTypes; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.dao.DataAccessException; import org.springframework.jdbc.core.CallableStatementCallback; import org.springframework.jdbc.core.CallableStatementCreator; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.stereotype.Repository; import java.io.InputStream; import java.math.BigDecimal; import java.sql.*; import java.util.HashMap; import java.util.Map; /** * @author: TangLiang * @date: 2020/12/11 9:25 * @since: 1.0 */ @Repository public class SpeEquArchivesRepository { @Autowired private JdbcTemplate rotJdbcTemplate; //查询厂矿和作业区 public Map PRO_BASE_DEPT_VIEW_ROLE(String V_V_PERSONCODE, String V_V_DEPTCODE, String V_V_DEPTCODENEXT, String V_V_DEPTTYPE) { return rotJdbcTemplate.execute(new CallableStatementCreator() { public CallableStatement createCallableStatement(Connection con) throws SQLException { String sql = "{call PRO_BASE_DEPT_VIEW_ROLE(:V_V_PERSONCODE, :V_V_DEPTCODE, :V_V_DEPTCODENEXT, :V_V_DEPTTYPE, :V_CURSOR)}"; CallableStatement statement = con.prepareCall(sql); statement.setString("V_V_PERSONCODE", V_V_PERSONCODE); statement.setString("V_V_DEPTCODE", V_V_DEPTCODE); statement.setString("V_V_DEPTCODENEXT", V_V_DEPTCODENEXT); statement.setString("V_V_DEPTTYPE", V_V_DEPTTYPE); statement.registerOutParameter("V_CURSOR", OracleTypes.CURSOR); return statement; } }, new CallableStatementCallback<Map>() { public Map doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException { cs.execute(); HashMap returnValue = new HashMap(); returnValue.put("V_CURSOR", ProcedureUtils.ResultHash((ResultSet) cs.getObject("V_CURSOR"))); return returnValue; } }); } //查询设备类型 public Map PRO_GET_DEPTEQUTYPE_PER(String V_V_PERSONCODE, String V_V_DEPTCODENEXT) { return rotJdbcTemplate.execute(new CallableStatementCreator() { public CallableStatement createCallableStatement(Connection con) throws SQLException { String sql = "{call PRO_GET_DEPTEQUTYPE_PER(:V_V_PERSONCODE, :V_V_DEPTCODENEXT, :V_CURSOR)}"; CallableStatement statement = con.prepareCall(sql); statement.setString("V_V_PERSONCODE", V_V_PERSONCODE); statement.setString("V_V_DEPTCODENEXT", V_V_DEPTCODENEXT); statement.registerOutParameter("V_CURSOR", OracleTypes.CURSOR); return statement; } }, new CallableStatementCallback<Map>() { public Map doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException { cs.execute(); HashMap returnValue = new HashMap(); returnValue.put("V_CURSOR", ProcedureUtils.ResultHash((ResultSet) cs.getObject("V_CURSOR"))); return returnValue; } }); } //查询设备类型 public Map OIL_GET_DEPTEQUTYPE_PER(String V_V_PERSONCODE, String V_V_DEPTCODENEXT) { return rotJdbcTemplate.execute(new CallableStatementCreator() { public CallableStatement createCallableStatement(Connection con) throws SQLException { String sql = "{call OIL_GET_DEPTEQUTYPE_PER(:V_V_PERSONCODE, :V_V_DEPTCODENEXT, :V_CURSOR)}"; CallableStatement statement = con.prepareCall(sql); statement.setString("V_V_PERSONCODE", V_V_PERSONCODE); statement.setString("V_V_DEPTCODENEXT", V_V_DEPTCODENEXT); statement.registerOutParameter("V_CURSOR", OracleTypes.CURSOR); return statement; } }, new CallableStatementCallback<Map>() { public Map doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException { cs.execute(); HashMap returnValue = new HashMap(); returnValue.put("V_CURSOR", ProcedureUtils.ResultHash((ResultSet) cs.getObject("V_CURSOR"))); return returnValue; } }); } //查询设备类型 public Map PRO_GET_ORGEQUTYPE_ALL(String V_ORGCODE) { return rotJdbcTemplate.execute(new CallableStatementCreator() { public CallableStatement createCallableStatement(Connection con) throws SQLException { String sql = "{call PRO_GET_ORGEQUTYPE_ALL(:V_ORGCODE, :V_CURSOR)}"; CallableStatement statement = con.prepareCall(sql); statement.setString("V_ORGCODE", V_ORGCODE); statement.registerOutParameter("V_CURSOR", OracleTypes.CURSOR); return statement; } }, new CallableStatementCallback<Map>() { public Map doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException { cs.execute(); HashMap returnValue = new HashMap(); returnValue.put("result", ProcedureUtils.ResultHash((ResultSet) cs.getObject("V_CURSOR"))); return returnValue; } }); } //查询设备 public Map PRO_GET_DEPTEQU_PER(String V_V_PERSONCODE, String V_V_DEPTCODENEXT, String V_V_EQUTYPECODE) { return rotJdbcTemplate.execute(new CallableStatementCreator() { public CallableStatement createCallableStatement(Connection con) throws SQLException { String sql = "{call PRO_GET_DEPTEQU_PER(:V_V_PERSONCODE, :V_V_DEPTCODENEXT, :V_V_EQUTYPECODE, :V_CURSOR)}"; CallableStatement statement = con.prepareCall(sql); statement.setString("V_V_PERSONCODE", V_V_PERSONCODE); statement.setString("V_V_DEPTCODENEXT", V_V_DEPTCODENEXT); statement.setString("V_V_EQUTYPECODE", V_V_EQUTYPECODE); statement.registerOutParameter("V_CURSOR", OracleTypes.CURSOR); return statement; } }, new CallableStatementCallback<Map>() { public Map doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException { cs.execute(); HashMap returnValue = new HashMap(); returnValue.put("V_CURSOR", ProcedureUtils.ResultHash((ResultSet) cs.getObject("V_CURSOR"))); return returnValue; } }); } //查询设备类型 public Map SE_GET_DEPTEQUTYPE_PER(String V_V_PERSONCODE, String V_V_DEPTCODENEXT) { return rotJdbcTemplate.execute(new CallableStatementCreator() { public CallableStatement createCallableStatement(Connection con) throws SQLException { String sql = "{call SE_GET_DEPTEQUTYPE_PER(:V_V_PERSONCODE, :V_V_DEPTCODENEXT, :V_CURSOR)}"; CallableStatement statement = con.prepareCall(sql); statement.setString("V_V_PERSONCODE", V_V_PERSONCODE); statement.setString("V_V_DEPTCODENEXT", V_V_DEPTCODENEXT); statement.registerOutParameter("V_CURSOR", OracleTypes.CURSOR); return statement; } }, new CallableStatementCallback<Map>() { public Map doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException { cs.execute(); HashMap returnValue = new HashMap(); returnValue.put("V_