网站首页 > 后端 > 正文

开发语言 intellij-idea JavaWeb项目：航班信息管理系统（tomcat+jsp）

怎么创建网站免费建立个人网站 后端 2024-04-20 5 0

一：项目业务需求

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

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

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

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

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

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

以航班信息

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

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

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

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

二：项目逻辑实现

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

航班信息管理系统演示

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

首先，先看一下项目架构

后端

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

前端

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

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

下面，我们开始写代码

首先创建实体类

User

package com.ambow.bean;

public class User {

private int userId;

private String userName;

private String password;

private String realName;

public int getUserId() {

return userId;

}

public void setUserId(int userId) {

this.userId = userId;

}

public String getUserName() {

return userName;

}

public void setUserName(String userName) {

this.userName = userName;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

public String getRealName() {

return realName;

}

public void setRealName(String realName) {

this.realName = realName;

}

}

Flight

package com.ambow.bean;

import java.util.Date;

public class Flight {

private int idFlight; //航班编号

private int flightId; //航班号

private String destination; //目的地

private Date takeName; //起飞时间

public int getIdFlight() {

return idFlight;

}

public void setIdFlight(int idFlight) {

this.idFlight = idFlight;

}

public int getFlightId() {

return flightId;

}

public void setFlightId(int flightId) {

this.flightId = flightId;

}

public String getDestination() {

return destination;

}

public void setDestination(String destination) {

this.destination = destination;

}

public Date getTakeName() {

return takeName;

}

public void setTakeName(Date takeName) {

this.takeName = takeName;

}

}

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

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

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class jdbcTest {

public static void conn(){

Connection connection;

String url = "jdbc:mysql://localhost:3306/flightinformationmanagesystem"; //数据库连接的url地址

String user = "root"; //数据库用户名

String password = "123456"; //数据库密码

try {

//加载数据库驱动

Class.forName("com.mysql.cj.jdbc.Driver");

System.out.println("数据库驱动加载成功！");

}catch (ClassNotFoundException e) {

e.printStackTrace();

}

try{

//通过DriverManager获取数据库连接

connection = DriverManager.getConnection(url,user,password);

System.out.println("数据库连接成功！");

}catch (SQLException e) {

e.printStackTrace();

}

}

public static void main(String[] args) {

jdbcTest.conn();

}

}

输出

说明数据库连接成功

下面我们开始写Dao层代码

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

package com.ambow.util;

import java.sql.*;

/*

封装数据库

*/

public class DBConnection {

private static final String username = "root";

private static final String password = "123456";

private static final String url = "jdbc:mysql://localhost:3306/flightinformationmanagesystem";

//加载数据库驱动

public static void main(String[] args) {

try{

Class.forName("com.mysql.jdbc.Driver");

}catch (ClassNotFoundException e){

e.printStackTrace();

}

}

//获取数据库连接方法

public static Connection getConnection(){

Connection connection = null;

try {

connection = DriverManager.getConnection(url,username,password);

}catch (SQLException e){

e.printStackTrace();

}

return connection;

}

//数据库释放三个资源

public static void closeAll(Connection connection, PreparedStatement preparedStatement, ResultSet resultSet){

try{

if (connection != null){

connection.close();

}

if (preparedStatement != null){

preparedStatement.close();

}

if (resultSet != null){

resultSet.close();

}

}catch (SQLException e){

e.printStackTrace();

}

}

//数据库释放两个资源

public static void closeTwo(Connection connection, PreparedStatement preparedStatement){

try{

if (connection != null){

connection.close();

}

if (preparedStatement != null){

preparedStatement.close();

}

}catch (SQLException e){

e.printStackTrace();

}

}

}

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

先写RegisterDao

package com.ambow.dao;

import com.ambow.util.DBConnection;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class RegisterDao {

//注册功能

public boolean register(String username,String password, String realname){

String sql = "insert into flightinformationmanagesystem.user(loginname, password, realname) values (?,?,?)";

Connection connection = null;

PreparedStatement preparedStatement = null;

try{

connection = DBConnection.getConnection();

preparedStatement = connection.prepareStatement(sql);

preparedStatement.setString(1,username);

preparedStatement.setString(2,password);

preparedStatement.setString(3,realname);

int resultSet = preparedStatement.executeUpdate();

return resultSet > 0;

}catch (SQLException e){

e.printStackTrace();

}finally {

DBConnection.closeTwo(connection,preparedStatement);

}

return false;

}

}

然后是UserDao

package com.ambow.dao;

import com.ambow.bean.User;

import com.ambow.util.DBConnection;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class UserDao {

//登录功能

public User selectByNameAndPassword(String loginname, String password){

User user = new User();

String sql = "select * from flightinformationmanagesystem.user where loginname=? and password=?";

Connection connection = null;

PreparedStatement preparedStatement = null;

ResultSet resultSet = null;

try{

//获取数据库连接对象

connection = DBConnection.getConnection();

//预编译

preparedStatement = connection.prepareStatement(sql);

//给参数赋值

preparedStatement.setString(1,loginname);

preparedStatement.setString(2,password);

resultSet = preparedStatement.executeQuery();

if (resultSet.next()){

//创建用户对象

user.setUserId(resultSet.getInt(1)); //1代表数据库中的第一列

user.setUserName(resultSet.getString(2)); //2代表第二列

user.setPassword(resultSet.getString(3));

user.setRealName(resultSet.getString(4));

}

}catch (SQLException e){

e.printStackTrace();

}

finally {

DBConnection.closeAll(connection,preparedStatement,resultSet);

}

return user;

}

}

FlightDao

package com.ambow.dao;

import com.ambow.bean.Flight;

import com.ambow.util.DBConnection;

import java.sql.*;

import java.util.ArrayList;

import java.util.List;

public class FlightDao {

// 查找全部航班信息

public static List selectAll() {

String sql = "SELECT * FROM flightinformationmanagesystem.flight";

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

List flightList = new ArrayList<>();

try {

// 获取数据库连接对象

conn = DBConnection.getConnection();

// 预编译并执行查询语句

ps = conn.prepareStatement(sql);

rs = ps.executeQuery();

// 处理查询结果

while (rs.next()) {

Flight flight = new Flight();

flight.setIdFlight(rs.getInt(1));

flight.setFlightId(rs.getInt(2));

flight.setDestination(rs.getString(3));

flight.setTakeName(rs.getDate(4));

flightList.add(flight);

}

} catch (SQLException e) {

throw new RuntimeException(e);

} finally {

// 关闭资源

DBConnection.closeAll(conn, ps, rs);

}

return flightList;

}

//按目的地查询航班信息

public static List selectAllByDestination(Flight flight){

String sql = "select * from flightinformationmanagesystem.flight where destination=?";

Connection connection = null;

PreparedStatement preparedStatement = null;

ResultSet resultSet = null;

List flightList = new ArrayList<>();

try{

//获取数据库连接对象

connection = DBConnection.getConnection();

preparedStatement = connection.prepareStatement(sql);

preparedStatement.setString(1, flight.getDestination());

resultSet = preparedStatement.executeQuery();

while (resultSet.next()){

flight.setIdFlight(resultSet.getInt("id"));

flight.setFlightId(resultSet.getInt("flightid"));

flight.setDestination(resultSet.getString("destination"));

flight.setTakeName(resultSet.getDate("taketime"));

flightList.add(flight); // 将新对象添加到列表

}

}catch (SQLException e){

e.printStackTrace();

}finally {

DBConnection.closeAll(connection,preparedStatement,resultSet);

}

return flightList;

}

//按起飞时间查询航班信息

public static List selectAllByTaketime(Flight flight){

String sql = "select * from flightinformationmanagesystem.flight where taketime=?";

Connection connection = null;

PreparedStatement preparedStatement = null;

ResultSet resultSet = null;

List flightList = new ArrayList<>();

try{

//获取数据库连接对象

connection = DBConnection.getConnection();

preparedStatement = connection.prepareStatement(sql);

preparedStatement.setDate(1, new java.sql.Date(flight.getTakeName().getTime()));

resultSet = preparedStatement.executeQuery();

while (resultSet.next()){

flight.setIdFlight(resultSet.getInt("id"));

flight.setFlightId(resultSet.getInt("flightid"));

flight.setDestination(resultSet.getString("destination"));

flight.setTakeName(resultSet.getDate("taketime"));

flightList.add(flight); // 将新对象添加到列表

}

}catch (SQLException e){

e.printStackTrace();

}finally {

DBConnection.closeAll(connection,preparedStatement,resultSet);

}

return flightList;

}

//按ID查询航班信息

public Flight selectById(int flightId){

String sql = "select * from flightinformationmanagesystem.flight where id=?";

Connection connection = null;

PreparedStatement preparedStatement = null;

ResultSet resultSet = null;

Flight flight = null;

try{

//获取数据库连接对象

connection = DBConnection.getConnection();

preparedStatement = connection.prepareStatement(sql);

preparedStatement.setInt(1, flightId);

resultSet = preparedStatement.executeQuery();

while (resultSet.next()){

flight = new Flight();

flight.setFlightId(resultSet.getInt("flightid"));

flight.setDestination(resultSet.getString("destination"));

flight.setTakeName(resultSet.getDate("taketime"));

}

}catch (SQLException e){

e.printStackTrace();

}finally {

DBConnection.closeAll(connection,preparedStatement,resultSet);

}

return flight;

}

//增加航班

public static int add(Flight flight){

String sql = "insert into flightinformationmanagesystem.flight(flightid, destination, taketime) values(?,?,?)";

Connection connection = null;

PreparedStatement preparedStatement = null;

int flag = 0;

try{

//获取数据库连接对象

connection = DBConnection.getConnection();

preparedStatement = connection.prepareStatement(sql);

preparedStatement.setInt(1, flight.getFlightId());

preparedStatement.setString(2, flight.getDestination());

preparedStatement.setDate(3,new java.sql.Date(flight.getTakeName().getTime()));

flag = preparedStatement.executeUpdate();

}catch (SQLException e){

e.printStackTrace();

}finally {

DBConnection.closeTwo(connection,preparedStatement);

}

return flag;

}

//修改航班

public static int update(Flight flight){

String sql = "update flightinformationmanagesystem.flight SET destination=?,taketime=? where flightid=?";

Connection connection = null;

PreparedStatement preparedStatement = null;

int flag = 0;

try{

connection = DBConnection.getConnection();

preparedStatement = connection.prepareStatement(sql);

preparedStatement.setString(1, flight.getDestination());

preparedStatement.setDate(2,new java.sql.Date(flight.getTakeName().getTime()));

preparedStatement.setInt(3, flight.getFlightId());

flag = preparedStatement.executeUpdate();

}catch (SQLException e){

e.printStackTrace();

}finally {

DBConnection.closeTwo(connection,preparedStatement);

}

return flag;

}

//删除航班

public static int delete(Flight flight){

String sql = "delete from flightinformationmanagesystem.flight where id=?";

Connection connection = null;

PreparedStatement preparedStatement = null;

int flag = 0;

try{

connection = DBConnection.getConnection();

preparedStatement = connection.prepareStatement(sql);

preparedStatement.setInt(1, flight.getIdFlight());

flag = preparedStatement.executeUpdate();

}catch (SQLException e){

e.printStackTrace();

}finally {

DBConnection.closeTwo(connection,preparedStatement);

}

return flag;

}

}

下面写Service层

首先是RegisterService

package com.ambow.service;

import com.ambow.bean.User;

import com.ambow.dao.RegisterDao;

import com.ambow.util.DBConnection;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class RegisterService {

//判断用户是否存在

public User userIsExist(String username){

String sql = "select loginname from flightinformationmanagesystem.user where loginname =?";

User user = null;

Connection connection = null;

PreparedStatement preparedStatement =null;

ResultSet resultSet = null;

try{

connection = DBConnection.getConnection();

preparedStatement = connection.prepareStatement(sql);

preparedStatement.setString(1,username);

resultSet = preparedStatement.executeQuery();

while (resultSet.next()){

user = new User();

user.setUserName(resultSet.getString("loginname"));

}

}catch (SQLException e){

e.printStackTrace();

}

finally {

DBConnection.closeAll(connection,preparedStatement,resultSet);

}

return user;

}

//调用RegisterDao类

RegisterDao registerDao = new RegisterDao();

public Boolean Register(String username,String password,String realname){

boolean isSuccess = registerDao.register(username,password,realname);

if (isSuccess){

return isSuccess;

}

return null;

}

}

UserService

package com.ambow.service;

import com.ambow.bean.User;

import com.ambow.dao.UserDao;

import com.ambow.util.DBConnection;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class UserService {

public User userIsExist(String username){

String sql = "select loginname from flightinformationmanagesystem.user where loginname =?";

User user = null;

Connection connection = null;

PreparedStatement preparedStatement =null;

ResultSet resultSet = null;

try{

connection = DBConnection.getConnection();

preparedStatement = connection.prepareStatement(sql);

preparedStatement.setString(1,username);

preparedStatement.executeQuery();

while (resultSet.next()){

user = new User();

user.setUserName(resultSet.getString("loginname"));

}

}catch (SQLException e){

e.printStackTrace();

}

finally {

DBConnection.closeAll(connection,preparedStatement,resultSet);

}

return user;

}

//调用UserDao类

UserDao userDao = new UserDao();

//service层的selectByNameAndPassword方法

public User selectByNameAndPassword(String userName, String Password){

//调用UserDao类的selectByNameAndPassword方法

User isSuccess = userDao.selectByNameAndPassword(userName,Password);

//如果isSuccess不为空且密码相等，返回应该isSuccess

if (isSuccess != null && Password.equals(isSuccess.getPassword())){

return isSuccess;

}

return null;

}

}

FlightService

package com.ambow.service;

import com.ambow.bean.Flight;

import com.ambow.dao.FlightDao;

import java.util.Date;

import java.util.List;

public class FlightService {

FlightDao flightDao = new FlightDao();

//查询所有航班信息

public List selectAll(){

List flightList = FlightDao.selectAll();

return flightList;

}

//通过id查询航班信息

public Flight selectById(int flightId){

Flight flight = flightDao.selectById(flightId);

return flight;

}

//通过目的地查询航班信息

public List selectByDestination(String destination){

Flight flight =new Flight();

flight.setDestination(destination);

List flightList = FlightDao.selectAllByDestination(flight);

return flightList;

}

//通过起飞时间查询航班信息

public List selectByTaketime(Flight flight){

List flightList = FlightDao.selectAllByTaketime(flight);

return flightList;

}

//增加航班信息

public boolean add(Flight flight){

int flag = FlightDao.add(flight);

if(flag == 1){

return true;

}else {

return false;

}

}

//修改航班信息

public boolean update(Flight flight){

int flag = FlightDao.update(flight);

if(flag == 1){

return true;

}else {

return false;

}

}

//删除航班信息

public boolean delete(Flight flight){

int flag = FlightDao.delete(flight);

if(flag == 1){

return true;

}else {

return false;

}

}

}

