devbox
盐析白兔
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

JavaWeb项目：航班信息管理系统（tomcat+jsp）_javaweb航空管理系统

作者：盐析白兔 | 2024-04-24 18:07:38

赞

踩

javaweb航空管理系统

一：项目业务需求

航班信息管理系统是学习Javaweb的一个小项目，首先对该项目的业务需求进行分析，根据项目文档知它的主要实现技术为 SERVLET、JSP、MVC 架构、JDBC 和 MySQL。该项目着重学生的实际应用场景来设计，模拟 机场中的航班系统的业务实现以及扩展，能够实现航班信息管理的的所有功能，包括航班信息，航 班目的地查询等功能的实现；

本项目共实现八大功能模块

  注册模块：用户输入用户名，真实姓名，密码进行注册，注册验证通过后，将用户存储到数据库中，如果数据库中已有相同用户名，则需要重新注册。

登录模块：对管理员输入的用户名，密码进行验证，验证通过后，管理员可以使用航班信息管 理系统中所有权限的功能，否则重新登录该系统。

航班信息管理功能：管理员登录成功，可以查询所有航班信息。 .

新增航班信息功能：管理员登录成功，可以新增航班信息，新增完毕以后跳转到主页面显示所

以航班信息

删除航班信息功能：管理员登录成功，可以删除航班信息，删除完毕以后跳转到主页面显示所 以航班信息

修改航班信息功能：管理员登录成功，可以修改航班信息，修改完毕以后跳转到主页面显示所 以航班信息

根据目的地查询功能：管理员登录成功，可以根据目的地对航班信息进行查询。

根据起飞时间查询功能：管理员登录成功，可以根据起飞时间对航班信息进行查询。

二：项目逻辑实现

 在实现逻辑之前，先看一下项目演示

航班信息管理系统演示

项目演示完毕，我们分模块进行代码实现

首先，先看一下项目架构

后端

后端工程采用mvc架构，分别是bean（实体类）dao（处理类）service（服务类）servlet（启动类），util（工具类）以及一个jdbc连接数据库的测试类。

前端

前端页面采用jsp页面和css样式

其中在WEB-INF文件夹中创建一个lib目录并引入三个jar包，右键lib目录点击 add libary

下面，我们开始写代码

首先创建实体类

User

  1. package com.ambow.bean;
  2.  
  3. public class User {
  4.     private int userId;
  5.     private String userName;
  6.     private String password;
  7.     private String realName;
  8.  
  9.     public int getUserId() {
  10.         return userId;
  11.     }
  12.  
  13.     public void setUserId(int userId) {
  14.         this.userId = userId;
  15.     }
  16.  
  17.     public String getUserName() {
  18.         return userName;
  19.     }
  20.  
  21.     public void setUserName(String userName) {
  22.         this.userName = userName;
  23.     }
  24.  
  25.     public String getPassword() {
  26.         return password;
  27.     }
  28.  
  29.     public void setPassword(String password) {
  30.         this.password = password;
  31.     }
  32.  
  33.     public String getRealName() {
  34.         return realName;
  35.     }
  36.  
  37.     public void setRealName(String realName) {
  38.         this.realName = realName;
  39.     }
  40. }

Flight

  1. package com.ambow.bean;
  2.  
  3. import java.util.Date;
  4.  
  5. public class Flight {
  6.     private int idFlight;  //航班编号
  7.     private int flightId; //航班号
  8.     private String destination;  //目的地
  9.     private Date takeName;  //起飞时间
  10.     public int getIdFlight() {
  11.         return idFlight;
  12.     }
  13.  
  14.     public void setIdFlight(int idFlight) {
  15.         this.idFlight = idFlight;
  16.     }
  17.  
  18.     public int getFlightId() {
  19.         return flightId;
  20.     }
  21.  
  22.     public void setFlightId(int flightId) {
  23.         this.flightId = flightId;
  24.     }
  25.  
  26.     public String getDestination() {
  27.         return destination;
  28.     }
  29.  
  30.     public void setDestination(String destination) {
  31.         this.destination = destination;
  32.     }
  33.  
  34.     public Date getTakeName() {
  35.         return takeName;
  36.     }
  37.  
  38.     public void setTakeName(Date takeName) {
  39.         this.takeName = takeName;
  40.     }
  41. }

实体类写完，我们开始写Dao层，写Dao层的类需要连接数据库

我们先来测试一下数据库是否能连接成功，输入以下代码测试数据库连接是否成功

  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.SQLException;
  4.  
  5. public class jdbcTest {
  6.     public static void conn(){
  7.         Connection connection;
  8.         String url = "jdbc:mysql://localhost:3306/flightinformationmanagesystem";   //数据库连接的url地址
  9.         String user = "root";   //数据库用户名
  10.         String password = "123456";  //数据库密码
  11.         try {
  12.             //加载数据库驱动
  13.             Class.forName("com.mysql.cj.jdbc.Driver");
  14.             System.out.println("数据库驱动加载成功！");
  15.         }catch (ClassNotFoundException e) {
  16.             e.printStackTrace();
  17.         }
  18.         try{
  19.             //通过DriverManager获取数据库连接
  20.             connection = DriverManager.getConnection(url,user,password);
  21.             System.out.println("数据库连接成功！");
  22.         }catch (SQLException e) {
  23.             e.printStackTrace();
  24.         }
  25.     }
  26.  
  27.     public static void main(String[] args) {
  28.         jdbcTest.conn();
  29.     }
  30. }

输出

说明数据库连接成功

下面我们开始写Dao层代码

首先，创建一个连接数据库的工具类，将数据库连接封装到一个工具类中

  1. package com.ambow.util;
  2.  
  3. import java.sql.*;
  4.  
  5. /*
  6. 封装数据库
  7.  */
  8. public class DBConnection {
  9.     private static final String username = "root";
  10.     private static final String password = "123456";
  11.     private static final String url = "jdbc:mysql://localhost:3306/flightinformationmanagesystem";
  12.     //加载数据库驱动
  13.     public static void main(String[] args) {
  14.         try{
  15.             Class.forName("com.mysql.jdbc.Driver");
  16.         }catch (ClassNotFoundException e){
  17.             e.printStackTrace();
  18.         }
  19.     }
  20.     //获取数据库连接方法
  21.     public static Connection getConnection(){
  22.         Connection connection = null;
  23.         try {
  24.             connection = DriverManager.getConnection(url,username,password);
  25.         }catch (SQLException e){
  26.             e.printStackTrace();
  27.         }
  28.         return connection;
  29.     }
  30.     //数据库释放三个资源
  31.     public static void closeAll(Connection connection, PreparedStatement preparedStatement, ResultSet resultSet){
  32.         try{
  33.             if (connection != null){
  34.                 connection.close();
  35.             }
  36.             if (preparedStatement != null){
  37.                 preparedStatement.close();
  38.             }
  39.             if (resultSet != null){
  40.                 resultSet.close();
  41.             }
  42.         }catch (SQLException e){
  43.             e.printStackTrace();
  44.         }
  45.     }
  46.     //数据库释放两个资源
  47.     public static void closeTwo(Connection connection, PreparedStatement preparedStatement){
  48.         try{
  49.             if (connection != null){
  50.                 connection.close();
  51.             }
  52.             if (preparedStatement != null){
  53.                 preparedStatement.close();
  54.             }
  55.         }catch (SQLException e){
  56.             e.printStackTrace();
  57.         }
  58.  
  59.     }
  60. }

当连接数据库时，我们调用工具类进行连接

先写RegisterDao

  1. package com.ambow.dao;
  2.  
  3. import com.ambow.util.DBConnection;
  4.  
  5. import java.sql.Connection;
  6. import java.sql.PreparedStatement;
  7. import java.sql.SQLException;
  8.  
  9. public class RegisterDao {
  10.     //注册功能
  11.     public boolean register(String username,String password, String realname){
  12.  
  13.         String sql = "insert into flightinformationmanagesystem.user(loginname, password, realname) values (?,?,?)";
  14.         Connection connection = null;
  15.         PreparedStatement preparedStatement = null;
  16.         try{
  17.             connection = DBConnection.getConnection();
  18.             preparedStatement = connection.prepareStatement(sql);
  19.             preparedStatement.setString(1,username);
  20.             preparedStatement.setString(2,password);
  21.             preparedStatement.setString(3,realname);
  22.             int resultSet = preparedStatement.executeUpdate();
  23.             return resultSet > 0;
  24.         }catch (SQLException e){
  25.             e.printStackTrace();
  26.         }finally {
  27.             DBConnection.closeTwo(connection,preparedStatement);
  28.         }
  29.         return false;
  30.  
  31.     }
  32. }

