Commons DbUtils 小错误
来源:9-1 Commons DBUtils使用入门
起風了3592092
2022-07-06 08:43:49
和视频里写的一样为啥我的就有错误呢
package com.imooc.Sample; import com.alibaba.druid.pool.DruidDataSource; import com.alibaba.druid.pool.DruidDataSourceFactory; import com.imooc.dbutils.DbUtils; import com.imooc.dbutils.Employee; import com.mchange.v2.codegen.bean.Property; import org.apache.commons.dbutils.BaseResultSetHandler; import org.apache.commons.dbutils.QueryRunner; import org.apache.commons.dbutils.handlers.BeanListHandler; import javax.sql.DataSource; import java.io.FileInputStream; import java.io.UnsupportedEncodingException; import java.net.URLDecoder; import java.util.List; import java.util.Properties; /* Apache DbUtils +Druid联合使用演示 */ public class DbUtilsSample { public static void query() { Properties properties = new Properties(); String propertyFile=DbUtilsSample.class.getResource("/druid-config.properties").getPath(); try { propertyFile= URLDecoder.decode(propertyFile,"UTF-8"); properties.load(new FileInputStream(propertyFile)); DataSource dataSource= DruidDataSourceFactory.createDataSource(properties); //数据的参数化查询 QueryRunner qr=new QueryRunner(dataSource); List<Employee> list=qr.query("select * from employee limit ?,10", new BeanListHandler<>(Employee.class), new Object[]{10});//数组Object与?一一对应 for(Employee emp:list){ System.out.println(emp.getEname()); } } catch (Exception e) { throw new RuntimeException(e); } } public static void main(String[] args) { query(); } }
1回答
同学你好,建议检查下配置文件名书写是否正确,配置文件是否直接在src文件夹下而非在src的包文件夹下。
祝学习愉快~
相似问题
回答 1