 然后是servlet层

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

RegisterServlet

package com.ambow.servlet;

import com.ambow.bean.User;

import com.ambow.service.RegisterService;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.IOException;

@WebServlet(name = "RegisterServlet",urlPatterns = "/RegisterServlet")

public class RegisterServlet extends HttpServlet {

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

}

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

//设置字符编码，防止乱码

request.setCharacterEncoding("UTF-8");

response.setContentType("text/html;charset=UTF-8");

//获取表单信息

String username = request.getParameter("username");

String realname = request.getParameter("fullname");

String password = request.getParameter("password");

//检查用户名和密码是否为空

if (username == null || username.isEmpty() || password == null || password.isEmpty()) {

String scr ="";

response.getWriter().write(scr);

}else{

//调用Register类进行注册

RegisterService registerService = new RegisterService();

//检查用户名是否已经存在

User userIsExist = registerService.userIsExist(username);

if (userIsExist != null){

String scrs = "";

response.getWriter().write(scrs);

}else {

//注册用户

Boolean register = registerService.Register(username, password, realname);

if (register){

String scri ="";

response.getWriter().write(scri);

}else {

String scrip ="";

response.getWriter().write(scrip);

}

}

}

}

}

UerServlet

package com.ambow.servlet;

import com.ambow.bean.User;