然后是UserDao

  1. package com.ambow.dao;
  2.  
  3. import com.ambow.bean.User;
  4. import com.ambow.util.DBConnection;
  5.  
  6. import java.sql.Connection;
  7. import java.sql.PreparedStatement;
  8. import java.sql.ResultSet;
  9. import java.sql.SQLException;
  10.  
  11. public class UserDao {
  12.     //登录功能
  13.     public User selectByNameAndPassword(String loginname, String password){
  14.         User user = new User();
  15.         String sql = "select * from flightinformationmanagesystem.user where loginname=? and password=?";
  16.         Connection connection = null;
  17.         PreparedStatement preparedStatement = null;
  18.         ResultSet resultSet = null;
  19.         try{
  20.             //获取数据库连接对象
  21.             connection = DBConnection.getConnection();
  22.             //预编译
  23.             preparedStatement = connection.prepareStatement(sql);
  24.             //给参数赋值
  25.             preparedStatement.setString(1,loginname);
  26.             preparedStatement.setString(2,password);
  27.             resultSet = preparedStatement.executeQuery();
  28.             if (resultSet.next()){
  29.                 //创建用户对象
  30.                 user.setUserId(resultSet.getInt(1));  //1代表数据库中的第一列
  31.                 user.setUserName(resultSet.getString(2));  //2代表第二列
  32.                 user.setPassword(resultSet.getString(3));
  33.                 user.setRealName(resultSet.getString(4));
  34.             }
  35.         }catch (SQLException e){
  36.             e.printStackTrace();
  37.         }
  38.         finally {
  39.             DBConnection.closeAll(connection,preparedStatement,resultSet);
  40.         }
  41.         return user;
  42.     }
  43. }

FlightDao

  1. package com.ambow.dao;
  2.  
  3. import com.ambow.bean.Flight;
  4. import com.ambow.util.DBConnection;
  5.  
  6. import java.sql.*;
  7. import java.util.ArrayList;
  8. import java.util.List;
  9.  
  10. public class FlightDao {
  11.     // 查找全部航班信息
  12.     public static List<Flight> selectAll() {
  13.         String sql = "SELECT * FROM flightinformationmanagesystem.flight";
  14.         Connection conn = null;
  15.         PreparedStatement ps = null;
  16.         ResultSet rs = null;
  17.         List<Flight> flightList = new ArrayList<>();
  18.         try {
  19.             // 获取数据库连接对象
  20.             conn = DBConnection.getConnection();
  21.             // 预编译并执行查询语句
  22.             ps = conn.prepareStatement(sql);
  23.             rs = ps.executeQuery();
  24.  
  25.             // 处理查询结果
  26.             while (rs.next()) {
  27.                 Flight flight = new Flight();
  28.                 flight.setIdFlight(rs.getInt(1));
  29.                 flight.setFlightId(rs.getInt(2));
  30.                 flight.setDestination(rs.getString(3));
  31.                 flight.setTakeName(rs.getDate(4));
  32.                 flightList.add(flight);
  33.             }
  34.         } catch (SQLException e) {
  35.             throw new RuntimeException(e);
  36.         } finally {
  37.             // 关闭资源
  38.             DBConnection.closeAll(conn, ps, rs);
  39.         }
  40.         return flightList;
  41.     }
  42.  
  43.     //按目的地查询航班信息
  44.     public static List<Flight> selectAllByDestination(Flight flight){
  45.         String sql = "select * from flightinformationmanagesystem.flight where destination=?";
  46.         Connection connection = null;
  47.         PreparedStatement preparedStatement = null;
  48.         ResultSet resultSet = null;
  49.         List<Flight> flightList = new ArrayList<>();
  50.         try{
  51.             //获取数据库连接对象
  52.             connection = DBConnection.getConnection();
  53.             preparedStatement = connection.prepareStatement(sql);
  54.             preparedStatement.setString(1, flight.getDestination());
  55.             resultSet = preparedStatement.executeQuery();
  56.             while (resultSet.next()){
  57.                 flight.setIdFlight(resultSet.getInt("id"));
  58.                 flight.setFlightId(resultSet.getInt("flightid"));
  59.                 flight.setDestination(resultSet.getString("destination"));
  60.                 flight.setTakeName(resultSet.getDate("taketime"));
  61.                 flightList.add(flight); // 将新对象添加到列表
  62.             }
  63.  
  64.  
  65.         }catch (SQLException e){
  66.             e.printStackTrace();
  67.         }finally {
  68.             DBConnection.closeAll(connection,preparedStatement,resultSet);
  69.         }
  70.         return flightList;
  71.     }
  72.     //按起飞时间查询航班信息
  73.     public static List<Flight> selectAllByTaketime(Flight flight){
  74.         String sql = "select * from flightinformationmanagesystem.flight where taketime=?";
  75.         Connection connection = null;
  76.         PreparedStatement preparedStatement = null;
  77.         ResultSet resultSet = null;
  78.         List<Flight> flightList = new ArrayList<>();
  79.         try{
  80.             //获取数据库连接对象
  81.             connection = DBConnection.getConnection();
  82.             preparedStatement = connection.prepareStatement(sql);
  83.  
  84.             preparedStatement.setDate(1, new java.sql.Date(flight.getTakeName().getTime()));
  85.             resultSet = preparedStatement.executeQuery();
  86.             while (resultSet.next()){
  87.                 flight.setIdFlight(resultSet.getInt("id"));
  88.                 flight.setFlightId(resultSet.getInt("flightid"));
  89.                 flight.setDestination(resultSet.getString("destination"));
  90.                 flight.setTakeName(resultSet.getDate("taketime"));
  91.                 flightList.add(flight); // 将新对象添加到列表
  92.             }
  93.  
  94.  
  95.         }catch (SQLException e){
  96.             e.printStackTrace();
  97.         }finally {
  98.             DBConnection.closeAll(connection,preparedStatement,resultSet);
  99.         }
  100.         return flightList;
  101.     }
  102.     //按ID查询航班信息
  103.     public  Flight selectById(int flightId){
  104.         String sql = "select * from flightinformationmanagesystem.flight where id=?";
  105.         Connection connection = null;
  106.         PreparedStatement preparedStatement = null;
  107.         ResultSet resultSet = null;
  108.         Flight flight = null;
  109.         try{
  110.             //获取数据库连接对象
  111.             connection = DBConnection.getConnection();
  112.             preparedStatement = connection.prepareStatement(sql);
  113.             preparedStatement.setInt(1, flightId);
  114.             resultSet = preparedStatement.executeQuery();
  115.             while (resultSet.next()){
  116.                 flight = new Flight();
  117.                 flight.setFlightId(resultSet.getInt("flightid"));
  118.                 flight.setDestination(resultSet.getString("destination"));
  119.                 flight.setTakeName(resultSet.getDate("taketime"));
  120.  
  121.             }
  122.  
  123.         }catch (SQLException e){
  124.             e.printStackTrace();
  125.         }finally {
  126.             DBConnection.closeAll(connection,preparedStatement,resultSet);
  127.         }
  128.         return flight;
  129.     }
  130.     //增加航班
  131.     public static int add(Flight flight){
  132.         String sql = "insert into flightinformationmanagesystem.flight(flightid, destination, taketime) values(?,?,?)";
  133.         Connection connection = null;
  134.         PreparedStatement preparedStatement = null;
  135.         int flag = 0;
  136.         try{
  137.             //获取数据库连接对象
  138.             connection = DBConnection.getConnection();
  139.             preparedStatement = connection.prepareStatement(sql);
  140.             preparedStatement.setInt(1, flight.getFlightId());
  141.             preparedStatement.setString(2, flight.getDestination());
  142.             preparedStatement.setDate(3,new java.sql.Date(flight.getTakeName().getTime()));
  143.             flag = preparedStatement.executeUpdate();
  144.         }catch (SQLException e){
  145.             e.printStackTrace();
  146.         }finally {
  147.             DBConnection.closeTwo(connection,preparedStatement);
  148.         }
  149.         return flag;
  150.     }
  151.     //修改航班
  152.     public static int update(Flight flight){
  153.         String sql = "update flightinformationmanagesystem.flight SET destination=?,taketime=? where flightid=?";
  154.         Connection connection = null;
  155.         PreparedStatement preparedStatement = null;
  156.         int flag = 0;
  157.         try{
  158.             connection = DBConnection.getConnection();
  159.             preparedStatement = connection.prepareStatement(sql);
  160.             preparedStatement.setString(1, flight.getDestination());
  161.             preparedStatement.setDate(2,new java.sql.Date(flight.getTakeName().getTime()));
  162.             preparedStatement.setInt(3, flight.getFlightId());
  163.             flag = preparedStatement.executeUpdate();
  164.  
  165.         }catch (SQLException e){
  166.             e.printStackTrace();
  167.         }finally {
  168.             DBConnection.closeTwo(connection,preparedStatement);
  169.         }
  170.         return flag;
  171.     }
  172.     //删除航班
  173.     public static int delete(Flight flight){
  174.         String sql = "delete from flightinformationmanagesystem.flight where id=?";
  175.         Connection connection = null;
  176.         PreparedStatement preparedStatement = null;
  177.         int flag = 0;
  178.         try{
  179.             connection = DBConnection.getConnection();
  180.             preparedStatement = connection.prepareStatement(sql);
  181.             preparedStatement.setInt(1, flight.getIdFlight());
  182.             flag = preparedStatement.executeUpdate();
  183.         }catch (SQLException e){
  184.             e.printStackTrace();
  185.         }finally {
  186.             DBConnection.closeTwo(connection,preparedStatement);
  187.         }
  188.         return flag;
  189.     }
  190. }

