DBUtils笔记

最新推荐文章于 2024-10-01 09:29:45 发布

小屁孩不努力

最新推荐文章于 2024-10-01 09:29:45 发布

阅读量368

点赞数

文章标签： eclipse java sql

本文链接：https://blog.csdn.net/weixin_46427348/article/details/123938893

版权

DBUtils

导包在这里插入图片描述
时Apache组织提供的一个开源JDBC工具类库它是对JDBC的简单封装学习成本极低并且能极大简化JDBC编码的工作量同时也不会影响程序的性能

添加数据操作

	QueryRunner  runner =new QueryRunner();		
		Connection conn = DruidUtils.getConnection3();
	
		String sql ="insert into customers (name ,email,birth)values(?,?,?)";		
		int update = runner.update(conn, sql, "蔡徐坤11",2333,null);
		System.out.println("添加了"+update+"条数据");
		JDBCUtils.closeResource(conn, null);

删除修改也类似改变下sql语句

查询

BeanHander ：是 ResultSetHandler 接口的实现类 用于查询表中一条记录
单条查询

	QueryRunner runner =new QueryRunner();
    Connection conn = DruidUtils.getConnection3();
    String sql = "select id ,name ,email ,birth from customers where id =?";
    BeanHandler<Customers> handler = new BeanHandler<>(Customers.class);
	Customers customer = runner.query(conn, sql, handler, 10);
	 System.out.println(customer);

在这里插入图片描述

BeanListHandle 用于封装表中封装多条记录构成的集合(下面的未处理异常)

QueryRunner runner =new QueryRunner();
    Connection conn = DruidUtils.getConnection3();
    String sql = "select id ,name ,email ,birth from customers where id <?";
    BeanListHandler<Customers> handler =new BeanListHandler<>(Customers.class);
    List<Customers> list = runner.query(conn, sql, handler, 10);
    	for(Customers l : list)
	{
		System.out.println(l);
	}

在这里插入图片描述

MapHander 查询出来是以键值对的情况对应表中一条记录将字段及相应字段的值作为map中的key和value

QueryRunner runner =new QueryRunner();
    Connection conn = DruidUtils.getConnection3();
    String sql = "select id ,name ,email ,birth from customers where id =?";
    MapHandler handler =new MapHandler();
    
    Map<String, Object> map = runner.query(conn, sql, handler,10);
    
    System.out.println(map);

在这里插入图片描述

MapListHandler 对应表中多条记录将字段及相应字段的值作为map中的key 和value 。将这些map添加到list中

 QueryRunner runner =new QueryRunner();
	    Connection conn = DruidUtils.getConnection3();
	    String sql = "select id ,name ,email ,birth from customers where id <?";
	    MapListHandler  handler =new MapListHandler();
	    
	    List<Map<String, Object>> map = runner.query(conn, sql, handler,10);
	    
	     for(Map<String, Object> l : map)
	     {
	    	 System.out.println(l);
	     }

在这里插入图片描述
特殊查询

ScalarHandler 特殊查询只要更换Sql语句即可

例如查询表中共有多少条记录

 QueryRunner runner =new QueryRunner();
	    Connection conn = DruidUtils.getConnection3();
	    String sql = "select count(*)from customers";
	    ScalarHandler handler = new ScalarHandler();
         Object query = runner.query(conn, sql, handler); 
         System.out.println(query);