import com.ambow.service.UserService;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.IOException;

@WebServlet(name = "LoginServlet",urlPatterns = "/LoginServlet")

public class UserServlet extends HttpServlet {

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

//设置中文字符，防止乱码

request.setCharacterEncoding("UTF-8");

response.setContentType("text/html;charset=utf-8");

//提交客户端信息

String userName = request.getParameter("username");

String password = request.getParameter("password");

// 检查用户名和密码是否为空

if (userName == null || userName.isEmpty() || password == null || password.isEmpty()){

String scr ="";

response.getWriter().write(scr);

}else {

//调用UserService

UserService userService = new UserService();

User user = userService.selectByNameAndPassword(userName,password);

if(user != null){

// request.setAttribute("user",userName);

// response.sendRedirect("main.jsp");

//设置登录成功的标志

request.setAttribute("loginSuccessful", true);

request.getSession().setAttribute("user", user); // 将用户存储到 session 中，以便在后续请求中使用

response.sendRedirect(request.getContextPath() + "/FlightServlet"); // 执行重定向到 /FlightServlet 路径

}else {

String scr ="";

response.getWriter().write(scr);

}

}

}

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

doGet(request,response);

}

}

LoginOutServlet

package com.ambow.servlet;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import java.io.IOException;

@WebServlet(name = "LogoutServlet", urlPatterns = "/LogoutServlet")

