| | |
| | | |
| | | // 执行查询并处理结果 |
| | | ResultSet rs = pstmt.executeQuery(); |
| | | ResultSetMetaData meta = rs.getMetaData(); |
| | | boolean colCount = rs.next(); |
| | | if(!colCount){ |
| | | pstmt.setString(1, lastMonth); |
| | | meta = rs.getMetaData(); |
| | | rs = pstmt.executeQuery(); |
| | | colCount = rs.next(); |
| | | if(!colCount){ |
| | |
| | | } |
| | | } |
| | | byqlzAdsService.delete(yearMonth); |
| | | |
| | | while (rs.next()) { |
| | | while (colCount) { |
| | | ByqlzAdsEntity entity = new ByqlzAdsEntity(); |
| | | |
| | | // 映射基础字段 |
| | |
| | | } |
| | | } |
| | | |
| | | entity.setLoadTime(currentDate); |
| | | entity.setLoadTime(rs.getString("LOAD_TIME")); |
| | | resultList.add(entity); |
| | | } |
| | | |
| | |
| | | e.printStackTrace(); |
| | | } |
| | | logger.info("SyncEmsTask运行完成"); |
| | | } |
| | | |
| | | public static void main(String[] args) { |
| | | SyncEmsTask task = new SyncEmsTask(); |
| | | String params = ""; |
| | | task.run(params); |
| | | } |
| | | } |