[SQL]Rowmapper to query SQL in JDBC

最新推荐文章于 2025-07-18 09:29:57 发布

原创最新推荐文章于 2025-07-18 09:29:57 发布 · 117 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#jdbc #RowMapper

本文详细介绍了如何使用Spring框架中的JdbcTemplate实现对数据库中所有用户权限信息的查询操作。通过具体代码示例，展示了如何配置日志记录，处理查询结果，并捕获可能发生的异常。

@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;
		}
		
	}