| | |
| | | // 执行查询并处理结果 |
| | | ResultSet rs = pstmt.executeQuery(); |
| | | ResultSetMetaData meta = rs.getMetaData(); |
| | | int colCount = meta.getColumnCount(); |
| | | if(colCount == 0){ |
| | | boolean colCount = rs.next(); |
| | | if(!colCount){ |
| | | pstmt.setString(1, lastMonth); |
| | | meta = rs.getMetaData(); |
| | | rs = pstmt.executeQuery(); |
| | | colCount = meta.getColumnCount(); |
| | | if(colCount == 0){ |
| | | colCount = rs.next(); |
| | | if(!colCount){ |
| | | pstmt.setString(1, upMonth); |
| | | rs = pstmt.executeQuery(); |
| | | remark = "上月数据为空,同步上上月数据成功"; |
| | |
| | | } |
| | | logger.info("SyncEmsTask运行完成"); |
| | | } |
| | | |
| | | public static void main(String[] args) { |
| | | SyncEmsTask task = new SyncEmsTask(); |
| | | String params = ""; |
| | | task.run(params); |
| | | } |
| | | } |