下面写Service层

首先是RegisterService

  1. package com.ambow.service;
  2.  
  3. import com.ambow.bean.User;
  4. import com.ambow.dao.RegisterDao;
  5. import com.ambow.util.DBConnection;
  6.  
  7. import java.sql.Connection;
  8. import java.sql.PreparedStatement;
  9. import java.sql.ResultSet;
  10. import java.sql.SQLException;
  11.  
  12. public class RegisterService {
  13.     //判断用户是否存在
  14.     public User userIsExist(String username){
  15.         String sql = "select loginname from flightinformationmanagesystem.user where loginname =?";
  16.         User user = null;
  17.         Connection connection = null;
  18.         PreparedStatement preparedStatement =null;
  19.         ResultSet resultSet = null;
  20.         try{
  21.             connection = DBConnection.getConnection();
  22.             preparedStatement = connection.prepareStatement(sql);
  23.             preparedStatement.setString(1,username);
  24.             resultSet = preparedStatement.executeQuery();
  25.             while (resultSet.next()){
  26.                 user = new User();
  27.                 user.setUserName(resultSet.getString("loginname"));
  28.             }
  29.         }catch (SQLException e){
  30.             e.printStackTrace();
  31.         }
  32.         finally {
  33.             DBConnection.closeAll(connection,preparedStatement,resultSet);
  34.         }
  35.         return user;
  36.     }
  37.     //调用RegisterDao类
  38.     RegisterDao registerDao = new RegisterDao();
  39.     public Boolean Register(String username,String password,String realname){
  40.         boolean isSuccess = registerDao.register(username,password,realname);
  41.         if (isSuccess){
  42.             return isSuccess;
  43.         }
  44.         return null;
  45.     }
  46.  
  47. }

UserService

  1. package com.ambow.service;
  2.  
  3. import com.ambow.bean.User;
  4. import com.ambow.dao.UserDao;
  5. import com.ambow.util.DBConnection;
  6.  
  7. import java.sql.Connection;
  8. import java.sql.PreparedStatement;
  9. import java.sql.ResultSet;
  10. import java.sql.SQLException;
  11.  
  12. public class UserService {
  13.     public User userIsExist(String username){
  14.         String sql = "select loginname from flightinformationmanagesystem.user where loginname =?";
  15.         User user = null;
  16.         Connection connection = null;
  17.         PreparedStatement preparedStatement =null;
  18.         ResultSet resultSet = null;
  19.         try{
  20.             connection = DBConnection.getConnection();
  21.             preparedStatement = connection.prepareStatement(sql);
  22.             preparedStatement.setString(1,username);
  23.             preparedStatement.executeQuery();
  24.             while (resultSet.next()){
  25.                 user = new User();
  26.                 user.setUserName(resultSet.getString("loginname"));
  27.             }
  28.         }catch (SQLException e){
  29.             e.printStackTrace();
  30.         }
  31.         finally {
  32.             DBConnection.closeAll(connection,preparedStatement,resultSet);
  33.         }
  34.         return user;
  35.     }
  36.  
  37.     //调用UserDao类
  38.     UserDao userDao = new UserDao();
  39.     //service层的selectByNameAndPassword方法
  40.     public User selectByNameAndPassword(String userName, String Password){
  41.         //调用UserDao类的selectByNameAndPassword方法
  42.         User isSuccess = userDao.selectByNameAndPassword(userName,Password);
  43.         //如果isSuccess不为空且密码相等，返回应该isSuccess
  44.         if (isSuccess != null && Password.equals(isSuccess.getPassword())){
  45.             return isSuccess;
  46.         }
  47.         return null;
  48.     }
  49. }

FlightService

  1. package com.ambow.service;
  2.  
  3. import com.ambow.bean.Flight;
  4. import com.ambow.dao.FlightDao;
  5.  
  6. import java.util.Date;
  7. import java.util.List;
  8.  
  9. public class FlightService {
  10.     FlightDao flightDao = new FlightDao();
  11.     //查询所有航班信息
  12.     public List<Flight> selectAll(){
  13.         List<Flight> flightList = FlightDao.selectAll();
  14.         return flightList;
  15.     }
  16.     //通过id查询航班信息
  17.     public Flight selectById(int flightId){
  18.  
  19.         Flight flight = flightDao.selectById(flightId);
  20.         return flight;
  21.     }
  22.     //通过目的地查询航班信息
  23.     public List<Flight> selectByDestination(String destination){
  24.         Flight flight =new Flight();
  25.         flight.setDestination(destination);
  26.         List<Flight> flightList = FlightDao.selectAllByDestination(flight);
  27.         return flightList;
  28.     }
  29.     //通过起飞时间查询航班信息
  30.  
  31.     public List<Flight> selectByTaketime(Flight flight){
  32.         List<Flight> flightList = FlightDao.selectAllByTaketime(flight);
  33.         return flightList;
  34.     }
  35.  
  36.     //增加航班信息
  37.     public boolean add(Flight flight){
  38.         int flag = FlightDao.add(flight);
  39.         if(flag == 1){
  40.             return true;
  41.         }else {
  42.             return false;
  43.         }
  44.     }
  45.     //修改航班信息
  46.     public boolean update(Flight flight){
  47.         int flag = FlightDao.update(flight);
  48.         if(flag == 1){
  49.             return true;
  50.         }else {
  51.             return false;
  52.         }
  53.     }
  54.     //删除航班信息
  55.     public boolean delete(Flight flight){
  56.         int flag = FlightDao.delete(flight);
  57.         if(flag == 1){
  58.             return true;
  59.         }else {
  60.             return false;
  61.         }
  62.     }
  63. }

 然后是servlet层

servlet层代码较多，我们慢慢来

RegisterServlet

  1. package com.ambow.servlet;
  2.  
  3. import com.ambow.bean.User;
  4. import com.ambow.service.RegisterService;
  5.  
  6. import javax.servlet.ServletException;
  7. import javax.servlet.annotation.WebServlet;
  8. import javax.servlet.http.HttpServlet;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  11. import java.io.IOException;
  12.  
  13. @WebServlet(name = "RegisterServlet",urlPatterns = "/RegisterServlet")
  14. public class RegisterServlet extends HttpServlet {
  15.     @Override
  16.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  17.  
  18.     }
  19.  
  20.     @Override
  21.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  22.         //设置字符编码，防止乱码
  23.         request.setCharacterEncoding("UTF-8");
  24.         response.setContentType("text/html;charset=UTF-8");
  25.         //获取表单信息
  26.         String username = request.getParameter("username");
  27.         String realname = request.getParameter("fullname");
  28.         String password = request.getParameter("password");
  29.         //检查用户名和密码是否为空
  30.         if (username == null || username.isEmpty() || password == null || password.isEmpty()) {
  31.           String scr ="<script>alert('用户名和密码不能为空！');window.location.href='register.jsp'</script>";
  32.           response.getWriter().write(scr);
  33.         }else{
  34.             //调用Register类进行注册
  35.             RegisterService registerService = new RegisterService();
  36.             //检查用户名是否已经存在
  37.             User userIsExist = registerService.userIsExist(username);
  38.             if (userIsExist != null){
  39.                String scrs =  "<script>alert('用户名已经存在，请选择其他用户名！');window.location.href='register.jsp'</script>";
  40.                response.getWriter().write(scrs);
  41.             }else {
  42.                 //注册用户
  43.                 Boolean register = registerService.Register(username, password, realname);
  44.                 if (register){
  45.                  String scri ="<script>alert('注册成功！');window.location.href='login.jsp'</script>";
  46.                  response.getWriter().write(scri);
  47.                 }else {
  48.                     String scrip ="<script>alert('注册失败！');window.location.href='register.jsp'</script>";
  49.                     response.getWriter().write(scrip);
  50.                 }
  51.             }
  52.             
  53.         }
  54.     }
  55. }

