SpringBoot + MyBatis 实战：手把手教你从零搭建一个旅行社后台管理系统（附完整源码）

SpringBoot MyBatis 实战从零构建旅行社后台管理系统最近在技术社区看到不少开发者讨论如何将SpringBoot和MyBatis应用到实际项目中。作为Java生态中最受欢迎的两个框架它们的组合确实能大幅提升开发效率。今天我就带大家动手实现一个旅行社后台管理系统从环境搭建到功能实现全程保姆级指导最后还会提供完整源码。这个项目特别适合刚学完SpringBoot和MyBatis基础的同学练手。我们将使用IDEA作为开发工具JDK1.8环境整合SpringBoot 2.x和MyBatis 3.x实现包括用户认证、景点管理、旅游线路CRUD等核心功能。不同于简单的Demo这个项目会涉及分页插件、文件导入导出等实用功能让你获得真实的项目开发体验。1. 环境准备与项目初始化1.1 开发环境配置工欲善其事必先利其器。在开始编码前我们需要准备好开发环境JDK 1.8Oracle官方下载或使用OpenJDKIntelliJ IDEA推荐使用2021.x及以上版本Maven 3.6用于依赖管理MySQL 5.7/8.0数据库服务提示确保环境变量中已配置JAVA_HOME和MAVEN_HOME验证环境是否就绪java -version mvn -v1.2 创建SpringBoot项目在IDEA中新建项目选择Spring Initializr填写项目基本信息Group: com.travelArtifact: travel-managementType: Maven ProjectPackaging: Jar选择依赖项Spring WebMyBatis FrameworkMySQL DriverLombok简化POJO编写生成项目后检查pom.xml关键依赖dependencies dependency groupIdorg.springframework.boot/groupId artifactIdspring-boot-starter-web/artifactId /dependency dependency groupIdorg.mybatis.spring.boot/groupId artifactIdmybatis-spring-boot-starter/artifactId version2.2.0/version /dependency dependency groupIdmysql/groupId artifactIdmysql-connector-java/artifactId scoperuntime/scope /dependency /dependencies1.3 数据库设计我们先设计系统的主要数据表结构表名主要字段说明sys_userid, username, password, role系统用户表scenic_spotid, name, level, description景点信息表travel_routeid, name, start, end, days旅游线路表travel_groupid, route_id, start_date, status旅行团表创建数据库及表的SQLCREATE DATABASE travel_db CHARACTER SET utf8mb4; CREATE TABLE sys_user ( id int NOT NULL AUTO_INCREMENT, username varchar(50) NOT NULL, password varchar(100) NOT NULL, role varchar(20) DEFAULT user, PRIMARY KEY (id), UNIQUE KEY username (username) ) ENGINEInnoDB DEFAULT CHARSETutf8mb4;2. 核心功能实现2.1 用户认证模块用户认证是管理系统的门户我们采用经典的RBAC模型实现。实体类定义Data public class SysUser { private Integer id; private String username; private String password; private String role; // 使用Spring Security时可实现UserDetails接口 }Mapper接口Mapper public interface UserMapper { Select(SELECT * FROM sys_user WHERE username #{username}) SysUser findByUsername(String username); }Service层实现Service public class AuthService { Autowired private UserMapper userMapper; public SysUser authenticate(String username, String password) { SysUser user userMapper.findByUsername(username); if(user ! null password.equals(user.getPassword())) { return user; } return null; } }Controller处理登录请求RestController RequestMapping(/api/auth) public class AuthController { PostMapping(/login) public ResponseEntity? login(RequestBody LoginRequest request) { SysUser user authService.authenticate(request.getUsername(), request.getPassword()); if(user null) { return ResponseEntity.status(401).body(用户名或密码错误); } // 生成JWT token或设置session return ResponseEntity.ok(user); } }2.2 景点管理模块景点管理是系统的核心功能需要实现CRUD操作和分页查询。分页查询实现添加PageHelper依赖dependency groupIdcom.github.pagehelper/groupId artifactIdpagehelper-spring-boot-starter/artifactId version1.4.1/version /dependencyService层实现分页public PageInfoScenicSpot listSpots(int pageNum, int pageSize) { PageHelper.startPage(pageNum, pageSize); ListScenicSpot spots spotMapper.selectAll(); return new PageInfo(spots); }Controller接口GetMapping(/spots) public PageInfoScenicSpot listSpots( RequestParam(defaultValue 1) int page, RequestParam(defaultValue 10) int size) { return spotService.listSpots(page, size); }文件上传处理景点图片PostMapping(/spots/{id}/image) public String uploadImage(PathVariable Integer id, RequestParam MultipartFile file) { if (!file.isEmpty()) { String filename storeImage(file); // 自定义存储逻辑 spotMapper.updateImage(id, filename); return 上传成功; } return 文件不能为空; }3. 高级功能实现3.1 旅游线路导入导出实际业务中经常需要批量导入导出数据我们使用Apache POI实现Excel操作。导出Excel实现添加POI依赖dependency groupIdorg.apache.poi/groupId artifactIdpoi-ooxml/artifactId version5.2.2/version /dependency导出服务实现public void exportRoutes(HttpServletResponse response) throws IOException { ListTravelRoute routes routeMapper.selectAll(); Workbook workbook new XSSFWorkbook(); Sheet sheet workbook.createSheet(旅游线路); // 创建表头 Row headerRow sheet.createRow(0); headerRow.createCell(0).setCellValue(ID); headerRow.createCell(1).setCellValue(线路名称); // 填充数据 for(int i0; iroutes.size(); i) { Row row sheet.createRow(i1); row.createCell(0).setCellValue(routes.get(i).getId()); row.createCell(1).setCellValue(routes.get(i).getName()); } response.setContentType(application/vnd.openxmlformats-officedocument.spreadsheetml.sheet); response.setHeader(Content-Disposition, attachment; filenameroutes.xlsx); workbook.write(response.getOutputStream()); workbook.close(); }导入Excel实现PostMapping(/routes/import) public String importRoutes(RequestParam MultipartFile file) throws IOException { Workbook workbook new XSSFWorkbook(file.getInputStream()); Sheet sheet workbook.getSheetAt(0); ListTravelRoute routes new ArrayList(); for(Row row : sheet) { if(row.getRowNum() 0) continue; // 跳过表头 TravelRoute route new TravelRoute(); route.setName(row.getCell(1).getStringCellValue()); routes.add(route); } routeMapper.batchInsert(routes); return 导入成功共routes.size()条记录; }3.2 缓存优化为提高系统性能我们引入Redis缓存热门景点数据。添加Redis依赖dependency groupIdorg.springframework.boot/groupId artifactIdspring-boot-starter-data-redis/artifactId /dependency配置缓存服务Service CacheConfig(cacheNames spots) public class SpotService { Cacheable(key hot) public ListScenicSpot getHotSpots() { return spotMapper.selectHotSpots(); } CacheEvict(allEntries true) public void refreshCache() { // 清空缓存 } }在application.properties中配置Redisspring.redis.hostlocalhost spring.redis.port63794. 系统安全与部署4.1 安全防护密码加密存储public class PasswordUtil { private static final BCryptPasswordEncoder encoder new BCryptPasswordEncoder(); public static String encode(String rawPassword) { return encoder.encode(rawPassword); } public static boolean matches(String rawPassword, String encodedPassword) { return encoder.matches(rawPassword, encodedPassword); } }接口权限控制Configuration EnableWebSecurity public class SecurityConfig extends WebSecurityConfigurerAdapter { Override protected void configure(HttpSecurity http) throws Exception { http.authorizeRequests() .antMatchers(/api/admin/**).hasRole(ADMIN) .antMatchers(/api/**).authenticated() .anyRequest().permitAll() .and() .formLogin() .loginProcessingUrl(/api/auth/login); } }4.2 系统部署打包应用mvn clean packageDocker部署FROM openjdk:8-jdk-alpine COPY target/travel-management.jar app.jar ENTRYPOINT [java,-jar,/app.jar]构建并运行容器docker build -t travel-app . docker run -p 8080:8080 -d travel-app5. 项目扩展与优化建议在实际开发中我们还可以进一步完善系统前端分离开发使用Vue/React构建管理后台微服务改造将用户服务、景点服务等拆分为独立服务监控集成添加Spring Boot Actuator和Prometheus监控日志收集集成ELK栈实现日志集中管理项目完整源码已托管在GitHub包含数据库脚本和Postman接口文档。通过这个项目你不仅能掌握SpringBoot和MyBatis的核心用法还能学习到企业级应用开发的完整流程。