javaWeb:DBUtils的实现类resultSethandler，ArrayHandler()， BeanHandler，ColumnListHandler

1.DBUtils的实现类1：resultSethandler

查询一条记录
Object[] objs=queryRunner.query(“select * from user where idusers=?”,new ArrayHandler(),9);//idusers=?相当于idusers=9

Arrays.toString(objs)

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.ArrayHandler;

import java.sql.Array;
import java.sql.SQLException;
import java.util.Arrays;

public class TYBU7 {





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


    QueryRunner queryRunner=new QueryRunner(JBUT2.getDataSource());

    Object[] objs=queryRunner.query("select * from user where idusers=?",new ArrayHandler(),9);

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






}







}

效果图：

查询多条记录：
List<Object[]> list=queryRunner.query(“select * from user”,new ArrayListHandler());//

for(Object[] object:list){
System.out.println(Arrays.toString(object));
}//

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.ArrayHandler;
import org.apache.commons.dbutils.handlers.ArrayListHandler;

import java.sql.Array;
import java.sql.SQLException;
import java.util.Arrays;
import java.util.List;

public class TYBU7 {





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


    QueryRunner queryRunner=new QueryRunner(JBUT2.getDataSource());

   // Object[] objs=queryRunner.query("select * from user where idusers=?",new ArrayHandler(),9);

  //  System.out.println(Arrays.toString(objs));


    List<Object[]> list=queryRunner.query("select * from user",new ArrayListHandler());
for(Object[] object:list){
    System.out.println(Arrays.toString(object));

}



}







}

效果：

2.resultSethandler:实现类2：

TYBU7类：
调用了：JBUT2.getDataSource()； //JBUT2类方法
调用了：Accout类
Accout accout=queryRunner.query(“select * from user where idusers=?”,new BeanHandler(Accout.class),9);
一条记录

import org.apache.commons.dbutils.handlers.ArrayListHandler;
import org.apache.commons.dbutils.handlers.BeanHandler;

import java.sql.Array;
import java.sql.SQLException;
import java.util.Arrays;
import java.util.List;

public class TYBU7 {





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


    QueryRunner queryRunner=new QueryRunner(JBUT2.getDataSource());

   // Object[] objs=queryRunner.query("select * from user where idusers=?",new ArrayHandler(),9);

  //  System.out.println(Arrays.toString(objs));


   // List<Object[]> list=queryRunner.query("select * from user",new ArrayListHandler());
//for(Object[] object:list){
   // System.out.println(Arrays.toString(object));

    Accout accout=queryRunner.query("select * from user where idusers=?",new BeanHandler<Accout>(Accout.class),9);

System.out.println(accout);

}



}

效果图：

多条记录：
list集合:Accout:类

 List<Accout>list=queryRunner.query("select * from user",new BeanListHandler<Accout>(Accout.class));
   for(Accout accout:list) {
System.out.println(accout);
   }

3.resultSethandler:实现类3

  List<Object>list=queryRunner.query("select * from user",new ColumnListHandler<>("password"));


    for(Object object:list){
        System.out.println(object);
    }
   }

效果图：

单值封装scalarhandler：

Object obj=queryRunner.query("select * from user",new ScalarHandler<>());

System.out.println(obj);

效果图：

4.resultSethandler:实现类4

一条记录：

    Map<String,Object> map=queryRunner.query("select * from user where idusers=?",new MapHandler(),9);

System.out.println(map);

多条记录

 List<Map<String, Object>> list = queryRunner.query("select * from user", new MapListHandler());

    for (Map<String, Object> map : list) {
        System.out.println(map);
    }

之后补充（学习）