基于javaweb+mysql的jsp+servlet共享租车信息管理系统(java+jsp+servlet+jdbc+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet共享租车信息管理系统(java+jsp+servlet+jdbc+mysql)
基于servlet+jsp+jdbc的后台管理系统,包含5个模块:汽车账户部管理、租车账户部管理、汽车信息管理表、租车记录表、租车租聘表。功能完整,均能实现增删查改。
运行环境:
jdk8+tomcat8.5+mysql5.7+Eclipse
项目技术:
servlet+jsp+jdbc+easyui+jquery
public class CustomerListServlet extends HttpServlet{
DbUtil dbUtil=new DbUtil();
CustomerDao customerDao=new CustomerDao();
@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 {
String stuNo=request.getParameter("stuNo");
String stuName=request.getParameter("stuName");
String sex=request.getParameter("sex");
String bbirthday=request.getParameter("bbirthday");
String ebirthday=request.getParameter("ebirthday");
String companyId=request.getParameter("companyId");
Customer customer=new Customer();
if(stuNo!=null){
customer.setStuNo(stuNo);
customer.setStuName(stuName);
customer.setSex(sex);
if(StringUtil.isNotEmpty(companyId)){
customer.setCompanyId(Integer.parseInt(companyId));
}
public class CustomerSaveServlet extends HttpServlet{
DbUtil dbUtil=new DbUtil();
CustomerDao customerDao=new CustomerDao();
@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");
String stuNo=request.getParameter("stuNo");
String stuName=request.getParameter("stuName");
String sex=request.getParameter("sex");
String birthday=request.getParameter("birthday");
String companyId=request.getParameter("companyId");
String email=request.getParameter("email");
String stuDesc=request.getParameter("stuDesc");
String stuId=request.getParameter("stuId");
Customer customer=null;
try {
customer = new Customer(stuNo, stuName, sex, DateUtil.formatString(birthday, "yyyy-MM-dd"),
Integer.parseInt(companyId), email, stuDesc);
} catch (Exception e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
if(StringUtil.isNotEmpty(stuId)){
customer.setStuId(Integer.parseInt(stuId));
}
Connection con=null;
try{
con=dbUtil.getCon();
int saveNums=0;
JSONObject result=new JSONObject();
if(StringUtil.isNotEmpty(stuId)){
public class ConsumerSaveServlet extends HttpServlet{
DbUtil dbUtil=new DbUtil();
ConsumerDao consumerDao=new ConsumerDao();
@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");
String consumerName=request.getParameter("consumerName");
String password=request.getParameter("password");
String id=request.getParameter("id");
Consumer consumer=new Consumer(consumerName,password);
if(StringUtil.isNotEmpty(id)){
consumer.setId(Integer.parseInt(id));
}
Connection con=null;
try{
con=dbUtil.getCon();
int saveNums=0;
JSONObject result=new JSONObject();
if(StringUtil.isNotEmpty(id)){
saveNums=consumerDao.consumerModify(con, consumer);
}else{
saveNums=consumerDao.consumerAdd(con, consumer);
}
if(saveNums>0){
result.put("success", "true");
}
public class TaxicarListServlet extends HttpServlet{
DbUtil dbUtil=new DbUtil();
TaxicarDao taxicarDao=new TaxicarDao();
@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 {
String stuNo=request.getParameter("stuNo");
String stuName=request.getParameter("stuName");
String sex=request.getParameter("sex");
String bbirthday=request.getParameter("bbirthday");
String ebirthday=request.getParameter("ebirthday");
String consumerId=request.getParameter("consumerId");
Taxicar taxicar=new Taxicar();
if(stuNo!=null){
taxicar.setStuNo(stuNo);
taxicar.setStuName(stuName);
taxicar.setSex(sex);
if(StringUtil.isNotEmpty(consumerId)){
taxicar.setConsumerId(Integer.parseInt(consumerId));
}
}
String page=request.getParameter("page");
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
public class TaxicarListServlet extends HttpServlet{
DbUtil dbUtil=new DbUtil();
TaxicarDao taxicarDao=new TaxicarDao();
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
}
}
public class TaxicarSaveServlet extends HttpServlet{
DbUtil dbUtil=new DbUtil();
TaxicarDao taxicarDao=new TaxicarDao();
@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");
String stuNo=request.getParameter("stuNo");
String stuName=request.getParameter("stuName");
String sex=request.getParameter("sex");
String birthday=request.getParameter("birthday");
String consumerId=request.getParameter("consumerId");
String email=request.getParameter("email");
String stuDesc=request.getParameter("stuDesc");
electriccar.setStuId(Integer.parseInt(stuId));
}
Connection con=null;
try{
con=dbUtil.getCon();
int saveNums=0;
JSONObject result=new JSONObject();
if(StringUtil.isNotEmpty(stuId)){
saveNums=electriccarDao.electriccarModify(con, electriccar);
}else{
saveNums=electriccarDao.electriccarAdd(con, electriccar);
}
if(saveNums>0){
result.put("success", "true");
}else{
result.put("success", "true");
result.put("errorMsg", "保存失败");
}
ResponseUtil.write(response, result);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
if(companyName==null){
companyName="";
}
Company company=new Company();
company.setCompanyName(companyName);
PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(rows));
Connection con=null;
try{
con=dbUtil.getCon();
JSONObject result=new JSONObject();
JSONArray jsonArray=JsonUtil.formatRsToJsonArray(companyDao.companyList(con, pageBean,company));
int total=companyDao.companyCount(con,company);
result.put("rows", jsonArray);
result.put("total", total);
ResponseUtil.write(response, result);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
public class ConsumerComboListServlet extends HttpServlet{
DbUtil dbUtil=new DbUtil();
ConsumerDao consumerDao=new ConsumerDao();
@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 {
Connection con=null;
try{
con=dbUtil.getCon();
JSONArray jsonArray=new JSONArray();
JSONObject jsonObject=new JSONObject();
jsonObject.put("id", "");
jsonObject.put("consumerName", "请选择...");
jsonArray.add(jsonObject);
jsonArray.addAll(JsonUtil.formatRsToJsonArray(consumerDao.consumerList(con, null,null)));
ResponseUtil.write(response, jsonArray);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
public class CompanyListServlet extends HttpServlet{
DbUtil dbUtil=new DbUtil();
CompanyDao companyDao=new CompanyDao();
@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 {
String page=request.getParameter("page");
String rows=request.getParameter("rows");
String companyName=request.getParameter("companyName");
if(companyName==null){
companyName="";
}
Company company=new Company();
company.setCompanyName(companyName);
PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(rows));
Connection con=null;
try{
con=dbUtil.getCon();
JSONObject result=new JSONObject();
JSONArray jsonArray=JsonUtil.formatRsToJsonArray(companyDao.companyList(con, pageBean,company));
int total=companyDao.companyCount(con,company);
result.put("rows", jsonArray);
result.put("total", total);
ResponseUtil.write(response, result);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
public class CustomerSaveServlet extends HttpServlet{
DbUtil dbUtil=new DbUtil();
CustomerDao customerDao=new CustomerDao();
@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");
String stuNo=request.getParameter("stuNo");
String stuName=request.getParameter("stuName");
String sex=request.getParameter("sex");
String birthday=request.getParameter("birthday");
String companyId=request.getParameter("companyId");
String email=request.getParameter("email");
String stuDesc=request.getParameter("stuDesc");
String stuId=request.getParameter("stuId");
Customer customer=null;
try {
customer = new Customer(stuNo, stuName, sex, DateUtil.formatString(birthday, "yyyy-MM-dd"),
Integer.parseInt(companyId), email, stuDesc);
} catch (Exception e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
if(StringUtil.isNotEmpty(stuId)){
customer.setStuId(Integer.parseInt(stuId));
}
Connection con=null;
try{
con=dbUtil.getCon();
int saveNums=0;
JSONObject result=new JSONObject();
if(StringUtil.isNotEmpty(stuId)){
saveNums=customerDao.customerModify(con, customer);
}else{
saveNums=customerDao.customerAdd(con, customer);
}
if(saveNums>0){
result.put("success", "true");
}else{
result.put("success", "true");
result.put("errorMsg", "保存失败");
}
request.setAttribute("error", "用户名或密码错误!");
// 服务器跳转
request.getRequestDispatcher("index.html").forward(request, response);
}else{
// 获取Session
HttpSession session=request.getSession();
session.setAttribute("currentUser", currentUser);
// 客户端跳转
response.sendRedirect("main.jsp");
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
for(int i=0;i<str.length;i++){
boolean f=customerDao.getCustomerByCompanyId(con, str[i]);
if(f){
result.put("errorIndex", i);
result.put("errorMsg", "公司下面有租车用户,不能删除!");
ResponseUtil.write(response, result);
return;
}
}
int delNums=companyDao.companyDelete(con, delIds);
if(delNums>0){
result.put("success", "true");
result.put("delNums", delNums);
}else{
result.put("errorMsg", "删除失败");
}
ResponseUtil.write(response, result);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
String stuDesc=request.getParameter("stuDesc");
String stuId=request.getParameter("stuId");
Customer customer=null;
try {
customer = new Customer(stuNo, stuName, sex, DateUtil.formatString(birthday, "yyyy-MM-dd"),
Integer.parseInt(companyId), email, stuDesc);
} catch (Exception e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
if(StringUtil.isNotEmpty(stuId)){
customer.setStuId(Integer.parseInt(stuId));
}
Connection con=null;
try{
con=dbUtil.getCon();
int saveNums=0;
JSONObject result=new JSONObject();
if(StringUtil.isNotEmpty(stuId)){
saveNums=customerDao.customerModify(con, customer);
}else{
saveNums=customerDao.customerAdd(con, customer);
}
if(saveNums>0){
result.put("success", "true");
}else{
result.put("success", "true");
result.put("errorMsg", "保存失败");
}
ResponseUtil.write(response, result);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String consumerName=request.getParameter("consumerName");
String password=request.getParameter("password");
String id=request.getParameter("id");
Consumer consumer=new Consumer(consumerName,password);
if(StringUtil.isNotEmpty(id)){
consumer.setId(Integer.parseInt(id));
}
Connection con=null;
try{
con=dbUtil.getCon();
int saveNums=0;
JSONObject result=new JSONObject();
if(StringUtil.isNotEmpty(id)){
saveNums=consumerDao.consumerModify(con, consumer);
}else{
saveNums=consumerDao.consumerAdd(con, consumer);
}
if(saveNums>0){
result.put("success", "true");
}else{
result.put("success", "true");
result.put("errorMsg", "保存失败");
}
ResponseUtil.write(response, result);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
String sex=request.getParameter("sex");
String birthday=request.getParameter("birthday");
String consumerId=request.getParameter("consumerId");
String email=request.getParameter("email");
String stuDesc=request.getParameter("stuDesc");
String stuId=request.getParameter("stuId");
Electriccar electriccar=null;
try {
electriccar = new Electriccar(stuNo, stuName, sex, DateUtil.formatString(birthday, "yyyy-MM-dd"),
Integer.parseInt(consumerId), email, stuDesc);
} catch (Exception e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
if(StringUtil.isNotEmpty(stuId)){
electriccar.setStuId(Integer.parseInt(stuId));
}
Connection con=null;
try{
con=dbUtil.getCon();
int saveNums=0;
JSONObject result=new JSONObject();
if(StringUtil.isNotEmpty(stuId)){
saveNums=electriccarDao.electriccarModify(con, electriccar);
}else{
saveNums=electriccarDao.electriccarAdd(con, electriccar);
}
if(saveNums>0){
result.put("success", "true");
}else{
result.put("success", "true");
result.put("errorMsg", "保存失败");
}
ResponseUtil.write(response, result);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
saveNums=consumerDao.consumerModify(con, consumer);
}else{
saveNums=consumerDao.consumerAdd(con, consumer);
}
if(saveNums>0){
result.put("success", "true");
}else{
result.put("success", "true");
result.put("errorMsg", "保存失败");
}
ResponseUtil.write(response, result);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String companyName=request.getParameter("companyName");
String companyDesc=request.getParameter("companyDesc");
String id=request.getParameter("id");
Company company=new Company(companyName,companyDesc);
if(StringUtil.isNotEmpty(id)){
company.setId(Integer.parseInt(id));
}
Connection con=null;
try{
con=dbUtil.getCon();
int saveNums=0;
JSONObject result=new JSONObject();
if(StringUtil.isNotEmpty(id)){
saveNums=companyDao.companyModify(con, company);
}else{
saveNums=companyDao.companyAdd(con, company);
}
if(saveNums>0){
result.put("success", "true");
}else{
result.put("success", "true");
result.put("errorMsg", "保存失败");
}
ResponseUtil.write(response, result);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}