JSP+Servlet+Mysql实现火车站售票系统

JSP+Servlet+Mysql实现火车站售票系统

1.JSP+Servlet+Mysql实现火车站售票系统
个人网站：
1.需求分析
网站前台
注册、登录、系统首页、会员中心（我的信息、密码修改、我的资料、我的订单）
网站管理后台
车次管理、订单管理、会员管理、管理员中心、销售统计
2.技术架构
JSP+Servlet+Mysql+tomact+html+css+jquery
开发工具：
IDEA或eclipse
3.部分功能代码展示
package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Timestamp;
import java.util.Date;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.domain.Train;
import com.service.TrainService;
import com.service.impl.TrainServiceImpl;

/**
*

• @ClassName: AddTrainServlet

• @Description: 添加车次的Servlet

• @author: ljy

• @date: 2019年9月11日 下午4:41:06
  */
  public class AddTrainServlet extends HttpServlet {
  private static final long serialVersionUID = 1L;

  /**

  • @see HttpServlet#HttpServlet()
    */
    public AddTrainServlet() {
    super();
    // TODO Auto-generated constructor stub
    }

  /**

  • @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
    */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

  }

  /**

  • @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
    */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    /**

    • 获取界面中输入的数据
      */
      String trainNumber = Parameter(“trainNumber”);
      String startStation = Parameter(“startStation”);
      String endStation = Parameter(“endStation”);
      String startTime = Parameter(“startTime”);
      startTime = startTime.substring(0, 10)+" “+startTime.substring(11)+”:00";
      String endTime = Parameter(“endTime”);
      endTime = endTime.substring(0, 10)+" “+endTime.substring(11)+”:00";
      Integer price = Integer.Parameter(“price”));
      Integer seatNumber = Integer.Parameter(“seatNumber”));
      // 获取当前时间
      Timestamp addTime = new Timestamp(new Date().getTime());

    /**

    • 将数据封装成对象
      */
      Train train = new Train();
      train.setTrainNumber(trainNumber);
      train.setStartStation(startStation);
      train.setEndStation(endStation);
      train.setStartTime(startTime);
      train.setEndTime(endTime);
      train.setPrice(price);
      train.setSeatNumber(seatNumber);
      train.setAddTime(addTime);

    /**

    • 将数据存入数据库,并返回是否成功的结果
      */
      TrainService trainService = new TrainServiceImpl();
      int recordNumber = trainService.add(train);

    /**

    • 根据返回值判断是否添加车次成功，返回1为成功
      */
      PrintWriter out = Writer();
      if(recordNumber == 1) {
      out.write(“”);
      }

    out.close();
    //response.sendRedirect(“pages/admin/right/addTrain.jsp”);

  }

}
4.系统演示
链接：
提取码：dwmm