UerServlet

  1. package com.ambow.servlet;
  2.  
  3. import com.ambow.bean.User;
  4. import com.ambow.service.UserService;
  5.  
  6. import javax.servlet.ServletException;
  7. import javax.servlet.annotation.WebServlet;
  8. import javax.servlet.http.HttpServlet;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  11. import java.io.IOException;
  12. @WebServlet(name = "LoginServlet",urlPatterns = "/LoginServlet")
  13. public class UserServlet extends HttpServlet {
  14.     @Override
  15.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  16.         //设置中文字符，防止乱码
  17.         request.setCharacterEncoding("UTF-8");
  18.         response.setContentType("text/html;charset=utf-8");
  19.         //提交客户端信息
  20.         String userName = request.getParameter("username");
  21.         String password = request.getParameter("password");
  22.         // 检查用户名和密码是否为空
  23.         if (userName == null || userName.isEmpty() || password == null || password.isEmpty()){
  24.             String scr ="<script>alert('用户名或密码为空！');window.location.href='login.jsp'</script>";
  25.             response.getWriter().write(scr);
  26.         }else {
  27.             //调用UserService
  28.             UserService userService = new UserService();
  29.             User user = userService.selectByNameAndPassword(userName,password);
  30.  
  31.             if(user != null){
  32. //                request.setAttribute("user",userName);
  33. //                response.sendRedirect("main.jsp");
  34.                  //设置登录成功的标志
  35.                 request.setAttribute("loginSuccessful", true);
  36.                 request.getSession().setAttribute("user", user); // 将用户存储到 session 中，以便在后续请求中使用
  37.                 response.sendRedirect(request.getContextPath() + "/FlightServlet"); // 执行重定向到 /FlightServlet 路径
  38.             }else {
  39.                String scr ="<script>alert('用户名或密码错误，请仔细检查后登录！');window.location.href='login.jsp'</script>";
  40.                response.getWriter().write(scr);
  41.             }
  42.         }
  43.  
  44.  
  45.     }
  46.  
  47.     @Override
  48.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  49.         doGet(request,response);
  50.     }
  51. }

LoginOutServlet

  1. package com.ambow.servlet;
  2.  
  3. import javax.servlet.ServletException;
  4. import javax.servlet.annotation.WebServlet;
  5. import javax.servlet.http.HttpServlet;
  6. import javax.servlet.http.HttpServletRequest;
  7. import javax.servlet.http.HttpServletResponse;
  8. import javax.servlet.http.HttpSession;
  9. import java.io.IOException;
  10. @WebServlet(name = "LogoutServlet", urlPatterns = "/LogoutServlet")
  11. public class LoginOutServlet extends HttpServlet {
  12.     @Override
  13.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  14.         performLogout(request,response);
  15.     }
  16.  
  17.     @Override
  18.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  19.         performLogout(request,response);
  20.     }
  21.  
  22.     private void performLogout(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  23.         HttpSession session = request.getSession();
  24.  
  25.          //清除 session 中的用户信息
  26.         session.removeAttribute("user");
  27.  
  28. //        // 或者直接使整个 session 失效
  29. //         session.invalidate();
  30.  
  31.         // 重定向到登录页面或其他页面
  32.         response.sendRedirect(request.getContextPath() + "/login.jsp");
  33.     }
  34. }

 AddServlet

  1. package com.ambow.servlet;
  2.  
  3. import com.ambow.bean.Flight;
  4. import com.ambow.service.FlightService;
  5.  
  6. import javax.servlet.ServletException;
  7. import javax.servlet.annotation.WebServlet;
  8. import javax.servlet.http.HttpServlet;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  11. import java.io.IOException;
  12. import java.text.ParseException;
  13. import java.text.SimpleDateFormat;
  14. import java.util.Date;
  15.  
  16. @WebServlet(name = "AddFlightServlet",urlPatterns = "/AddFlightServlet")
  17. public class AddFlightServlet extends HttpServlet {
  18.     @Override
  19.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  20.  
  21.     }
  22.  
  23.     @Override
  24.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  25.         //设置编码格式
  26.         request.setCharacterEncoding("UTF-8");
  27.         response.setContentType("text/html;charset=utf-8");
  28.         //获取客户端信息
  29.         String flightid = request.getParameter("flightId");
  30.         String destination = request.getParameter("destination");
  31.         String taketime = request.getParameter("takeoffTime");
  32.         //实例化Flight对象并设置属性
  33.         Flight flight = new Flight();
  34.         //将字符串类型转换成整形
  35.         flight.setFlightId(Integer.parseInt(flightid));
  36.         flight.setDestination(destination);
  37.         //将字符串类型转换成Date类型
  38.         SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
  39.         Date taketimes =null;
  40.         try{
  41.              taketimes = simpleDateFormat.parse(taketime);
  42.         }catch (ParseException e){
  43.             e.printStackTrace();
  44.         }
  45.         flight.setTakeName(taketimes);
  46.         //调用FlightService类
  47.         FlightService flightService = new FlightService();
  48.         boolean isAddSuccess = flightService.add(flight);
  49.         if (isAddSuccess){
  50.             // 重定向到航班信息页面
  51.             response.sendRedirect(request.getContextPath() + "/FlightServlet");
  52.         }else {
  53.             String scr = "<script>alert('航班信息添加失败，请重试！');window.location.href='AddFlight.jsp'</script>";
  54.             response.getWriter().write(scr);
  55.         }
  56. //        //获取返回主页面按钮
  57. //        String btn = request.getParameter("back");
  58. //        if ("back".equals(btn)){
  59. //            // 重定向到航班信息页面
  60. //            response.sendRedirect(request.getContextPath() + "/FlightServlet");
  61. //        }
  62.  
  63.     }
  64. }

 DeleteServlet

  1. package com.ambow.servlet;
  2.  
  3. import com.ambow.bean.Flight;
  4. import com.ambow.service.FlightService;
  5.  
  6. import javax.servlet.ServletException;
  7. import javax.servlet.annotation.WebServlet;
  8. import javax.servlet.http.HttpServlet;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  11. import java.io.IOException;
  12. @WebServlet(name = "DeleteFlightServlet", urlPatterns = "/DeleteFlightServlet")
  13. public class DeleteFlightServlet extends HttpServlet {
  14.     @Override
  15.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  16.  
  17.     }
  18.  
  19.     @Override
  20.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  21.         //获取要删除的航班id
  22.         int idFlight = Integer.parseInt(request.getParameter("flightId"));
  23.         //调用FlightService类中的delete方法进行删除
  24.         FlightService flightService = new FlightService();
  25.         Flight flight = new Flight();
  26.         flight.setIdFlight(idFlight);
  27.         boolean isDeleteSuccess = flightService.delete(flight);
  28.         if (isDeleteSuccess) {
  29.             // 删除成功，重定向到显示航班信息的页面
  30.             response.sendRedirect(request.getContextPath() + "/FlightServlet");
  31.         } else {
  32.             // 删除失败，返回错误页面或其他处理
  33.             String scr = "<script>alert('航班信息删除失败，请重试！');window.location.href='main.jsp'</script>";
  34.             response.getWriter().write(scr);
  35.         }
  36.     }
  37. }

 EditFlightServlet

  1. package com.ambow.servlet;
  2.  
  3. import com.ambow.bean.Flight;
  4. import com.ambow.service.FlightService;
  5.  
  6. import javax.servlet.RequestDispatcher;
  7. import javax.servlet.ServletException;
  8. import javax.servlet.annotation.WebServlet;
  9. import javax.servlet.http.HttpServlet;
  10. import javax.servlet.http.HttpServletRequest;
  11. import javax.servlet.http.HttpServletResponse;
  12. import java.io.IOException;
  13. import java.util.List;
  14. @WebServlet(name = "EditFlightServlet", urlPatterns = "/EditFlightServlet")
  15. public class EditFlightServlet extends HttpServlet {
  16.     @Override
  17.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  18.         //获取用户表单信息
  19.         String flightIdParam = request.getParameter("id");
  20.         if (flightIdParam != null && !flightIdParam.isEmpty()) {
  21.             int Idflight = Integer.parseInt(flightIdParam);
  22.             //查询数据库，获取航班信息
  23.             FlightService flightService = new FlightService();
  24.             Flight flights =  flightService.selectById(Idflight);
  25.             //将航班信息存储到 request 属性中
  26.             request.setAttribute("flights", flights);
  27.             request.getRequestDispatcher("UpdateFlight.jsp").forward(request, response);
  28.  
  29.         }else {
  30.             response.sendRedirect(request.getContextPath() + "/FlightServlet");
  31.         }
  32.     }
  33.     @Override
  34.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  35.  
  36.     }
  37. }

