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

dbutil是apache组织的一个工具类,是一个jdbc的框架

导入jar包commons-dbutils-1.6.jar

使用方法:

创建一个queryrunner类,用来操作sql语句,构造方法需要传入一个DataSource类

编写sql语句

用queryrunner的(query)(update)方法执行sql语句实现curd操作

当执行查询操作的时候需要用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;

Java面试核心知识点笔记

其中囊括了JVM、锁、并发、Java反射、Spring原理、微服务、Zookeeper、数据库、数据结构等大量知识点。

Java中高级面试高频考点整理

最后分享Java进阶学习及面试必备的视频教学

图片转存中…(img-QxcTi1Ju-1714717225600)]

[外链图片转存中…(img-LWydf10o-1714717225600)]

最后分享Java进阶学习及面试必备的视频教学

[外链图片转存中…(img-GDFPgT6T-1714717225601)]

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