1、准备dbutils 包,加入到项目中
2、https://blog.csdn.net/yk583443123/article/details/104909459 根据这个配置数据库连接
3、数据操作
(1)BeanHandler 查询一条
(2)BeanListHandler 查询一组
(3)MapHandler 查询一条封装成 Map
(4)MapListHandler 查询一条封装成 MapList
Student student=null; Connection connection=null; try { connection=dataSource.getConnection(); String sql="select * from student "; QueryRunner queryRunner=new QueryRunner(); // student=queryRunner.query(connection,sql,new BeanHandler<>(Student.class),id); // System.out.println(queryRunner.query(connection,sql,new BeanListHandler<>(Student.class))); // for() // Map map=queryRunner.query(connection,sql,new MapHandler(),10001); List<Map<String ,Object>> maplist=queryRunner.query(connection,sql,new MapListHandler()); System.out.println(maplist); } catch (SQLException e) { e.printStackTrace(); }finally { try { connection.close(); } catch (SQLException e) { e.printStackTrace(); } } return student;
queryRunner.query(链接,sql,返回结果,参数1,参数2)