FlightServlet

  1. package com.ambow.servlet;
  2.  
  3. import com.ambow.bean.Flight;
  4. import com.ambow.bean.User;
  5. import com.ambow.service.FlightService;
  6.  
  7. import javax.servlet.ServletException;
  8. import javax.servlet.annotation.WebServlet;
  9. import javax.servlet.http.HttpServlet;
  10. import javax.servlet.http.HttpServletRequest;
  11. import javax.servlet.http.HttpServletResponse;
  12. import java.io.IOException;
  13. import java.util.List;
  14.  
  15. @WebServlet("/FlightServlet")
  16. public class FlightServlet extends HttpServlet {
  17.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  18.             throws IOException, ServletException {
  19.         //创建service对象，调用查询所有的方法
  20.         FlightService fs = new FlightService();
  21.         //调用查询所有的方法
  22.         List<Flight> flights = fs.selectAll();
  23.         //将信息储存到作用域中
  24.         request.setAttribute("flights",flights);
  25.         //转发到FlightInfo.jsp页面
  26.         request.getRequestDispatcher("main.jsp").forward(request, response);
  27.  
  28.     }
  29. }

 SelectByDestinationServlet

  1. package com.ambow.servlet;
  2.  
  3. import com.ambow.bean.Flight;
  4. import com.ambow.service.FlightService;
  5.  
  6. import javax.servlet.ServletException;
  7. import javax.servlet.annotation.WebServlet;
  8. import javax.servlet.http.HttpServlet;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  11. import java.io.IOException;
  12. import java.util.List;
  13.  
  14. @WebServlet(name = "SelectByDestination",urlPatterns = "/SelectByDestination")
  15. public class SelectByDestinationServlet extends HttpServlet {
  16.  
  17.     @Override
  18.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  19.         //设置编码格式
  20.         request.setCharacterEncoding("UTF-8");
  21.         response.setContentType("text/html;charset=utf-8");
  22.         // 获取客户端信息
  23.         String destination = request.getParameter("destination");
  24.  
  25.         // 调用 FlightService 类
  26.         FlightService flightService = new FlightService();
  27.         List<Flight> flights = flightService.selectByDestination(destination);
  28.  
  29.         if (flights != null && !flights.isEmpty()) {
  30.             // 将信息储存到作用域中
  31.             request.setAttribute("flights", flights);
  32.             // 转发到 main.jsp 页面
  33.             request.getRequestDispatcher("main.jsp").forward(request, response);
  34.         } else {
  35.             // 目的地找不到的处理逻辑
  36.             String scr = "<script>alert('该目的地找不到！');window.location.href='SelectByDestination.jsp'</script>";
  37.             response.getWriter().write(scr);
  38.         }
  39.     }
  40. }

 SelectByTaketimeServlet

  1. package com.ambow.servlet;
  2.  
  3. import com.ambow.bean.Flight;
  4. import com.ambow.service.FlightService;
  5.  
  6. import javax.servlet.ServletException;
  7. import javax.servlet.annotation.WebServlet;
  8. import javax.servlet.http.HttpServlet;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  11. import java.io.IOException;
  12. import java.text.ParseException;
  13. import java.text.SimpleDateFormat;
  14. import java.util.Date;
  15. import java.util.List;
  16. @WebServlet(name = "SelectByTaketime",urlPatterns = "/SelectByTaketime")
  17. public class SelectByTaketimeServlet extends HttpServlet {
  18.     @Override
  19.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  20.  
  21.     }
  22.  
  23.     @Override
  24.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  25.         //设置编码格式
  26.         request.setCharacterEncoding("UTF-8");
  27.         response.setContentType("text/html;charset=utf-8");
  28.         // 获取客户端信息
  29.         String taketime = request.getParameter("taketime");
  30.         //实例化Flight对象并设置属性
  31.         Flight flight = new Flight();
  32.         //将字符串类型转换成Date类型
  33.         SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
  34.         Date taketimes =null;
  35.         try{
  36.             taketimes = simpleDateFormat.parse(taketime);
  37.         }catch (ParseException e){
  38.             e.printStackTrace();
  39.         }
  40.         flight.setTakeName(taketimes);
  41.  
  42.         // 调用 FlightService 类
  43.         FlightService flightService = new FlightService();
  44.         List<Flight> flights = flightService.selectByTaketime(flight);
  45.  
  46.         if (flights != null && !flights.isEmpty()) {
  47.             // 将信息储存到作用域中
  48.             request.setAttribute("flights", flights);
  49.             // 转发到 main.jsp 页面
  50.             request.getRequestDispatcher("main.jsp").forward(request, response);
  51.         } else {
  52.             // 目的地找不到的处理逻辑
  53.             String scr = "<script>alert('该起飞时间找不到！');window.location.href='SelectByTaketime.jsp'</script>";
  54.             response.getWriter().write(scr);
  55.         }
  56.     }
  57. }

 UpdateFlightServlet

  1. package com.ambow.servlet;
  2.  
  3. import com.ambow.bean.Flight;
  4. import com.ambow.service.FlightService;
  5. import com.sun.xml.internal.ws.api.ha.HaInfo;
  6.  
  7. import javax.servlet.ServletException;
  8. import javax.servlet.annotation.WebServlet;
  9. import javax.servlet.http.HttpServlet;
  10. import javax.servlet.http.HttpServletRequest;
  11. import javax.servlet.http.HttpServletResponse;
  12. import java.io.IOException;
  13. import java.text.ParseException;
  14. import java.text.SimpleDateFormat;
  15. import java.util.Date;
  16.  
  17. @WebServlet(name = "UpdateFlightServlet",urlPatterns = "/UpdateFlightServlet")
  18. public class UpdateFlightServlet extends HttpServlet {
  19.     @Override
  20.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  21.  
  22.     }
  23.  
  24.     @Override
  25.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  26.         //设置编码格式
  27.         request.setCharacterEncoding("UTF-8");
  28.         response.setContentType("text/html;charset=utf-8");
  29.         //获取客户端信息
  30.         String flightid = request.getParameter("flightId");
  31.         String destination = request.getParameter("destination");
  32.         String taketime = request.getParameter("takeoffTime");
  33.         //调用Flight类
  34.         Flight flight = new Flight();
  35.         flight.setFlightId(Integer.parseInt(flightid));
  36.         flight.setDestination(destination);
  37.         //将字符串类型转换成Date类型
  38.         SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
  39.         Date taketimes =null;
  40.         try{
  41.             taketimes = simpleDateFormat.parse(taketime);
  42.         }catch (ParseException e){
  43.             e.printStackTrace();
  44.         }
  45.         flight.setTakeName(taketimes);
  46.         //调用FlightService类中的update方法
  47.         FlightService flightService =new FlightService();
  48.         boolean isUpdateSuccess = flightService.update(flight);
  49.         if (isUpdateSuccess){
  50.             // 重定向到航班信息页面
  51.             response.sendRedirect(request.getContextPath() + "/FlightServlet");
  52.         }else {
  53.             String scr = "<script>alert('航班信息修改失败，请重试！');window.location.href='UpdateFlight.jsp'</script>";
  54.             response.getWriter().write(scr);
  55.         }
  56.  
  57.     }
  58. }

三：前端JSP页面

JSP是原生的HTML页面添入Java代码

下面开始编写JSP代码

AddFlight.jsp

  1. <%--
  2.   Created by IntelliJ IDEA.
  3.   User: 29988
  4.   Date: 2024/1/4
  5.   Time: 14:17
  6.   To change this template use File | Settings | File Templates.
  7. --%>
  8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  9. <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  10. <html>
  11. <head>
  12.     <title>增加航班信息</title>
  13.   <style type="text/css">
  14.     body {
  15.       font-family: Arial, sans-serif;
  16.       background-color: #f4f4f4;
  17.       margin: 0;
  18.       display: flex;
  19.     }
  20.  
  21.     .sidebar {
  22.       background-color: #333;
  23.       color: #fff;
  24.       width: 200px;
  25.       padding: 20px;
  26.       box-sizing: border-box;
  27.     }
  28.     .nav-link {
  29.       text-decoration: none;
  30.       color: #fff;
  31.       font-family: 微软雅黑, serif;
  32.       display: block;
  33.       padding: 10px;
  34.       margin-bottom: 10px;
  35.       border-radius: 4px;
  36.       transition: background-color 0.3s;
  37.     }
  38.  
  39.     .nav-link:hover {
  40.       background-color: #555;
  41.     }
  42.     .logout-link {
  43.       margin-top: 20px;
  44.       position: fixed;
  45.       right: 3%;
  46.       top: 3%;
  47.     }
  48.     .loginout{
  49.       text-decoration: none;
  50.       color: #4caf50;
  51.     }
  52.     .user{
  53.       margin-top: 20px;
  54.       position: fixed;
  55.       right: 8%;
  56.       top: 3%;
  57.     }
  58.     .content {
  59.       margin-top: 100px;
  60.       margin-left: 450px;
  61.       padding: 20px;
  62.     }
  63.     .form-container {
  64.       width: 400px;
  65.       margin: 20px;
  66.       padding: 20px;
  67.       box-sizing: border-box;
  68.       background-color: #fff;
  69.       border-radius: 8px;
  70.       box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
  71.     }
  72.     .form-group {
  73.       margin-bottom: 15px;
  74.     }
  75.     .form-group label {
  76.       display: block;
  77.       font-weight: bold;
  78.       margin-bottom: 5px;
  79.     }
  80.     .form-group input {
  81.       width: 100%;
  82.       padding: 8px;
  83.       box-sizing: border-box;
  84.       border: 1px solid #ccc;
  85.       border-radius: 4px;
  86.     }
  87.     .form-group button {
  88.       background-color: #4caf50;
  89.       color: #fff;
  90.       padding: 10px;
  91.       margin: 10px;
  92.       border: none;
  93.       border-radius: 4px;
  94.       cursor: pointer;
  95.       width: 100%;
  96.     }
  97.     .form-group button:hover {
  98.       background-color: #45a049;
  99.     }
  100.   </style>
  101. </head>
  102. <body>
  103. <div class="sidebar">
  104.   <h2>系统</h2>
  105.  
  106.   <a class="nav-link" onclick="redirectToMainPage()">主页</a>
  107.   <a href="SelectByDestination.jsp" class="nav-link">按目的地查询</a>
  108.   <a href="SelectByTaketime.jsp" class="nav-link">按起飞时间查询</a>
  109.  
  110. </div>
  111. <c:if test="${not empty sessionScope.user}">
  112.   <div class="user">
  113.     <p><span>你好, ${sessionScope.user.userName}</span></p>
  114.   </div>
  115.   <div class="logout-link">
  116.     <p><a href="LogoutServlet" class="loginout">注销</a></p>
  117.   </div>
  118. </c:if>
  119. <c:if test="${empty sessionScope.user}">
  120.   <div>
  121.     <p><a href="login.jsp">登录</a></p>
  122.   </div>
  123.   <div>
  124.     <p><a href="register.jsp">注册</a></p>
  125.   </div>
  126. </c:if>
  127.  
  128. <div class="content">
  129.   <div class="form-container">
  130.     <h2>新增航班信息</h2>
  131.     <form action="AddFlightServlet" method="post">
  132.       <div class="form-group">
  133.         <label for="flightId">航班号:</label>
  134.         <input type="text" id="flightId" name="flightId" required>
  135.       </div>
  136.       <div class="form-group">
  137.         <label for="destination">目的地:</label>
  138.         <input type="text" id="destination" name="destination" required>
  139.       </div>
  140.       <div class="form-group">
  141.         <label for="takeoffTime">起飞时间:</label>
  142.         <input type="date" id="takeoffTime" name="takeoffTime" required>
  143.       </div>
  144.       <div class="form-group">
  145.         <button type="submit">保存</button>
  146.         <button type="button" onclick="redirectToMainPage()">返回主页面</button>
  147.       </div>
  148.     </form>
  149.   </div>
  150. </div>
  151. <script>
  152.   function redirectToMainPage() {
  153.     window.location.href = "${pageContext.request.contextPath}/FlightServlet";
  154.   }
  155. </script>
  156.  
  157. </body>
  158. </html>

