二手车预约管理系统实现教程（Mysql+Javaweb）

本文提到的作品演示视频我已经上传b站，链接：Javaweb+Mysql作品演示视频_哔哩哔哩_bilibili

实现过程：

1. 写需求分析，画ER图
2. 搭建基本结构
3. 构建MVC框架
4. 编写代码

技术要求：

• JDBC
• Mysql
• ajax
• jsp
• Servlet
• HTTP
• Cookie和Session
• JavaScript

实现的功能：

• 客户：
  • 注册登录修改密码功能
  • 多条件或模糊查询车辆
  • 关注喜欢的车辆
  • 填写预约看车时间
• 员工：
  • 登录修改密码功能
  • 查看所有客户预约记录并且负责客户的预约功能
• 管理员：
  • 登录修改密码功能
  • 对所有车辆进行修改删除增加查找操作
  • 对所有员工进行增删查操作
  • 查看所有员工负责的客户预约记录

全部代码：阿里云盘分享

部分代码：

客户注册功能：

//servlet代码    
private void doregister(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
        //获得到前端传来的值
        String surname = request.getParameter("surname");
        String sex = request.getParameter("sex");
        String phonenum = request.getParameter("phonenum");
        String password = request.getParameter("password");
        boolean register = registerService.register(surname, sex, phonenum, password);
        System.out.println(register+"注册");
        if (register) {
            response.sendRedirect(request.getContextPath()+"/Registererror.jsp");
        }else {
            System.out.println("执行了");
            response.sendRedirect(request.getContextPath()+"/kehu_login.jsp");
        }
    }
//service代码
    public boolean register(String surname,String sex,String phonenum,String password){
        boolean iscunzai = false;
        Connection conn = null;
        PreparedStatement stms = null;
        ResultSet rs = null;
        try {
            conn = DBUtil.getConnection();
            String sql = "select ac_number from member_list where ac_number= ?";
            stms = conn.prepareStatement(sql);
            stms.setString(1,phonenum);
            rs = stms.executeQuery();
            if (rs.next() || surname==null || sex==null || phonenum==null || password==null){
                iscunzai = true;
            }else {
                conn = DBUtil.getConnection();
                String insertsql = "insert into member_list (surname,sex,ac_number,password,is_delete,employee_id) values (?,?,?,?,?,?)";
                stms = conn.prepareStatement(insertsql);
                stms.setString(1,surname);
                stms.setString(2,sex);
                stms.setString(3,phonenum);
                stms.setString(4,password);
                stms.setString(5,"0");
                stms.setString(6,"2");
                stms.execute();
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(conn,stms,rs);
        }
        return iscunzai;
    }

管理员新增车辆功能：

//servlet代码
private void doaddcar(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
        String brand = request.getParameter("brand");
        String model = request.getParameter("model");
        String color = request.getParameter("color");
        String date = request.getParameter("date");
        String kilometers = request.getParameter("kilometers");
        String price = request.getParameter("price");
        String image = request.getParameter("image");
        int type = 0;
        if (!addcarService.selectcar(image)){
            if (addcarService.addcar(brand,model,color,date,kilometers,price,image)){
                type = 1; //表示成功
            }
        } else {
            type = 2; //表示添加的图片已经存在
        }
        String jsonString = JSON.toJSONString(type);
        response.setContentType("text/json;charset=utf-8");
        response.getWriter().write(jsonString);
    }
//service代码
public class AddcarService {
    public boolean selectcar(String image) {
        boolean iscunzai = false;
        Connection conn = null;
        PreparedStatement stms = null;
        ResultSet rs = null;
        try {
            conn = DBUtil.getConnection();
            String sql = "select * from car_list where image = ?";
            stms = conn.prepareStatement(sql);
            stms.setString(1,image);
            rs = stms.executeQuery();
            if (rs.next()) {
                iscunzai = true;
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(conn,stms,rs);
        }
        return iscunzai;
    }
    public boolean addcar(String brand,String model,String color,String date,String kilometers,String price,String image) {
        boolean istianjia = false;
        Connection conn = null;
        PreparedStatement stms = null;
        int count = 0;
        try {
            conn = DBUtil.getConnection();
            String sql = "insert into car_list(brand,model,color,date,kilometers,price,image,is_delete) values(?,?,?,?,?,?,?,?)";
            stms = conn.prepareStatement(sql);
            stms.setString(1,brand);
            stms.setString(2,model);
            stms.setString(3,color);
            stms.setString(4,date);
            stms.setString(5,kilometers);
            stms.setString(6,price);
            stms.setString(7,image);
            stms.setString(8,"0");
            count = stms.executeUpdate();
            if (count == 1) {
                istianjia = true;
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(conn,stms,null);
        }
        return istianjia;
    }
}

其他功能就不再展示……