public class LoginOutServlet extends HttpServlet {

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

performLogout(request,response);

}

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

performLogout(request,response);

}

private void performLogout(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

HttpSession session = request.getSession();

//清除 session 中的用户信息

session.removeAttribute("user");

// // 或者直接使整个 session 失效

// session.invalidate();

// 重定向到登录页面或其他页面

response.sendRedirect(request.getContextPath() + "/login.jsp");

}

}

 AddServlet

package com.ambow.servlet;

import com.ambow.bean.Flight;

import com.ambow.service.FlightService;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.IOException;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.Date;

@WebServlet(name = "AddFlightServlet",urlPatterns = "/AddFlightServlet")

public class AddFlightServlet extends HttpServlet {

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

}

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

//设置编码格式

request.setCharacterEncoding("UTF-8");

response.setContentType("text/html;charset=utf-8");

//获取客户端信息

String flightid = request.getParameter("flightId");

String destination = request.getParameter("destination");

String taketime = request.getParameter("takeoffTime");

//实例化Flight对象并设置属性

Flight flight = new Flight();

//将字符串类型转换成整形

flight.setFlightId(Integer.parseInt(flightid));

flight.setDestination(destination);

//将字符串类型转换成Date类型

SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");

Date taketimes =null;

try{

taketimes = simpleDateFormat.parse(taketime);

}catch (ParseException e){

e.printStackTrace();

}

