欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

[SQL]Rowmapper to query SQL in JDBC

程序员文章站 2022-03-06 19:14:04
...
@Repository("DaoImpl")
public class DaoImpl implements IDao {

	private static Logger dbLogger = LoggerFactory.getLogger("DBDOWN_ALERTLOG");
	private static final Logger logger = LoggerFactory.getLogger(DaoImpl.class);
	
	@Autowired
	@Qualifier("jdbcTemplate")
	JdbcTemplate jdbcTemplate;
	
	@Override
	public list<UserMode> query() {
		try {
			logger.info("-----Start to query DB for all user's privilege------");
			List<UserMode> list = jdbcTemplate.query(Constant.Query, new RowMapper<UserMode>() {
				
					@Override
					public UserMode mapRow(ResultSet rs, int rowNum) throws SQLException {
						
							UserMode user = new UserMode();
                                                        String username = rs.getString(Constant.username);
							.....	
							
							user.setUsername(username);
						....
						
						}
						
						logger.info("-----End to query DB for all user's privilege------");	
						return user;
					}
					
				});
				
				return list;
		}catch (DataAccessException e) {
			dbLogger.error("DB is down. Exception is [{}]", e.getMessage());
			throw e;
		} catch (Exception e) {
			logger.error("-- Error occur, exception is [{}]", e.getMessage());
			throw e;
		}
		
	}

 

相关标签: jdbc RowMapper