login.jsp

  1. <%--
  2.   Created by IntelliJ IDEA.
  3.   User: 29988
  4.   Date: 2024/1/2
  5.   Time: 8:42
  6.   To change this template use File | Settings | File Templates.
  7. --%>
  8.  
  9. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  10. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  11. <html>
  12. <style type="text/css">
  13.   body {
  14.     font-family: Arial, sans-serif;
  15.     background-color: #f4f4f4;
  16.     margin: 0;
  17.     display: flex;
  18.     align-items: center;
  19.     justify-content: center;
  20.     height: 100vh;
  21.   }
  22.  
  23.   .login-container {
  24.     background-color: #fff;
  25.     padding: 20px;
  26.     border-radius: 8px;
  27.     box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
  28.     width: 400px;
  29.     height:450px;
  30.   }
  31.  
  32.   .login-container h2 {
  33.     text-align: center;
  34.   }
  35.  
  36.   .form-group {
  37.     margin-bottom: 15px;
  38.   }
  39.  
  40.   .form-group label {
  41.     display: block;
  42.     font-weight: bold;
  43.     margin-bottom: 5px;
  44.   }
  45.  
  46.   .form-group input {
  47.     width: 100%;
  48.     padding: 8px;
  49.     box-sizing: border-box;
  50.     border: 1px solid #ccc;
  51.     border-radius: 4px;
  52.   }
  53.  
  54.   .form-group button {
  55.     background-color: #4caf50;
  56.     color: #fff;
  57.     padding: 10px;
  58.     border: none;
  59.     border-radius: 4px;
  60.     cursor: pointer;
  61.     width: 100%;
  62.   }
  63.  
  64.   .form-group button:hover {
  65.     background-color: #45a049;
  66.   }
  67.   a{
  68.     text-decoration: none;
  69.     color: #fff;
  70.   }
  71.  .h2s{
  72.    position: fixed;
  73.    top: 7%;
  74.    left: 42%;
  75.    font-family: 幼圆, serif ;
  76.    font-size: 35px;
  77.  }
  78. </style>
  79.   <head>
  80.     <title>登录</title>
  81.     <link rel="shortcut icon" href="#"/>
  82.   </head>
  83.   <body>
  84.  
  85.   <h2 class="h2s">航班信息管理系统</h2>
  86.   <div class="login-container">
  87.     <h2>用户登录</h2>
  88.  
  89.     <c:if test="${not empty loginSuccessful}">
  90.       <c:redirect url="/FlightServlet"/>
  91.     </c:if>
  92.     <form action="LoginServlet" method="post">
  93.       <div class="form-group">
  94.         <label for="username">用户名:</label>
  95.         <input type="text" id="username" name="username" required>
  96.       </div>
  97.  
  98.       <div class="form-group">
  99.         <label for="password">密码:</label>
  100.         <input type="password" id="password" name="password" required>
  101.       </div>
  102.  
  103.       <div class="form-group">
  104.         <button type="submit">登录</button>
  105.       </div>
  106.       <div class="form-group">
  107.         <button><a href="register.jsp">注册</a></button>
  108.       </div>
  109.     </form>
  110.   </div>
  111.   </body>
  112. </html>

 main.jsp

  1. <%--
  2.   Created by IntelliJ IDEA.
  3.   User: 29988
  4.   Date: 2024/1/2
  5.   Time: 19:15
  6.   To change this template use File | Settings | File Templates.
  7. --%>
  8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  9. <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  10. <html>
  11. <head>
  12.     <title>航班信息管理系统</title>
  13.     <link rel="shortcut icon" href="#"/>
  14.     <style type="text/css">
  15.         body {
  16.             font-family: Arial, sans-serif;
  17.             background-color: #f4f4f4;
  18.             margin: 0;
  19.             display: flex;
  20.         }
  21.  
  22.         .sidebar {
  23.             background-color: #333;
  24.             color: #fff;
  25.             width: 200px;
  26.             padding: 20px;
  27.             box-sizing: border-box;
  28.         }
  29.         .nav-link {
  30.             text-decoration: none;
  31.             color: #fff;
  32.             font-family: 微软雅黑, serif;
  33.             display: block;
  34.             padding: 10px;
  35.             margin-bottom: 10px;
  36.             border-radius: 4px;
  37.             transition: background-color 0.3s;
  38.         }
  39.  
  40.         .nav-link:hover {
  41.             background-color: #555;
  42.         }
  43.  
  44.         .main-content {
  45.             flex: 1;
  46.             padding: 20px;
  47.         }
  48.  
  49.         table {
  50.             width: 100%;
  51.             border-collapse: collapse;
  52.             margin-top: 20px;
  53.         }
  54.  
  55.         th, td {
  56.             border: 1px solid #ddd;
  57.             padding: 8px;
  58.             text-align: left;
  59.         }
  60.  
  61.         th {
  62.             background-color: #333;
  63.             color: #fff;
  64.         }
  65.  
  66.         .logout-link {
  67.             margin-top: 20px;
  68.             position: fixed;
  69.             right: 3%;
  70.             top: 3%;
  71.         }
  72.         .loginout{
  73.             text-decoration: none;
  74.             color: #4caf50;
  75.         }
  76.         .user{
  77.             margin-top: 20px;
  78.             position: fixed;
  79.             right: 8%;
  80.             top: 3%;
  81.         }
  82.         .update{
  83.             text-decoration: none;
  84.             color: black;
  85.         }
  86.     </style>
  87. </head>
  88.  
  89. <body>
  90. <div class="sidebar">
  91.     <h2>系统</h2>
  92.  
  93.         <a class="nav-link" onclick="redirectToMainPage()">主页</a>
  94.         <a href="AddFlight.jsp" class="nav-link">新增</a>
  95.         <a href="SelectByDestination.jsp" class="nav-link">按目的地查询</a>
  96.         <a href="SelectByTaketime.jsp" class="nav-link">按起飞时间查询</a>
  97.  
  98. </div>
  99. <c:if test="${not empty sessionScope.user}">
  100.     <div class="user">
  101.         <p><span>你好, ${sessionScope.user.userName}</span></p>
  102.     </div>
  103.     <div class="logout-link">
  104.         <p><a href="LogoutServlet" class="loginout">注销</a></p>
  105.     </div>
  106. </c:if>
  107. <c:if test="${empty sessionScope.user}">
  108.     <div>
  109.         <p><a href="login.jsp">登录</a></p>
  110.     </div>
  111.     <div>
  112.         <p><a href="register.jsp">注册</a></p>
  113.     </div>
  114. </c:if>
  115.  
  116. <div class="main-content">
  117.     <h1>航班信息管理系统</h1>
  118.     <table>
  119.         <thead>
  120.         <tr>
  121.             <th>编号</th>
  122.             <th>航班号</th>
  123.             <th>目的地</th>
  124.             <th>起飞时间</th>
  125.             <th>操作</th>
  126.         </tr>
  127.         </thead>
  128.         <tbody>
  129.         <c:forEach var="flights" items="${flights}">
  130.         <tr>
  131.             <td>${flights.idFlight}</td>
  132.             <td>${flights.flightId}</td>
  133.             <td>${flights.destination}</td>
  134.             <td>${flights.takeName}</td>
  135.             <td>
  136.                 <div style="display: inline-block;">
  137.                         <input type="hidden" name="flightId" value="${flights.idFlight}">
  138.                         <button type="button"><a href="EditFlightServlet?id=${flights.idFlight}" class="update" onclick="return confirm('是否修改？')">修改</a></button>
  139.                 </div>
  140.                 <div style="display: inline-block;">
  141.                     <form action="DeleteFlightServlet" method="post">
  142.                         <input type="hidden" name="flightId" value="${flights.idFlight}">
  143.                         <button type="submit" onclick="return confirm('是否删除？')">删除</button>
  144.                     </form>
  145.             </td>
  146.         </tr>
  147.         </c:forEach>
  148.         </tbody>
  149.     </table>
  150. </div>
  151. <script>
  152.     function redirectToMainPage() {
  153.         window.location.href = "${pageContext.request.contextPath}/FlightServlet";
  154.     }
  155. </script>
  156.  
  157. </body>
  158. </html>

