目录

1 概述

2 数据库表

3 关键代码

4 效果演示

1 概述

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

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

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

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

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

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

2 数据库表

表4 t_churu 出入场管理

表5 t_chezhu 车主管理

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数据库