flight.setTakeName(taketimes);

//调用FlightService类

FlightService flightService = new FlightService();

boolean isAddSuccess = flightService.add(flight);

if (isAddSuccess){

// 重定向到航班信息页面

response.sendRedirect(request.getContextPath() + "/FlightServlet");

}else {

String scr = "";

response.getWriter().write(scr);

}

// //获取返回主页面按钮

// String btn = request.getParameter("back");

// if ("back".equals(btn)){

// // 重定向到航班信息页面

// response.sendRedirect(request.getContextPath() + "/FlightServlet");

// }

}

}

 DeleteServlet

package com.ambow.servlet;

import com.ambow.bean.Flight;

import com.ambow.service.FlightService;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.IOException;

@WebServlet(name = "DeleteFlightServlet", urlPatterns = "/DeleteFlightServlet")

public class DeleteFlightServlet extends HttpServlet {

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

}

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

//获取要删除的航班id

int idFlight = Integer.parseInt(request.getParameter("flightId"));

//调用FlightService类中的delete方法进行删除

FlightService flightService = new FlightService();

Flight flight = new Flight();

flight.setIdFlight(idFlight);

boolean isDeleteSuccess = flightService.delete(flight);

if (isDeleteSuccess) {

// 删除成功，重定向到显示航班信息的页面

response.sendRedirect(request.getContextPath() + "/FlightServlet");

} else {

// 删除失败，返回错误页面或其他处理

String scr = "";

response.getWriter().write(scr);

}

}

}

 EditFlightServlet