register.jsp

  1. <%--
  2.   Created by IntelliJ IDEA.
  3.   User: 29988
  4.   Date: 2024/1/2
  5.   Time: 20:59
  6.   To change this template use File | Settings | File Templates.
  7. --%>
  8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  9. <html>
  10. <head>
  11.     <title>注册</title>
  12. </head>
  13. <style type="text/css">
  14.     body {
  15.         font-family: Arial, sans-serif;
  16.         background-color: #f4f4f4;
  17.         margin: 0;
  18.         display: flex;
  19.         align-items: center;
  20.         justify-content: center;
  21.         height: 100vh;
  22.     }
  23.  
  24.     .form-container {
  25.         background-color: #fff;
  26.         padding: 20px;
  27.         border-radius: 8px;
  28.         box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
  29.         width: 400px;
  30.     }
  31.  
  32.     .form-container h2 {
  33.         text-align: center;
  34.     }
  35.  
  36.     .form-group {
  37.         margin-bottom: 15px;
  38.     }
  39.  
  40.     .form-group label {
  41.         display: block;
  42.         font-weight: bold;
  43.         margin-bottom: 5px;
  44.     }
  45.  
  46.     .form-group input {
  47.         width: 100%;
  48.         padding: 8px;
  49.         box-sizing: border-box;
  50.         border: 1px solid #ccc;
  51.         border-radius: 4px;
  52.     }
  53.  
  54.     .form-group button {
  55.         background-color: #4caf50;
  56.         color: #fff;
  57.         padding: 10px;
  58.         border: none;
  59.         border-radius: 4px;
  60.         cursor: pointer;
  61.         width: 100%;
  62.     }
  63.  
  64.     .form-group button:hover {
  65.         background-color: #45a049;
  66.     }
  67.  
  68.     .form-group .login-link {
  69.         text-align: center;
  70.         margin-top: 10px;
  71.     }
  72.     .h2s{
  73.         position: fixed;
  74.         top: 7%;
  75.         left: 42%;
  76.         font-family: 幼圆, serif ;
  77.         font-size: 35px;
  78.     }
  79. </style>
  80. <body>
  81. <h2 class="h2s">航班信息管理系统</h2>
  82. <div class="form-container">
  83.     <h2>用户注册</h2>
  84.     <form action="RegisterServlet" method="post">
  85.         <div class="form-group">
  86.             <label for="username">用户名:</label>
  87.             <input type="text" id="username" name="username" required>
  88.         </div>
  89.  
  90.         <div class="form-group">
  91.             <label for="fullname">真实姓名:</label>
  92.             <input type="text" id="fullname" name="fullname" required>
  93.         </div>
  94.  
  95.         <div class="form-group">
  96.             <label for="password">密码:</label>
  97.             <input type="password" id="password" name="password" required>
  98.         </div>
  99.  
  100.         <div class="form-group">
  101.             <button type="submit">注册</button>
  102.         </div>
  103.  
  104.         <div class="form-group login-link">
  105.             <p>已经有账号? <a href="login.jsp">点击登录</a></p>
  106.         </div>
  107.     </form>
  108. </div>
  109.  
  110. </body>
  111. </html>

SelectByDestination.jsp

  1. <%--
  2.   Created by IntelliJ IDEA.
  3.   User: 29988
  4.   Date: 2024/1/5
  5.   Time: 9:51
  6.   To change this template use File | Settings | File Templates.
  7. --%>
  8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  9. <html>
  10. <head>
  11.     <title>通过目的地查询</title>
  12.   <style type="text/css">
  13.     body {
  14.       font-family: Arial, sans-serif;
  15.       background-color: #f4f4f4;
  16.       margin: 0;
  17.       display: flex;
  18.     }
  19.  
  20.     .sidebar {
  21.       background-color: #333;
  22.       color: #fff;
  23.       width: 200px;
  24.       padding: 20px;
  25.       box-sizing: border-box;
  26.     }
  27.     .nav-link {
  28.       text-decoration: none;
  29.       color: #fff;
  30.       font-family: 微软雅黑, serif;
  31.       display: block;
  32.       padding: 10px;
  33.       margin-bottom: 10px;
  34.       border-radius: 4px;
  35.       transition: background-color 0.3s;
  36.     }
  37.  
  38.     .nav-link:hover {
  39.       background-color: #555;
  40.     }
  41.  
  42.     .logout-link {
  43.       margin-top: 20px;
  44.       position: fixed;
  45.       right: 3%;
  46.       top: 3%;
  47.     }
  48.     .loginout{
  49.       text-decoration: none;
  50.       color: #4caf50;
  51.     }
  52.     .user{
  53.       margin-top: 20px;
  54.       position: fixed;
  55.       right: 8%;
  56.       top: 3%;
  57.     }
  58.     .form-container {
  59.       background-color: #fff;
  60.       padding: 20px;
  61.       border-radius: 4px;
  62.       box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
  63.       text-align: center;
  64.       height: 350px;
  65.       width: 400px;
  66.       margin-left: 450px;
  67.       margin-top: 200px;
  68.     }
  69.  
  70.     .form-container h2 {
  71.       margin-bottom: 20px;
  72.     }
  73.  
  74.     .form-container label {
  75.       display: block;
  76.       margin-bottom: 10px;
  77.     }
  78.  
  79.     .form-container input {
  80.       width: 100%;
  81.       padding: 10px;
  82.       margin-bottom: 20px;
  83.       box-sizing: border-box;
  84.       border: 1px solid #ccc;
  85.       border-radius: 4px;
  86.     }
  87.  
  88.     .form-container button {
  89.       background-color: #4caf50;
  90.       color: #fff;
  91.       padding: 10px 20px;
  92.       border: none;
  93.       border-radius: 4px;
  94.       cursor: pointer;
  95.       transition: background-color 0.3s;
  96.     }
  97.  
  98.     .form-container button:hover {
  99.       background-color: #45a049;
  100.     }
  101.   </style>
  102. </head>
  103. <body>
  104.   <div class="sidebar">
  105.     <h2>系统</h2>
  106.  
  107.     <a class="nav-link" onclick="redirectToMainPage()">主页</a>
  108.     <a href="AddFlight.jsp" class="nav-link">新增</a>
  109.     <a href="SelectByTaketime.jsp" class="nav-link">按起飞时间查询</a>
  110.  
  111.   </div>
  112.   <c:if test="${not empty sessionScope.user}">
  113.     <div class="user">
  114.       <p><span>你好, ${sessionScope.user.userName}</span></p>
  115.     </div>
  116.     <div class="logout-link">
  117.       <p><a href="LogoutServlet" class="loginout">注销</a></p>
  118.     </div>
  119.   </c:if>
  120.   <div class="form-container">
  121.     <h2>按目的地查询</h2>
  122.     <form action="SelectByDestination" method="post">
  123.       <label for="destination">目的地：</label>
  124.       <input type="text" id="destination" name="destination" required>
  125.       <br>
  126.       <button type="submit">查询</button>
  127.     </form>
  128.   </div>
  129.   <script>
  130.     function redirectToMainPage() {
  131.       window.location.href = "${pageContext.request.contextPath}/FlightServlet";
  132.     }
  133.   </script>
  134. </body>
  135. </html>

