QueryRunner.query----使用时记得带参数

原创于 2019-03-08 18:09:36 发布 · 2.7k 阅读

CC 4.0 BY-SA版权

本文介绍了Apache Commons DBUtils中的QueryRunner.query方法的使用，强调在调用时必须传入参数。该方法用于执行SQL查询，结合ResultSetHandler处理查询结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

UserBean org.apache.commons.dbutils.QueryRunner.query(String sql, ResultSetHandler rsh, Object… params) throws SQLException

Note: This element neither has attached source nor attached Javadoc and hence no Javadoc could be found.

QueryRunner runner = new QueryRunner(JDBCUtil02.getDataSource());
		String sql = "select * from t_user where username = ? and password = ?";
		UserBean query = runner.query(sql, new BeanHandler<UserBean>(UserBean.class) , user.getUsername() , user.getPassword());
		return query;