java项目之足球赛会管理系统(ssm+mysql+jsp)

**Java项目之足球赛会管理系统 (SSM + MySQL + JSP)****项目背景**

足球赛会管理系统是一款用于管理足球赛事的软件系统。该系统可以帮助管理员进行赛事的创建、修改、删除等操作，同时也可以提供用户登录和注册功能。

**技术选型**

本项目采用了 SSM (Spring + SpringMVC + MyBatis) 架构，使用 MySQL 作为数据库管理系统，JSP 作为前端视图技术。

### **1.项目结构**

markdownfootball-system|---- src| |---- main| | |---- java| | | |---- com| | | | |---- football| | | | | |---- controller (控制器)
| | | | | |---- entity (实体类)
| | | | | |---- service (服务层)
| | | |---- resources| | | |---- webapp| | | |---- WEB-INF| |---- test| |---- pom.xml|---- pom.xml

java// User.javapublic class User {
 private Integer id;
 private String username;
 private String password;

 // getter和setter方法}

// Match.javapublic class Match {
 private Integer id;
 private String matchName;
 private Date matchTime;

 // getter和setter方法}

java// UserService.java@Servicepublic class UserService {
 @Autowired private UserMapper userMapper;

 public List getAllUsers() {
 return userMapper.selectAll();
 }
}

// MatchService.java@Servicepublic class MatchService {
 @Autowired private MatchMapper matchMapper;

 public List getAllMatches() {
 return matchMapper.selectAll();
 }
}

java// UserController.java@Controller@RequestMapping("/user")
public class UserController {
 @Autowired private UserService userService;

 @GetMapping("/list")
 public String list(Model model) {
 List users = userService.getAllUsers();
 model.addAttribute("users", users);
 return "user/list";
 }
}

// MatchController.java@Controller@RequestMapping("/match")
public class MatchController {
 @Autowired private MatchService matchService;

 @GetMapping("/list")
 public String list(Model model) {
 List matches = matchService.getAllMatches();
 model.addAttribute("matches", matches);
 return "match/list";
 }
}

jsp<!-- user/list.jsp -->
<table>
 <tr>
 <th>ID</th>
 <th>Username</th>
 <th>Password</th>
 </tr>
 <c:forEach items="${users}" var="user">
 <tr>
 <td>${user.id}</td>
 <td>${user.username}</td>
 <td>${user.password}</td>
 </tr>
 </c:forEach>
</table>

<!-- match/list.jsp -->
<table>
 <tr>
 <th>ID</th>
 <th>Match Name</th>
 <th>Match Time</th>
 </tr>
 <c:forEach items="${matches}" var="match">
 <tr>
 <td>${match.id}</td>
 <td>${match.matchName}</td>
 <td>${match.matchTime}</td>
 </tr>
 </c:forEach>
</table>

sqlCREATE TABLE user (
 id INT PRIMARY KEY AUTO_INCREMENT,
 username VARCHAR(255),
 password VARCHAR(255)
);

CREATE TABLE match (
 id INT PRIMARY KEY AUTO_INCREMENT,
 matchName VARCHAR(255),
 matchTime DATE);

java// WebConfig.java@Configuration@EnableWebMvcpublic class WebConfig extends WebMvcConfigurerAdapter {
 @Override public void configureDefaultServletHandling(DefaultServletHandlerConfigurer configurer) {
 configurer.enable();
 }
}

java// UserMapper.java@Mapperpublic interface UserMapper {
 List selectAll();
}

// MatchMapper.java@Mapperpublic interface MatchMapper {
 List selectAll();
}