JDBC调用DB2存储过程详解：连接配置与执行示例

logger.info("---1:" + ResourceDaoImpl.class.getResource("/").toString());
logger.info("---2:" + ResourceDaoImpl.class.getResource("/").getPath());
logger.info("---3:" + ResourceDaoImpl.class.getResource("/"));
InputStream inStream = ResourceDaoImpl.class.getResourceAsStream(
"/config/jdbc.properties");
File file = new File("config/jdbc.properties");         
        FileInputStream fis = new FileInputStream(file);
        Properties property = new Properties();
        property.load(fis);
        
        String sDBDriver = property.getProperty("connection.driver_class").trim();
String sConnStr = property.getProperty("jdbc.connection.url").trim();
String userName = property.getProperty("jdbc.connection.username").trim();
String password = property.getProperty("jdbc.connection.password").trim();

TbEntResource resource = null;
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr,userName,password);
String sql = "CALL P_GETALLRESOURCE()";
CallableStatement callStmt = conn.prepareCall(sql);

callStmt.execute();
    rs = callStmt.getResultSet();
    while(rs.next()){
     resource = new TbEntResource();
     Integer modifyUser = rs.getInt("MODIFY_USER");
        Integer dataState = rs.getInt("DATA_STATE");
        Integer fatherResourceId = rs.getInt("FATHER_RESOURCE_ID");
        Integer resourceType = rs.getInt("RESOURCE_TYPE");
        String resourceUrl = rs.getString("RESOURCE_URL");