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

• • 1.DBUtils的实现类1：resultSethandler
  • 2.resultSethandler:实现类2：
  • 3.resultSethandler:实现类3
  • 4.resultSethandler:实现类4

查询一条记录
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 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 list=queryRunner.query("select * from user",new ArrayListHandler());
for(Object[] object:list){
    System.out.println(Arrays.toString(object));

}



}







}

效果：

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 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.class),9);

System.out.println(accout);

}



}

效果图：

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

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

  List