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