package com.ambow.servlet;

import com.ambow.bean.Flight;

import com.ambow.service.FlightService;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.IOException;

import java.util.List;

@WebServlet(name = "EditFlightServlet", urlPatterns = "/EditFlightServlet")

public class EditFlightServlet extends HttpServlet {

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

//获取用户表单信息

String flightIdParam = request.getParameter("id");

if (flightIdParam != null && !flightIdParam.isEmpty()) {

int Idflight = Integer.parseInt(flightIdParam);

//查询数据库，获取航班信息

FlightService flightService = new FlightService();

Flight flights = flightService.selectById(Idflight);

//将航班信息存储到 request 属性中

request.setAttribute("flights", flights);

request.getRequestDispatcher("UpdateFlight.jsp").forward(request, response);

}else {

response.sendRedirect(request.getContextPath() + "/FlightServlet");

}

}

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

}

}

FlightServlet

package com.ambow.servlet;

import com.ambow.bean.Flight;

import com.ambow.bean.User;

import com.ambow.service.FlightService;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.IOException;

import java.util.List;

@WebServlet("/FlightServlet")

public class FlightServlet extends HttpServlet {

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws IOException, ServletException {

//创建service对象，调用查询所有的方法

FlightService fs = new FlightService();

//调用查询所有的方法

List flights = fs.selectAll();

//将信息储存到作用域中

request.setAttribute("flights",flights);

//转发到FlightInfo.jsp页面

request.getRequestDispatcher("main.jsp").forward(request, response);

}

}

 SelectByDestinationServlet

package com.ambow.servlet;

import com.ambow.bean.Flight;

import com.ambow.service.FlightService;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.IOException;

import java.util.List;

@WebServlet(name = "SelectByDestination",urlPatterns = "/SelectByDestination")

public class SelectByDestinationServlet extends HttpServlet {

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

//设置编码格式

request.setCharacterEncoding("UTF-8");

response.setContentType("text/html;charset=utf-8");

// 获取客户端信息

String destination = request.getParameter("destination");

// 调用 FlightService 类

FlightService flightService = new FlightService();

List flights = flightService.selectByDestination(destination);

if (flights != null && !flights.isEmpty()) {

// 将信息储存到作用域中

request.setAttribute("flights", flights);

// 转发到 main.jsp 页面

request.getRequestDispatcher("main.jsp").forward(request, response);

} else {

// 目的地找不到的处理逻辑

String scr = "";

response.getWriter().write(scr);

}

}

}

 SelectByTaketimeServlet

package com.ambow.servlet;

import com.ambow.bean.Flight;

import com.ambow.service.FlightService;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.IOException;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.Date;

import java.util.List;

@WebServlet(name = "SelectByTaketime",urlPatterns = "/SelectByTaketime")

public class SelectByTaketimeServlet extends HttpServlet {

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

}

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

//设置编码格式

request.setCharacterEncoding("UTF-8");

response.setContentType("text/html;charset=utf-8");

// 获取客户端信息

String taketime = request.getParameter("taketime");

//实例化Flight对象并设置属性

Flight flight = new Flight();

//将字符串类型转换成Date类型

SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");

Date taketimes =null;

try{

taketimes = simpleDateFormat.parse(taketime);

}catch (ParseException e){

e.printStackTrace();

}

flight.setTakeName(taketimes);

// 调用 FlightService 类

FlightService flightService = new FlightService();

List flights = flightService.selectByTaketime(flight);

if (flights != null && !flights.isEmpty()) {

// 将信息储存到作用域中

request.setAttribute("flights", flights);

// 转发到 main.jsp 页面

request.getRequestDispatcher("main.jsp").forward(request, response);

} else {

// 目的地找不到的处理逻辑

String scr = "";

response.getWriter().write(scr);

}

}

}

 UpdateFlightServlet

package com.ambow.servlet;

import com.ambow.bean.Flight;

import com.ambow.service.FlightService;

import com.sun.xml.internal.ws.api.ha.HaInfo;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.IOException;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.Date;

@WebServlet(name = "UpdateFlightServlet",urlPatterns = "/UpdateFlightServlet")

