丽江文化旅游学院易腾创想Java实训第5组总结 (1)

小组成员分工

cuizishuo：主要完成项目功能测试
zengyingqing：主要完成环境配置和项目测试
wangyongfeng：主要完成阿里云OSS存储和总结报告
wuxuejiao：主要负责购票功能
linmengyi：主要负责登录功能
caoyuge：主要负责收藏功能

项目介绍

项目的主要功能为：
完成了Panda旅行网的登录功能、首页、景点详情、收藏、取消收藏、购票功能。

1.登录功能核心代码、运行效果截图如下：
核心代码：
UserMapper.java
@Repository
public interface UserMapper {
User findUserById(int id);
User getUserByUsernameAndPassword(User user);
}

UserMapper.xml


select * from user where id = #{id}


SELECT * FROM user WHERE username = #{username} AND password = #{password};

UserService.java
public interface UserService {
User queryUser(int id);
User getUserByUsernameAndPassword(User user);
}

UserServiceImpl.java
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper ;
@Override
public User queryUser(int id) {
User user = userMapper.findUserById(id);
return user;
}
@Override
public User getUserByUsernameAndPassword(User user) {
return userMapper.getUserByUsernameAndPassword(user);
}
}

UserController.java
@Controller
@RequestMapping(“user”)
public class UserController {
@Autowired
private UserService userService;
@GetMapping(“getUser”)
public String getUser(int id){
User user = userService.queryUser(id);
System.out.println(user);
return “front/user”;
}
@PostMapping(“login”)
public String getUser(User user, HttpServletRequest request, HttpSession session){
User u = userService.getUserByUsernameAndPassword(user);
System.out.println(u);
if (u!=null){
System.out.println(“登录成功”);
session.setAttribute(“user”,u);
String path = “redirect:/attraction/list”;
return path;
}else {
System.out.println(“登录失败”);
return “front/login”;
}
}

2.景点功能核心代码、运行效果截图如下：
AttractionMapper.java
@Repository
public interface AttractionMapper {
List getAttractions();
Attraction getAttractionById(int id);
long updateAttractionSales(Attraction attraction);
}

AttractionMapper.xml


SELECT * FROM attraction


SELECT *
FROM attraction
WHERE id = #{id}


UPDATE attraction
SET sales = #{sales}
WHERE id = #{id}

AttractionService.java
public interface AttractionSer