package demo;/* * QueryRunner数据查询操作; * 调用QueryRunner类方法query(Connection con,String sql,ResultSetHandler r,Oberct...params)) * ResultSetHandler r 结果集的处理方式,传递ResultSetHandler接口实现类 * Object...params SQL语句中的?占位符 * * 注意:query方法返回值,返回的是T 泛型,具体返回值类型,跟随结果集处理方式变化 */import java.util.List;import java.util.Map;import java.sql.Connection;import java.sql.SQLException;import org.apache.commons.dbutils.QueryRunner;import org.apache.commons.dbutils.handlers.ArrayHandler;import org.apache.commons.dbutils.handlers.ArrayListHandler;import org.apache.commons.dbutils.handlers.BeanHandler;import org.apache.commons.dbutils.handlers.BeanListHandler;import org.apache.commons.dbutils.handlers.ColumnListHandler;import org.apache.commons.dbutils.handlers.MapHandler;import org.apache.commons.dbutils.handlers.MapListHandler;import org.apache.commons.dbutils.handlers.ScalarHandler;import domain.Sort;import jdbcutil.JDBCUtilsConfig;public class QueryRunnerDemo1{ private static Connection con=JDBCUtilsConfig.getConnection(); public static void main(String[] args) throws SQLException { //arrayHandler(); //arrayListHandler(); //beanHandler(); //beanListHandler() //columnListHandler(); //scalarHandler(); //mapHandler(); mapListHandler(); } /** * 结果集第八种处理方法,MapListHandler * 将结果集每一行存储到Map集合,键:列明,值:数据 * Map集合过多,存储到List集合 * @throws SQLException */ public static void mapListHandler() throws SQLException{ QueryRunner qr=new QueryRunner(); String sql="select * from sort"; //调用方法query,传递结果集实现类MapListHandler List