spring框架学习记录 5 jdbcTemplate出现异常记录

最新推荐文章于 2025-04-09 14:15:04 发布

csdn_ccr

最新推荐文章于 2025-04-09 14:15:04 发布

阅读量802

点赞数

本文链接：https://blog.csdn.net/csdn_ccr/article/details/105568415

版权

在使用Spring的jdbcTemplate进行数据查询时遇到异常，具体表现为在调用query和queryForObject方法并按要求传递参数时，报nested exception是java.lang.InstantiationException。错误原因在于实体类缺少无参构造函数，添加无参构造方法后问题得到解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在测试jdbctemplate的query方法和queryForObject方法时按要求传参报错

代码

ApplicationContext applicationContext = new ClassPathXmlApplicationContext("jdbcTemplate.xml");
        JdbcTemplate jdbcTemplateBean = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);
        StringBuilder sql = new StringBuilder();
        sql.append("select id,name,tel,createTime from tb_user where id = '1' ");
        RowMapper<TbUser> rowMapper = new BeanPropertyRowMapper<>(TbUser.class);
        List<TbUser> query = jdbcTemplateBean.query(sql.toString(), rowMapper);
        TbUser tbUser = jdbcTemplateBean.queryForObject(sql.toString(), rowMapper);
        System.out.println(query.toString());
        System.out.println(tbUser);

报错信息

Exception in thread "main" org.springframework.beans.BeanInstantiationException: Failed to instantiate [jdbcTemplate.entity.TbUser]: Is it an abstract class?; nested exception is java.lang.InstantiationException: jdbcTemplate.entity.TbUser
	at org.springframework.beans.BeanUtils.instantiate(BeanUtils.java:81)
	at org.springframework.jdbc.core.BeanPropertyRowMapper.mapRow(BeanPropertyRowMapper.java:236)
	at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:93)
	at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:60)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:400)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:476)
	at jdbcTemplate.test.Main.main(Main.java:18)
Caused by: java.lang.InstantiationException: jdbcTemplate.entity.TbUser
	at java.lang.Class.newInstance(Class.java:427)
	at org.springframework.beans.BeanUtils.instantiate(BeanUtils.java:78)
	... 8 more
Caused by: java.lang.NoSuchMethodException: jdbcTemplate.entity.TbUser.<init>()
	at java.lang.Class.getConstructor0(Class.java:3082)
	at java.lang.Class.newInstance(Class.java:412)
	... 9 more

关键信息nested exception is java.lang.InstantiationException

网上搜索问题给到的答案是在把查询结果映射成实体类时，无法调用实体类的无参构造方法，在TbUser表中加无参构造方法后问题解决