@Select("select * from user") List<User> list(); @Insert("insert into user(email,fullname,isadmin,password) values (#{email},#{fullname},#{isadmin},#{password})") void save(User user);
}
2、编写IUserService接口+UserServiceImpl时限内
public interface IUserService {
public List<User> list();
public void save(User user);
}
@Service
public class UserServiceImpl implements IUserService {
@Autowired
private UserMapper userMapper;
@Override
public List<User> list() {
return userMapper.list();
}
@Override
public void save(User user) {
userMapper.save(user);
}
}
3、编写控制器类,直接调用保存数据方法,返回“保存成功”
@RequestMapping("/save")
@ResponseBody
public String save(){
User user = new User();
user.setEmail("924155240@qq.com");
user.setFullname("yansha");
user.setIsadmin(true);
user.setPassword("123456");
userService.save(user);
return "保存成功";
}
4、启动项目,访问/user/save方法,查看数据库。
表示数据插入成功了。接下来模拟异常的情况出现!
5、修改保存数据代码,故意除0
@Override
public void save(User user) {
userMapper.save(user);
int i = 10 % 0;
}