SelectByTaketime.jsp

  1. <%--
  2.   Created by IntelliJ IDEA.
  3.   User: 29988
  4.   Date: 2024/1/5
  5.   Time: 11:11
  6.   To change this template use File | Settings | File Templates.
  7. --%>
  8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  9. <html>
  10. <head>
  11.     <title>通过起飞时间查询</title>
  12.   <style type="text/css">
  13.     body {
  14.       font-family: Arial, sans-serif;
  15.       background-color: #f4f4f4;
  16.       margin: 0;
  17.       display: flex;
  18.     }
  19.  
  20.     .sidebar {
  21.       background-color: #333;
  22.       color: #fff;
  23.       width: 200px;
  24.       padding: 20px;
  25.       box-sizing: border-box;
  26.     }
  27.     .nav-link {
  28.       text-decoration: none;
  29.       color: #fff;
  30.       font-family: 微软雅黑, serif;
  31.       display: block;
  32.       padding: 10px;
  33.       margin-bottom: 10px;
  34.       border-radius: 4px;
  35.       transition: background-color 0.3s;
  36.     }
  37.  
  38.     .nav-link:hover {
  39.       background-color: #555;
  40.     }
  41.  
  42.     .logout-link {
  43.       margin-top: 20px;
  44.       position: fixed;
  45.       right: 3%;
  46.       top: 3%;
  47.     }
  48.     .loginout{
  49.       text-decoration: none;
  50.       color: #4caf50;
  51.     }
  52.     .user{
  53.       margin-top: 20px;
  54.       position: fixed;
  55.       right: 8%;
  56.       top: 3%;
  57.     }
  58.     .form-container {
  59.       background-color: #fff;
  60.       padding: 20px;
  61.       border-radius: 4px;
  62.       box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
  63.       text-align: center;
  64.       height: 350px;
  65.       width: 400px;
  66.       margin-left: 450px;
  67.       margin-top: 200px;
  68.     }
  69.  
  70.     .form-container h2 {
  71.       margin-bottom: 20px;
  72.     }
  73.  
  74.     .form-container label {
  75.       display: block;
  76.       margin-bottom: 10px;
  77.     }
  78.  
  79.     .form-container input {
  80.       width: 100%;
  81.       padding: 10px;
  82.       margin-bottom: 20px;
  83.       box-sizing: border-box;
  84.       border: 1px solid #ccc;
  85.       border-radius: 4px;
  86.     }
  87.  
  88.     .form-container button {
  89.       background-color: #4caf50;
  90.       color: #fff;
  91.       padding: 10px 20px;
  92.       border: none;
  93.       border-radius: 4px;
  94.       cursor: pointer;
  95.       transition: background-color 0.3s;
  96.     }
  97.  
  98.     .form-container button:hover {
  99.       background-color: #45a049;
  100.     }
  101.   </style>
  102. </head>
  103. <body>
  104. <div class="sidebar">
  105.     <h2>系统</h2>
  106.  
  107.     <a class="nav-link" onclick="redirectToMainPage()">主页</a>
  108.     <a href="AddFlight.jsp" class="nav-link">新增</a>
  109.     <a href="SelectByDestination.jsp" class="nav-link">按目的地查询</a>
  110.  
  111.   </div>
  112.   <c:if test="${not empty sessionScope.user}">
  113.     <div class="user">
  114.       <p><span>你好, ${sessionScope.user.userName}</span></p>
  115.     </div>
  116.     <div class="logout-link">
  117.       <p><a href="LogoutServlet" class="loginout">注销</a></p>
  118.     </div>
  119.   </c:if>
  120. <div class="form-container">
  121.   <h2>按起飞时间查询</h2>
  122.   <form action="SelectByTaketime" method="post">
  123.     <label for="taketime">起飞时间：</label>
  124.     <input type="date" id="taketime" name="taketime" required>
  125.     <br>
  126.     <button type="submit">查询</button>
  127.   </form>
  128. </div>
  129. <script>
  130.     function redirectToMainPage() {
  131.         window.location.href = "${pageContext.request.contextPath}/FlightServlet";
  132.     }
  133. </script>
  134. </body>
  135. </html>

UpdateFlight.jsp

  1. <%--
  2.   Created by IntelliJ IDEA.
  3.   User: 29988
  4.   Date: 2024/1/4
  5.   Time: 16:19
  6.   To change this template use File | Settings | File Templates.
  7. --%>
  8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  9. <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  10. <html>
  11. <head>
  12.     <title>修改航班信息</title>
  13.   <style type="text/css">
  14.     body {
  15.       font-family: Arial, sans-serif;
  16.       background-color: #f4f4f4;
  17.       margin: 0;
  18.       display: flex;
  19.     }
  20.  
  21.     .sidebar {
  22.       background-color: #333;
  23.       color: #fff;
  24.       width: 200px;
  25.       padding: 20px;
  26.       box-sizing: border-box;
  27.     }
  28.     .nav-link {
  29.       text-decoration: none;
  30.       color: #fff;
  31.       font-family: 微软雅黑, serif;
  32.       display: block;
  33.       padding: 10px;
  34.       margin-bottom: 10px;
  35.       border-radius: 4px;
  36.       transition: background-color 0.3s;
  37.     }
  38.     .nav-link:hover {
  39.       background-color: #555;
  40.     }
  41.     .logout-link {
  42.       margin-top: 20px;
  43.       position: fixed;
  44.       right: 3%;
  45.       top: 3%;
  46.     }
  47.     .loginout{
  48.       text-decoration: none;
  49.       color: #4caf50;
  50.     }
  51.     .user{
  52.       margin-top: 20px;
  53.       position: fixed;
  54.       right: 8%;
  55.       top: 3%;
  56.     }
  57.     .content {
  58.       margin-left: 450px;
  59.       margin-top: 150px;
  60.       background-color: #fff;
  61.       padding: 20px;
  62.       border-radius: 8px;
  63.       box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
  64.       width: 350px;
  65.       height: 450px;
  66.       text-align: center;
  67.     }
  68.     form {
  69.       margin-top: 20px;
  70.     }
  71.  
  72.     label {
  73.       display: block;
  74.       margin-bottom: 8px;
  75.       margin-left: 0;
  76.     }
  77.  
  78.     input {
  79.       width: 100%;
  80.       padding: 8px;
  81.       margin-bottom: 12px;
  82.       box-sizing: border-box;
  83.       border: 1px solid #ccc;
  84.       border-radius: 4px;
  85.     }
  86.  
  87.     button {
  88.       background-color: #4caf50;
  89.       color: #fff;
  90.       padding: 10px;
  91.       border: none;
  92.       border-radius: 4px;
  93.       cursor: pointer;
  94.     }
  95.  
  96.     button:hover {
  97.       background-color: #45a049;
  98.     }
  99.   </style>
  100. </head>
  101. <body>
  102. <div class="sidebar">
  103.   <h2>系统</h2>
  104.  
  105.   <a class="nav-link" onclick="redirectToMainPage()">主页</a>
  106.   <a href="AddFlight.jsp" class="nav-link">新增</a>
  107.   <a href="SelectByDestination.jsp" class="nav-link">按目的地查询</a>
  108.   <a href="SelectByTaketime.jsp" class="nav-link">按起飞时间查询</a>
  109.  
  110. </div>
  111. <c:if test="${not empty sessionScope.user}">
  112.   <div class="user">
  113.     <p><span>你好, ${sessionScope.user.userName}</span></p>
  114.   </div>
  115.   <div class="logout-link">
  116.     <p><a href="LogoutServlet" class="loginout">注销</a></p>
  117.   </div>
  118. </c:if>
  119. <c:if test="${empty sessionScope.user}">
  120.   <div>
  121.     <p><a href="login.jsp">登录</a></p>
  122.   </div>
  123.   <div>
  124.     <p><a href="register.jsp">注册</a></p>
  125.   </div>
  126. </c:if>
  127. <div class="content">
  128.   <h2 align="left">编辑航班信息</h2>
  129.  
  130.     <form action="UpdateFlightServlet" method="post">
  131.       <input type="hidden" name="idFlight" value="${flights.idFlight}">
  132.       <label for="flightId">航班号：</label>
  133.       <input type="text" id="flightId" name="flightId" value="${flights.flightId}" required>
  134.       <br>
  135.       <label for="destination">目的地：</label>
  136.       <input type="text" id="destination" name="destination" value="${flights.destination}" required>
  137.       <br>
  138.       <label for="takeoffTime">起飞时间：</label>
  139.       <input type="text" id="takeoffTime" name="takeoffTime" value="${flights.takeName}" required>
  140.       <br>
  141.       <button type="submit">保存修改</button>
  142.       <button type="button" onclick="redirectToMainPage()">返回主页面</button>
  143.     </form>
  144.  
  145. </div>
  146. <script>
  147.   function redirectToMainPage() {
  148.     window.location.href = "${pageContext.request.contextPath}/FlightServlet";
  149.   }
  150. </script>
  151. </body>
  152. </html>

四：SQL语句

根据大家的需求，sql语句代码放在下面

本项目一共使用两个表，一个是user表，用来储存用户，一个flight表，用来存储航班信息

首先是user表

  1. CREATE TABLE `user`  (
  2.   `userid` int NOT NULL AUTO_INCREMENT,
  3.   `loginname` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  4.   `password` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  5.   `realname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  6.   PRIMARY KEY (`userid`) USING BTREE
  7. ) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

然后是flight表

  1. CREATE TABLE `flight`  (
  2.   `id` int NOT NULL AUTO_INCREMENT,
  3.   `flightid` int NOT NULL,
  4.   `destination` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  5.   `taketime` date NULL DEFAULT NULL,
  6.   PRIMARY KEY (`id`) USING BTREE
  7. ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

 项目到此基本完成了，如果中间有问题请在评论区评论！

项目中涉及到的jar包我放在百度网盘了，有需要的大家自行提取
https://pan.baidu.com/s/1LHeAnZ6TsExQCYKEMNqOlg
提取码：zoyc

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/盐析白兔/article/detail/480821
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号