[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; } }
上一篇: 传统io&mmap&直接io&sendfile零拷贝 对比
下一篇: 21种回归算法整理
推荐阅读
-
在JDBC中实现SQL语句的模糊查询
-
java当中JDBC当中请给出一个sql server的dataSource的helloworld例子
-
使用jdbc拼接条件查询语句时如何防止sql注入
-
SqlServer 2005 T-SQL Query 学习笔记(4)
-
SqlServer 2005 T-SQL Query 学习笔记(3)
-
SqlServer 2005 T-SQL Query 学习笔记(1)
-
UCenter info: MySQL Query Error SQL:SELECT value FROM [Table]vars WHERE noteexis
-
jdbc连接sql server2017进行简单的增、删、改、查操作
-
SqlServer 2005 T-SQL Query 学习笔记(2)
-
UCenter info: MySQL Query Error SQL:SELECT value FROM [Table]vars WHERE noteexists