org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.cqgcxy.ols.mapper.UserMapper.userRegister？

Question

Invalid bound statement (not found)
UserMapper.xml文件
<?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.cqgcxy.ols.mapper.UserMapper">
  <resultMap id="BaseResultMap" type="com.cqgcxy.ols.entity.User">
    <id column="id"  property="id" />
    <result column="Accounts"  property="accounts" />
    <result column="Password"  property="password" />
    <result column="Name"  property="name" />
    <result column="Sex"  property="sex" />
    <result column="Phone"  property="phone" />
    <result column="Email"  property="email" />
  </resultMap>
<!--用户注册-->
  <insert id="userRegister" parameterType="com.cqgcxy.ols.entity.User">

insert into user(id,Accounts,Password,Name,Sex,Phone,Email) values(default,#{accounts},#{password},#{name},#{sex},#{phone},#{email})

<!--用户登录-->

select * from user where Accounts=#{accounts} and Password=#{password}


UserMapper.java文件
@Mapper
@Repository
public interface UserMapper {
int userRegister(User user);

User userLogin (@Param("accounts") String accounts, @Param("password") String password);

}

UserServiceImpl.java文件
@Service
public class UserServiceImpl implements UserService {
@Autowired
UserMapper userMapper;
/**
* 用户注册
* @param user
* @return
*/
@Override
public int userRegister(User user) {
user.setPassword((MD5Util.getMD5String(user.getPassword())));
int result = userMapper.userRegister(user);
return result;
}

测试：
@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest
public class ServiceTest {
@Autowired
UserService userService;
@Test
public void test(){
User user = new User();
user.setAccounts("13456");
user.setPassword("123456");
int i = userService.userRegister(user);
System.out.println(i);
}
}
然后就包找不到那个文件 输出文件里也有xml文件

Answer 1

看代码好像没有什么问题， 你重建一下项目什么的看一下好不好使。 另外贴代码最好贴在代码块里，看起来太费劲了