public class UpdateFlightServlet extends HttpServlet {

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

}

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

//设置编码格式

request.setCharacterEncoding("UTF-8");

response.setContentType("text/html;charset=utf-8");

//获取客户端信息

String flightid = request.getParameter("flightId");

String destination = request.getParameter("destination");

String taketime = request.getParameter("takeoffTime");

//调用Flight类

Flight flight = new Flight();

flight.setFlightId(Integer.parseInt(flightid));

flight.setDestination(destination);

//将字符串类型转换成Date类型

SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");

Date taketimes =null;

try{

taketimes = simpleDateFormat.parse(taketime);

}catch (ParseException e){

e.printStackTrace();

}

flight.setTakeName(taketimes);

//调用FlightService类中的update方法

FlightService flightService =new FlightService();

boolean isUpdateSuccess = flightService.update(flight);

if (isUpdateSuccess){

// 重定向到航班信息页面

response.sendRedirect(request.getContextPath() + "/FlightServlet");

}else {

String scr = "";

response.getWriter().write(scr);

}

}

}

三：前端JSP页面

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

下面开始编写JSP代码

AddFlight.jsp

<%--

Created by IntelliJ IDEA.

User: 29988

Date: 2024/1/4

Time: 14:17

To change this template use File | Settings | File Templates.

--%>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>

<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

增加航班信息

系统

主页

按目的地查询

按起飞时间查询

你好, ${sessionScope.user.userName}

注销

新增航班信息

login.jsp

<%--

Created by IntelliJ IDEA.

User: 29988

Date: 2024/1/2

Time: 8:42

To change this template use File | Settings | File Templates.

--%>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

登录

航班信息管理系统

 main.jsp

<%--

Created by IntelliJ IDEA.

User: 29988

Date: 2024/1/2

Time: 19:15

To change this template use File | Settings | File Templates.

--%>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>

<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

航班信息管理系统

系统

主页

新增

按目的地查询

按起飞时间查询

你好, ${sessionScope.user.userName}

注销

航班信息管理系统

编号航班号目的地起飞时间操作
${flights.idFlight}${flights.flightId}${flights.destination}${flights.takeName}

register.jsp

<%--

Created by IntelliJ IDEA.

User: 29988

Date: 2024/1/2

Time: 20:59

To change this template use File | Settings | File Templates.

--%>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>

注册

航班信息管理系统

用户注册

SelectByDestination.jsp

<%--

Created by IntelliJ IDEA.

User: 29988

Date: 2024/1/5

Time: 9:51

To change this template use File | Settings | File Templates.

--%>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>

通过目的地查询

系统

主页

新增

按起飞时间查询

你好, ${sessionScope.user.userName}

注销

按目的地查询


SelectByTaketime.jsp

<%--

Created by IntelliJ IDEA.

User: 29988

Date: 2024/1/5

Time: 11:11

To change this template use File | Settings | File Templates.

--%>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>

通过起飞时间查询

系统

主页

新增

按目的地查询

你好, ${sessionScope.user.userName}

注销

按起飞时间查询


UpdateFlight.jsp

<%--

Created by IntelliJ IDEA.

User: 29988

Date: 2024/1/4

Time: 16:19

To change this template use File | Settings | File Templates.

--%>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>

<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

修改航班信息

系统

主页

新增

按目的地查询

按起飞时间查询

你好, ${sessionScope.user.userName}

注销

编辑航班信息




四：SQL语句

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

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

首先是user表

CREATE TABLE `user` (

`userid` int NOT NULL AUTO_INCREMENT,

`loginname` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,

`password` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,

`realname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

PRIMARY KEY (`userid`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

然后是flight表

CREATE TABLE `flight` (

`id` int NOT NULL AUTO_INCREMENT,

`flightid` int NOT NULL,

`destination` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`taketime` date NULL DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

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

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

参考阅读

评论可见，请评论后查看内容，谢谢！！！
 您阅读本篇文章共花了： 

Javatomcat开发语言intellij-idea
本文由 用户 于 2024-04-20 发布在 金钥匙，如有疑问，请联系我们。
本文链接：https://www.51969.com/post/18780861.html
0赞

相关文章

发表评论

返回顶部暗黑模式