报错信息:
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.ssm.mapper.UserMapper.insertUser
以下是我mapper接口方式开发实现添加用户代码
整个项目结构
接口及UserMapper.xml文件
public interface UserMapper {
public int insertUser(User user);
}
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ssm.mapper.UserMapper">
<!-- 添加用户信息 -->
<insert id="inertUser" parameterType="com.ssm.po.User" >
insert into t_user(username,jobs,phone) values(#{username},#{jobs},#{phone})
</insert>
</mapper>
application.xml
<!-- mapper代理开发(基于MapperFactoryBean) -->
<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
<property name="mapperInterface" value="com.ssm.mapper.UserMapper" />
<property name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>
mybatis-config.xml
<configuration>
<!-- 配置别名 -->
<typeAliases>
<package name="com.ssm.po" />
</typeAliases>
<!-- 配置mapper的位置 -->
<mappers>
<mapper resource="com/ssm/mapper/UserMapper.xml" />
</mappers>
</configuration>
测试类
@Test
public void insertUserTest(){
ApplicationContext applicationContext=new ClassPathXmlApplicationContext("applicationContext.xml");
UserMapper userMapper=(UserMapper) applicationContext.getBean("userMapper");
User user=new User();
user.setUsername("hqx1");
user.setJobs("teaccher");
user.setPhone("123456789");
userMapper.insertUser(user);
}
报错
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.ssm.mapper.UserMapper.insertUser
at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:230)
at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:48)
望帮我看看,谢谢!!