idea开发SSM框架航院车辆出入收费管理系统停车收费系统 (javaweb-php-asp.netC#-j2ee-springboot)功能有按小时自动计算费用-统计报表

 

 

目录

 

 

1 概述

 

2 数据库表

 

3 关键代码

 

4 效果演示

 


 

1 概述

 

本系统具有多方面特点:系统功能完备,使用方便简捷,人性化的用户界面,安全保密设置齐全,大大减少了操作人员和用户的工作负担,提高了学校管理人员的工作效率。学院车辆管理系统前台功能主要实现了系统管理、车位管理、车主管理、车辆出入录入管理、报表统计功能。

系统管理:该模块实现的功能有系统属性、管理员维护、修改密码。主要是对系统的维护信息的分析;

车位管理:该模块实现的功能有车型管理、添加车型、车位管理、添加车位。车型管理主要是对汽车型号的添加、修改、删除;

车主管理:该模块是对车主信息的添加、删除和修改,如姓名、性别、年龄、联系电话、住址;

车辆出入录入:该模块主要是车辆的入场、出场登记和车位查询,登记信息如入场时间、车位、车主姓名、联系方式、经手人;

报表统计:该模块主要是每周和每个月的报表统计,如车位号、统计金额、年、周数、月数。

2 数据库表

 

表4 t_churu 出入场管理

字段名称

字段大小

字段类型

说明

id

4

长整型(3)

编号

danjuhao

150

文本(202)

单据号

shijian

8

日期/时间(7)

进入时间

lkshijian

8

日期/时间(7)

离开时间

zongjiage

4

长整型(3)

价格

jingshouren

150

文本(202)

经手人

beizhu

150

文本(202)

备注

del

150

文本(202)

是否删除

chewei_id

4

长整型(3)

车位ID

xingming

536870910

备注/超级链接(203)

客户姓名

dianhua

536870910

备注/超级链接(203)

联系方式

5 t_chezhu 车主管理

字段名称

字段大小

字段类型

说明

id

4

长整型(3)

编号

name

150

文本(202)

名称

sex

150

文本(202)

性别

age

150

文本(202)

年龄

tel

150

文本(202)

电话

address

150

文本(202)

地址

3 关键代码

 

package com.action;

import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

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

import com.dao.DB;
import com.orm.Tchewei;
import com.service.liuService;

import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;




public class chewei_servlet extends HttpServlet
{ 
	public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
	{
		String type=req.getParameter("type");
		
		if(type.endsWith("cheweiAdd1"))
		{
			cheweiAdd1(req, res);
		}
		if(type.endsWith("cheweiAdd"))
		{
			cheweiAdd(req, res);
		}
		if(type.endsWith("cheweiMana"))
		{
			cheweiMana(req, res);
		}
		if(type.endsWith("cheweiChaxun"))
		{
			cheweiChaxun(req, res);
		}
		if(type.endsWith("cheweiDel"))
		{
			cheweiDel(req, res);
		}
		if(type.endsWith("edit"))
		{
			edit(req, res);
		}
//		if(type.endsWith("cheweiSearch"))
//		{
//			cheweiSearch(req, res);
//		}
		
		
		if(type.endsWith("photo"))
		{
			photo(req, res);
		}
		
		
	}
	
	
	
	
		public void photo(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		int id=Integer.parseInt(req.getParameter("id"));
		
		List cheweiList=new ArrayList();
		String sql="select * from t_chewei where id="+id;
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			while(rs.next())
			{
				Tchewei chewei=new Tchewei();
				chewei.setId(rs.getInt("id"));
				chewei.setCatelog_id(rs.getInt("catelog_id"));
				chewei.setName(rs.getString("name"));
				chewei.setBeizhu(rs.getString("beizhu"));
				chewei.setWeizhi(rs.getString("weizhi"));
				chewei.setFuzheren(rs.getString("fuzheren"));
				chewei.setIsuse(rs.getString("isuse"));
				chewei.setPhoto(rs.getString("photo"));
				chewei.setCatelog_name(liuService.getCatelogName(rs.getInt("catelog_id")));
				cheweiList.add(chewei);
		    }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		System.out.println(cheweiList.size());
		req.setAttribute("cheweiList", cheweiList);
		req.setAttribute("id", id);
		req.getRequestDispatcher("admin/chewei/photo.jsp").forward(req, res);
	}

	
	public void edit(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		//System.out.println(req.getParameter("userId")+"**");



		List cheweiList=new ArrayList();
		String sql="select * from t_chewei where id="+Integer.parseInt(req.getParameter("id"));
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			while(rs.next())
			{
				Tchewei chewei=new Tchewei();
				chewei.setId(rs.getInt("id"));
				chewei.setCatelog_id(rs.getInt("catelog_id"));
				chewei.setName(rs.getString("name"));
				chewei.setBeizhu(rs.getString("beizhu"));
				chewei.setWeizhi(rs.getString("weizhi"));
				chewei.setFuzheren(rs.getString("fuzheren"));
				chewei.setIsuse(rs.getString("isuse"));
				chewei.setPhoto(rs.getString("photo"));
				chewei.setCatelog_name(liuService.getCatelogName(rs.getInt("catelog_id")));
				chewei.setCatelog_id(rs.getInt("catelog_id"));
				cheweiList.add(chewei);
		    }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		
		req.setAttribute("cheweiList", cheweiList);
	
		req.getRequestDispatcher("admin/chewei/cheweiEditPre.jsp").forward(req, res);
	}
	
	
	
	
	
public void cheweiAdd(HttpServletRequest req,HttpServletResponse res)
	{
		int catelog_id=Integer.parseInt(req.getParameter("catelog_id"));
		String name=req.getParameter("name");
		String weizhi=req.getParameter("weizhi");
		String fuzheren=req.getParameter("fuzheren");
		String isuse=req.getParameter("isuse");
		String beizhu=req.getParameter("beizhu");
		String photo=req.getParameter("fujian");
		String del="no";
		String sql="insert into t_chewei (`catelog_id`, `name`, `weizhi`, `fuzheren`, `isuse`, `beizhu`, `del`, `photo`)  values(?,?,?,?,?,?,?,?)";
		Object[] params={catelog_id,name,weizhi,fuzheren,isuse,beizhu,del,photo};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "chewei?type=cheweiMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}	
	
	
	
	public void cheweiAdd1(HttpServletRequest req,HttpServletResponse res)
	{
		
		
		int catelog_id=Integer.parseInt(req.getParameter("catelog_id"));
		String name=req.getParameter("name");
		String weizhi=req.getParameter("weizhi");
		String fuzheren=req.getParameter("fuzheren");
		String isuse=req.getParameter("isuse");
		String beizhu=req.getParameter("beizhu");
		String photo=req.getParameter("fujian");
		
	
	
	
		String sql="update t_chewei set catelog_id="+catelog_id+",name='"+name+"',weizhi='"+weizhi+"',fuzheren='"+fuzheren+"',isuse='"+isuse+"',beizhu='"+beizhu+"',photo='"+photo+"' where id="+Integer.parseInt(req.getParameter("id"));;
		Object[] params={};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "chewei?type=cheweiMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}
	public void cheweiDel(HttpServletRequest req,HttpServletResponse res)
	{
		int id=Integer.parseInt(req.getParameter("id"));
		System.out.println("dddd");
		String sql="update t_chewei set del='yes' where id="+id;
		Object[] params={};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "chewei?type=cheweiMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}
	public void cheweiMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
	
		String page1=req.getParameter("page");
		if(page1==null){
			page1="1";
		}
		//分页设置
		int EVERYPAGENUM=10;//每页条数
		int page=Integer.parseInt(page1);   //传递过来的当前页
		int cou = 1;//得到信息总数	
		int pagecount=1;  //总页数
		String sql1="select count(*) as cou from t_chewei where del='no'";
		if(req.getParameter("name")!=null)sql1+=" and name like '%"+req.getParameter("name").trim()+"%'";
		Object[] params1={};
		DB mydb1=new DB();
		try
		{
			mydb1.doPstm(sql1, params1);
			ResultSet rs=mydb1.getRs();
			while(rs.next())
			{
			cou= rs.getInt("cou");
			}
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb1.closed();
		
		
		
		if (cou % EVERYPAGENUM == 0) {
			pagecount= cou / EVERYPAGENUM;
        } else {
        	pagecount=cou / EVERYPAGENUM + 1;
        }	
		
		
		
		
		
		
		req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);	
		req.setAttribute("page", page);
		req.setAttribute("cou", cou);
		req.setAttribute("pagecount", pagecount);
		
		
		
		
		
		
		List cheweiList=new ArrayList();
		String sql="select * from t_chewei where del='no' ";
		if(req.getParameter("name")!=null)sql+=" and name like '%"+req.getParameter("name").trim()+"%'";
		sql+=" order by id desc";
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			 for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
	                rs.next();
	            }
	            for (int t = 0; t < EVERYPAGENUM; t++) {
	                if (rs.next()) {
				Tchewei chewei=new Tchewei();
				chewei.setId(rs.getInt("id"));
				chewei.setCatelog_id(rs.getInt("catelog_id"));
				chewei.setName(rs.getString("name"));
				chewei.setBeizhu(rs.getString("beizhu"));
				chewei.setWeizhi(rs.getString("weizhi"));
				chewei.setFuzheren(rs.getString("fuzheren"));
				chewei.setIsuse(rs.getString("isuse"));
				chewei.setPhoto(rs.getString("photo"));
				chewei.setCatelog_name(liuService.getCatelogName(rs.getInt("catelog_id")));
				cheweiList.add(chewei);
	                } else {
	                    break; //减少空循环的时间
	                }
	            }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		
		req.setAttribute("cheweiList", cheweiList);
		req.getRequestDispatcher("admin/chewei/cheweiMana.jsp").forward(req, res);
	}
	
		public void cheweiChaxun(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
	
		String page1=req.getParameter("page");
		if(page1==null){
			page1="1";
		}
		//分页设置
		int EVERYPAGENUM=10;//每页条数
		int page=Integer.parseInt(page1);   //传递过来的当前页
		int cou = 1;//得到信息总数	
		int pagecount=1;  //总页数
		String sql1="select count(*) as cou from t_chewei where del='no'";
		if(req.getParameter("name")!=null&&req.getParameter("name")!="")sql1+=" and name like '%"+req.getParameter("name").trim()+"%'";
		if(req.getParameter("isuse")!=null)sql1+=" and isuse like '"+req.getParameter("isuse").trim()+"'";
		Object[] params1={};
		DB mydb1=new DB();
		try
		{
			mydb1.doPstm(sql1, params1);
			ResultSet rs=mydb1.getRs();
			while(rs.next())
			{
			cou= rs.getInt("cou");
			}
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb1.closed();
		
		
		
		if (cou % EVERYPAGENUM == 0) {
			pagecount= cou / EVERYPAGENUM;
        } else {
        	pagecount=cou / EVERYPAGENUM + 1;
        }	
		
		
		
		
		
		
		req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);	
		req.setAttribute("page", page);
		req.setAttribute("cou", cou);
		req.setAttribute("pagecount", pagecount);
		
		
		
		
		
		
		List cheweiList=new ArrayList();
		String sql="select * from t_chewei where del='no' ";
		if(req.getParameter("name")!=null&&req.getParameter("name")!="")sql+=" and name like '%"+req.getParameter("name").trim()+"%'";
			if(req.getParameter("isuse")!=null)sql+=" and isuse like '"+req.getParameter("isuse").trim()+"'";
	sql+=" order by id desc";
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			 for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
	                rs.next();
	            }
	            for (int t = 0; t < EVERYPAGENUM; t++) {
	                if (rs.next()) {
				Tchewei chewei=new Tchewei();
				chewei.setId(rs.getInt("id"));
				chewei.setCatelog_id(rs.getInt("catelog_id"));
				chewei.setName(rs.getString("name"));
				chewei.setBeizhu(rs.getString("beizhu"));
				chewei.setWeizhi(rs.getString("weizhi"));
				chewei.setFuzheren(rs.getString("fuzheren"));
				chewei.setIsuse(rs.getString("isuse"));
				chewei.setPhoto(rs.getString("photo"));
				chewei.setCatelog_name(liuService.getCatelogName(rs.getInt("catelog_id")));
				cheweiList.add(chewei);
	                } else {
	                    break; //减少空循环的时间
	                }
	            }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		
		req.setAttribute("cheweiList", cheweiList);
		req.getRequestDispatcher("admin/chewei/cheweiChaxun.jsp").forward(req, res);
	}
	
/*	public void cheweiSearch(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		List cheweiList=new ArrayList();
		String sql="select * from t_chewei where del='no' and name like '%"+req.getParameter("name").trim()+"%'";
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			while(rs.next())
			{
Tchewei chewei=new Tchewei();
				chewei.setId(rs.getInt("id"));
				chewei.setCatelog_id(rs.getInt("catelog_id"));
				chewei.setName(rs.getString("name"));
				chewei.setBeizhu(rs.getString("beizhu"));
				chewei.setWeizhi(rs.getString("weizhi"));
				chewei.setFuzheren(rs.getString("fuzheren"));
				chewei.setIsuse(rs.getString("isuse"));
				chewei.setPhoto(rs.getString("photo"));
				chewei.setCatelog_name(liuService.getCatelogName(rs.getInt("catelog_id")));
				cheweiList.add(chewei);		    }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		
		req.setAttribute("cheweiList", cheweiList);
		req.getRequestDispatcher("admin/chewei/cheweiMana.jsp").forward(req, res);
	}
*/	
	
	public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) 
	{
		RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
		try 
		{
		    dispatch.forward(request, response);
		    return;
		} 
		catch (ServletException e) 
		{
                    e.printStackTrace();
		} 
		catch (IOException e) 
		{
			
		    e.printStackTrace();
		}
	}
	public void init(ServletConfig config) throws ServletException 
	{
		super.init(config);
	}
	
	public void destroy() 
	{
		
	}
}

4 效果演示

 

idea或eclipse开发,mysql数据库

  • 0
    点赞
  • 5
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 2
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

计算机程序设计开发

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值