栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

停车场车位租赁管理系统(java源码+数据库脚本)

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

停车场车位租赁管理系统(java源码+数据库脚本)

首先数据库脚本:

CREATE TABLE rent(
	id INT(32) PRIMARY KEY AUTO_INCREMENT,
	userName VARCHAr(22) NOT NULL,
	carName VARCHAr(32) NOT NULL,
	`status` INT(50) NOT NULL,
	maturityDate DATE NOT NULL
)CHARSET=utf8;

INSERT INTO rent(userName,carName,`status`,maturityDate)
VALUES('周晓阳','京A3098W',1,'2022-06-17'),
('张三','冀DZ3344',0,'2022-08-17'),
('tom','豫JZ7631',0,'2023-06-17');

代码实现:

实体类:

    private int id;
    private  String userName;
    private  String carName;
    private  int status;
    private Date  maturityDate;
//get+set方法

Dao层:

public interface RentDao {
    //查询全部
    List getAll();
    //模糊查询(更具车牌号查询)
    Rent getRentInfoByCarNum(String carName);
    //添加的方法
    int addRent(Rent rent);
    //修改的方法
    int updateRent(int status,int id);
}

Dao--impl:

public class RentDaoImpl extends BaseDao implements RentDao {
    
    @Override
    public List getAll() {
        String sql="select * from rent";
        ResultSet rs = this.executeQuery(sql, null);
        List rentList=new ArrayList<>();
        try {
            while (rs.next()){
                Rent rent=new Rent();
                rent.setId(rs.getInt("id"));
                rent.setUserName(rs.getString("userName"));
                rent.setCarNum(rs.getString("carName"));
                rent.setStatus(rs.getInt("status"));
                rent.setMaturityDate(rs.getDate("maturityDate"));
                rentList.add(rent);
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return rentList;
    }
    

    @Override
    public Rent getRentInfoByCarNum(String carName) {
        String sql="select * from rent where carName=?";
        Object[] objects={carName};
        ResultSet rs = this.executeQuery(sql, objects);
       Rent rent=null;
        try {
            if (rs.next()){
                rent=new Rent();
                rent.setId(rs.getInt("id"));
                rent.setUserName(rs.getString("userName"));
                rent.setCarNum(rs.getString("carName"));
                rent.setStatus(rs.getInt("status"));
                rent.setMaturityDate(rs.getDate("maturityDate"));
            }

        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return rent;
    }
    
    @Override
    public int addRent(Rent rent) {
        String sql="INSERT INTO `rent`(`userName`,`carName`,`status`,`maturityDate`)n" +
                "VALUES (?,?,?,?)";
        Object[] objects={rent.getUserName(),rent.getCarNum(),rent.getStatus(),rent.getMaturityDate()};
        return this.executeUpdate(sql,objects);
    }

    @Override
    public int updateRent(int status,int id) {
        String sql="update rent set status=? where id=?";
        Object[] objects={status,id};
        return this.executeUpdate(sql,objects);
    }
}

Service层:

public interface RentService {
    //查询全部
    List getAll();
    //模糊查询(更具车牌号查询)
    boolean getRentInfoByCarName(String carName);
    //添加的方法
    boolean addRent(Rent rent);
    //修改的方法
    boolean updateRent(int status,int id);
}

ServiceImpl:

public class RentServiceImpl implements RentService {
    RentDao rd=new RentDaoImpl();

    @Override
    public List getAll() {
        return rd.getAll();
    }

    @Override
    public boolean getRentInfoByCarName(String carName) {
        if (rd.getRentInfoByCarNum(carName)!=null){
            return true;
        }
        return false;
    }

    @Override
    public boolean addRent(Rent rent) {
        if (rd.addRent(rent)>0){
            return true;
        }
        return false;
    }

    @Override
    public boolean updateRent(int status, int id) {
        if (rd.updateRent(status, id)>0){
            return true;
        }
        return false;
    }
}

页面:

sho.jsp的展示数据的页面关键代码:

停车场车位租聘管理系统

租聘姓名 车牌号 租聘状态 到期日期 操作
${rent.userName} ${rent.carNum} 已到期 租聘中 ${rent.maturityDate} 已到期 退租

隔行换色:

  $("[class='two'] tr:even").css("background","pink");
  $(" [class='two'] tr:odd").css("background","orange");

修改的额脚本:

 function updateStatus(status,id) {
        if(status==0){
            var answer = confirm("确认修改吗?");
            if(answer){
                $.ajax({
                    type:"get",
                    url:"UpdateServlet?status="+status+"&id="+id,//两个参数  状态和id
                    dataType:"json",
                    success:function (data) {
                        //根据回调函数 true:修改成功,修改页面上的文字
                        if(data.exist==true){
                            document.getElementById("c"+id).innerText='已过期';
                            document.getElementById("s"+id).innerHTML='已过期';
                            alert("修改成功!");
                        }else{
                            alert("修改失败");
                        }
                    }
                })
            }
        }else{
            alert("您的车位已到期!")
        }

点击跳转的脚本:

 function add() {
        window.location="add.jsp";
    }

 添加表单:(展示需求填写信息的表单)关键代码

添加车位租赁信息

租赁人姓名
车牌号

到期日期

光标移开的事件,关键代码:

Servlet:

展示全部的Servlet(ShowServlet):

@WebServlet("/ShowServlet")
public class ShowServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request, response);
    }
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        response.setContentType("text/html;charset=utf-8");
        HttpSession session = request.getSession();
        RentService rs=new RentServiceImpl();
        String path = request.getParameter("path");
        if (path==null){
            List rentList= rs.getAll();
            request.setAttribute("rentList",rentList);
            request.getRequestDispatcher("show.jsp").forward(request,response);
        }else if(path.equals("checkCarName")){
            String carName = request.getParameter("carName");
            boolean f = rs.getRentInfoByCarName(carName);
            response.getWriter().print(f);
        }
     }
 }

添加的Servlet(AddServlet):

@WebServlet("/AddServlet")
public class AddServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request, response);
    }
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        response.setContentType("text/html;charset=UTF-8");
        RentService rs=new RentServiceImpl();
        String userName = request.getParameter("userName");
        String carName = request.getParameter("carName");
        String time = request.getParameter("time");
        int status=0;
        Rent rent=new Rent();
        rent.setStatus(status);
        rent.setUserName(userName);
        rent.setCarNum(carName);
        Date dTime=null;
        SimpleDateFormat sdf=new SimpleDateFormat("yyy-MM-dd");
        try {
            dTime=sdf.parse(time);
        } catch (ParseException e) {
            e.printStackTrace();
        }
        rent.setMaturityDate(dTime);
        boolean flag = rs.addRent(rent);
        if(flag){
            response.getWriter().print("");
        }else{
            response.getWriter().print("");
        }
    }
 }

修改的Servlet(UpdateServlet):

@WebServlet("/UpdateServlet")
public class UpdateServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request, response);
    }
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        RentService rs=new RentServiceImpl();
        String id = request.getParameter("id");
        String status = request.getParameter("status");
        int s=1;
        if((Integer.valueOf(status)==0)){
            s=1;
            //调用修改的方法
            boolean flag = rs.updateRent(s, Integer.valueOf(id));
            HashMap resultMap=new HashMap();
            resultMap.put("exist",flag);
            response.getWriter().print(JSON.toJSONString(resultMap));
        }
    }
}

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/977745.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号