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文件
