搬运自己的mysql学习笔记3-dbutil的使用

当执行查询操作的时候需要用ResultSetHandler封装结果集

1.ArrayHandler,将查询结果的第一条记录封装成数组

QueryRunner quryrunner = new QueryRunner(DataSourceUtils.getDataSource());

String sql = “select * from moves where movename like?”;

Object[] obj = quryrunner.query(sql, “%火影%”, new ArrayHandler());

System.out.println(Arrays.toString(obj));

2.ArrayListHandler,将查询结果的每一跳记录封装成数组,将每一条记录封装成数组返回

public static void main(String[] args) throws SQLException {

QueryRunner quryrunner = new QueryRunner(DataSourceUtils.getDataSource());

String sql = “select * from moves where movename like?”;

List<Object[]> objs = quryrunner.query(sql, “%火影%”, new ArrayListHandler());

for(Object[] obj:objs){

System.out.println(Arrays.toString(obj));

}

}

3.BeanHandler,将查询结果的第一条记录封装成指定的bean对象

先创建一个bean对象

public class move {

private int id;

private String Classfication;

private String movename;

private String role;

private String introduce;

private String titilepicture;

private String introducepicture;

private String address ;

private String douban;

public String getClassfication() {

return Classfication;

}

public void setClassfication(String classfication) {

Classfication = classfication;

}

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getMovename() {

return movename;

}

public void setMovename(String movename) {

this.movename = movename;

}

public String getRole() {

return role;

}

public void setRole(String role) {

this.role = role;

}

public String getIntroduce() {

return introduce;

}

public void setIntroduce(String introduce) {

this.introduce = introduce;

}

public String getTitilepicture() {

return titilepicture;

}

public void setTitilepicture(String titilepicture) {

this.titilepicture = titilepicture;

}

public String getIntroducepicture() {

return introducepicture;

}

public void setIntroducepicture(String introducepicture) {

this.introducepicture = introducepicture;

}

public String getAddress() {

写在最后

还有一份JAVA核心知识点整理（PDF）：JVM，JAVA集合，JAVA多线程并发，JAVA基础，Spring原理，微服务，Netty与RPC，网络，日志，Zookeeper，Kafka，RabbitMQ，Hbase，MongoDB，Cassandra，设计模式，负载均衡，数据库，一致性哈希，JAVA算法，数据结构，加密算法，分布式缓存，Hadoop，Spark，Storm，YARN，机器学习，云计算…

se，MongoDB，Cassandra，设计模式，负载均衡，数据库，一致性哈希，JAVA算法，数据结构，加密算法，分布式缓存，Hadoop，Spark，Storm，YARN，机器学习，云计算…

[外链图片转存中…(img-StezUGBh-1714201011307)]

本文已被CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】收录