flex做的网站,html做成网页,上网行为管理系统,如何建立设计一个公司网站一、源码特点 idea开发 java servlet 汽车租赁管理系统是一套完善的web设计系统sqlserver数据库 系统采用serlvetdaobean mvc 模式开发#xff0c;对理解JSP java编程开发语言有帮助#xff0c;系统具有完整的源代码和数据库#xff0c;系统主要采用B/S模式开发。 java se…一、源码特点 idea开发 java servlet 汽车租赁管理系统是一套完善的web设计系统sqlserver数据库 系统采用serlvetdaobean mvc 模式开发对理解JSP java编程开发语言有帮助系统具有完整的源代码和数据库系统主要采用B/S模式开发。 java servlet 汽车租赁平台1 二、功能介绍
(1)管理员管理对管理员信息进行添加、删除、修改和查看 (2)用户管理对用户信息进行添加、删除、修改和查看 (3)司机管理对司机信息进行添加、删除、修改和查看 (4)车辆类型管理对车辆类型信息进行添加、删除、修改和查看 (5)车辆管理对车辆信息进行添加、删除、修改和查看 (6)修理厂管理对修理厂信息进行添加、删除、修改和查看 (7)维修管理对维修信息进行添加、删除、修改和查看 (8)预约管理对预约信息进行添加、删除、修改和查看 (9)个人信息修改
数据库设计
BEGIN
CREATE TABLE [dbo].[gly]([glyid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN用户名 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNgly, level2typeNCOLUMN, level2nameNyhm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN密码 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNgly, level2typeNCOLUMN, level2nameNmm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN姓名 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNgly, level2typeNCOLUMN, level2nameNxm
BEGIN
CREATE TABLE [dbo].[yonghu]([yhid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[lxdh] [VARCHAR](40),
[lxdz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN用户名 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyonghu, level2typeNCOLUMN, level2nameNyhm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN密码 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyonghu, level2typeNCOLUMN, level2nameNmm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN姓名 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyonghu, level2typeNCOLUMN, level2nameNxm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN联系电话 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyonghu, level2typeNCOLUMN, level2nameNlxdh
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN联系地址 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyonghu, level2typeNCOLUMN, level2nameNlxdz
BEGIN
CREATE TABLE [dbo].[siji]([sjid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[lxdh] [VARCHAR](40),
[lxdz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN用户名 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNsiji, level2typeNCOLUMN, level2nameNyhm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN密码 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNsiji, level2typeNCOLUMN, level2nameNmm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN姓名 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNsiji, level2typeNCOLUMN, level2nameNxm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN联系电话 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNsiji, level2typeNCOLUMN, level2nameNlxdh
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN联系地址 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNsiji, level2typeNCOLUMN, level2nameNlxdz
BEGIN
CREATE TABLE [dbo].[cllx]([cllxid] [int] IDENTITY(1,1) NOT NULL,
[lx] [VARCHAR](40),
[fy] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN类型 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNcllx, level2typeNCOLUMN, level2nameNlx
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN费用 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNcllx, level2typeNCOLUMN, level2nameNfy
BEGIN
CREATE TABLE [dbo].[cheliang]([clid] [int] IDENTITY(1,1) NOT NULL,
[clh] [VARCHAR](40),
[lx] [VARCHAR](40),
[pp] [VARCHAR](40),
[clzt] [VARCHAR](40),
[js] [VARCHAR](40),
[sj] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN车辆号 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNcheliang, level2typeNCOLUMN, level2nameNclh
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN类型 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNcheliang, level2typeNCOLUMN, level2nameNlx
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN品牌 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNcheliang, level2typeNCOLUMN, level2nameNpp
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN车辆状态 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNcheliang, level2typeNCOLUMN, level2nameNclzt
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN介绍 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNcheliang, level2typeNCOLUMN, level2nameNjs
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN司机 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNcheliang, level2typeNCOLUMN, level2nameNsj
BEGIN
CREATE TABLE [dbo].[xlc]([xlcid] [int] IDENTITY(1,1) NOT NULL,
[xlcmc] [VARCHAR](40),
[wz] [VARCHAR](40),
[lxdh] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN修理厂名称 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxlc, level2typeNCOLUMN, level2nameNxlcmc
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN位置 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxlc, level2typeNCOLUMN, level2nameNwz
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN联系电话 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxlc, level2typeNCOLUMN, level2nameNlxdh
BEGIN
CREATE TABLE [dbo].[weixiu]([wxid] [int] IDENTITY(1,1) NOT NULL,
[qc] [VARCHAR](40),
[xlc] [VARCHAR](40),
[zy] [VARCHAR](40),
[wxms] [VARCHAR](40),
[wxsj] [VARCHAR](40),
[yh] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN汽车 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNweixiu, level2typeNCOLUMN, level2nameNqc
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN修理厂 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNweixiu, level2typeNCOLUMN, level2nameNxlc
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN摘要 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNweixiu, level2typeNCOLUMN, level2nameNzy
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN维修描述 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNweixiu, level2typeNCOLUMN, level2nameNwxms
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN维修时间 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNweixiu, level2typeNCOLUMN, level2nameNwxsj
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN用户 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNweixiu, level2typeNCOLUMN, level2nameNyh
BEGIN
CREATE TABLE [dbo].[yuyue]([yyid] [int] IDENTITY(1,1) NOT NULL,
[dh] [VARCHAR](40),
[lx] [VARCHAR](40),
[dj] [VARCHAR](40),
[zj] [VARCHAR](40),
[qsd] [VARCHAR](40),
[mdd] [VARCHAR](40),
[yysj] [VARCHAR](40),
[yh] [VARCHAR](40),
[bz] [VARCHAR](40),
[kssj] [VARCHAR](40),
[jssj] [VARCHAR](40),
[zsz] [VARCHAR](40),
[sj] [VARCHAR](40),
[cl] [VARCHAR](40),
[zt] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN单号 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNdh
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN类型 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNlx
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN单价 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNdj
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN总价 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNzj
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN起始地 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNqsd
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN目的地 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNmdd
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN预约时间 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNyysj
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN用户 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNyh
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN备注 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNbz
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN开始时间 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNkssj
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN结束时间 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNjssj
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN总时长 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNzsz
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN司机 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNsj
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN车辆 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNcl
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN状态 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyuyue, level2typeNCOLUMN, level2nameNzt
代码设计
private void insertM(HttpServletRequest request, HttpServletResponse response){//车辆添加cheliangDao daonew cheliangDao();cheliang cheliangnew cheliang();cheliang.setClid((String)request.getParameter(keyid));
String clh(String)request.getParameter(clh);//车辆号
cheliang.setClh(clh);
String lx(String)request.getParameter(lx);//类型
cheliang.setLx(lx);
String pp(String)request.getParameter(pp);//品牌
cheliang.setPp(pp);
String clzt(String)request.getParameter(clzt);//车辆状态
cheliang.setClzt(clzt);
String js(String)request.getParameter(js);//介绍
cheliang.setJs(js);
String sj(String)request.getParameter(sj);//司机
cheliang.setSj(sj);response.setCharacterEncoding(gb2312);//设置字符集 仿制乱码String sql;ResultSet rsnull;int num0;DBO dbnew DBO();try {sqlselect count(1) as num from cheliang where clhclh;rsdb.query(sql);if(rs.next()){numrs.getInt(num);}if(num0){request.setAttribute(flag, 操作失败、车辆号重复);}else{dao.insert(cheliang);request.setAttribute(flag, 操作成功);}request.getRequestDispatcher(cheliang/cheliangadd.jsp).forward(request, response);} catch (Exception e) {e.printStackTrace();}}private void ListM(HttpServletRequest request, HttpServletResponse response){//车辆信息列表ResultSet rsnull;cheliangDao dao new cheliangDao();System.out.println(alist);String sql;response.setCharacterEncoding(gb2312);//设置字符集 仿制乱码try{String clh(String)request.getParameter(clh);//车辆号if(clh!null!clh.equals()){sql and clh like %clh%;//符合条件 拼接sql 车辆号}String lx(String)request.getParameter(lx);//类型if(lx!null!lx.equals()){sql and lx like %lx%;//符合条件 拼接sql 类型}String pp(String)request.getParameter(pp);//品牌if(pp!null!pp.equals()){sql and pp like %pp%;//符合条件 拼接sql 品牌}String clzt(String)request.getParameter(clzt);//车辆状态if(clzt!null!clzt.equals()){sql and clzt like %clzt%;//符合条件 拼接sql 车辆状态}String js(String)request.getParameter(js);//介绍if(js!null!js.equals()){sql and js like %js%;//符合条件 拼接sql 介绍}String sj(String)request.getParameter(sj);//司机if(sj!null!sj.equals()){sql and sj like %sj%;//符合条件 拼接sql 司机}rsdao.qlist(sql);PrintWriter out response.getWriter();request.setAttribute(rs, rs); request.getRequestDispatcher(cheliang/chelianglist.jsp).forward(request, response);}catch(Exception e){e.toString();e.printStackTrace();}}private void PListM(HttpServletRequest request, HttpServletResponse response){//测试信息列表ResultSet rsnull;cheliangDao dao new cheliangDao();String str(String)request.getParameter(Page);String sql;response.setCharacterEncoding(gb2312);//设置字符集 仿制乱码try{if(strnull){str0;}String clh(String)request.getParameter(clh);//车辆号if(clh!null!clh.equals()){sql and clh like %clh%;//符合条件 拼接sql 车辆号}String lx(String)request.getParameter(lx);//类型if(lx!null!lx.equals()){sql and lx like %lx%;//符合条件 拼接sql 类型}String pp(String)request.getParameter(pp);//品牌if(pp!null!pp.equals()){sql and pp like %pp%;//符合条件 拼接sql 品牌}String clzt(String)request.getParameter(clzt);//车辆状态if(clzt!null!clzt.equals()){sql and clzt like %clzt%;//符合条件 拼接sql 车辆状态}String js(String)request.getParameter(js);//介绍if(js!null!js.equals()){sql and js like %js%;//符合条件 拼接sql 介绍}String sj(String)request.getParameter(sj);//司机if(sj!null!sj.equals()){sql and sj like %sj%;//符合条件 拼接sql 司机}rsdao.qlist(sql);PrintWriter out response.getWriter();request.setAttribute(rs, rs); request.getRequestDispatcher(cheliang/chelianginfo.jsp?Page1).forward(request, response);}catch(Exception e){e.toString();e.printStackTrace();}}private void modifyIndex(HttpServletRequest request, HttpServletResponse response){//车辆修改首页ResultSet rsnull;response.setCharacterEncoding(gb2312);//设置字符集 仿制乱码cheliangDao dao new cheliangDao();String keyid(String)request.getParameter(keyid);String sql;if(keyid!null!keyid.equals()){sql and clidkeyid;}try{rsdao.qlist(sql);PrintWriter out response.getWriter();request.setAttribute(rs, rs); request.getRequestDispatcher(cheliang/cheliangmodify.jsp).forward(request, response);//response.sendRedirect(cheliang/cheliangmodify.jsp);}catch(Exception e){e.toString();e.printStackTrace();}}private void detailM(HttpServletRequest request, HttpServletResponse response){//车辆详细信息页面ResultSet rsnull;response.setCharacterEncoding(gb2312);//设置字符集 仿制乱码cheliangDao dao new cheliangDao();String keyid(String)request.getParameter(keyid);String sql;if(keyid!null!keyid.equals()){sql and clidkeyid;}try{rsdao.qlist(sql);request.setAttribute(rs, rs); request.getRequestDispatcher(cheliang/cheliangdetail.jsp).forward(request, response);}catch(Exception e){e.toString();e.printStackTrace();}}private void deleteM(HttpServletRequest request, HttpServletResponse response){//车辆删除ResultSet lstnull;cheliangDao dao new cheliangDao();response.setCharacterEncoding(gb2312);String keyid(String)request.getParameter(keyid); try{dao.delete(keyid);request.setAttribute(flag, 删除成功); request.getRequestDispatcher(cheliangServlet?methodlist).forward(request, response);//response.sendRedirect(cheliangServlet?methodlist);}catch(Exception e){e.toString();e.printStackTrace();}} 三、注意事项 1、管理员账号admin密码admin 数据库配置文件DBO.java 2、开发环境为TOMCAT9.0,idea2019.3 jdk1.8开发数据库为sqlserver2008或者以上版本使用java语言开发。 3、数据库文件名是jspcarlend.mdf系统名称carlend 4、地址login.jsp
四系统实现 代码下载
https://download.csdn.net/download/qq_41221322/89087552
需要源码 其他的定制服务 下方联系卡片↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓
