??項(xiàng)目編號：BS-XX-013

本項(xiàng)目基于JSP/Servlet技術(shù)實(shí)現(xiàn)開發(fā)，開發(fā)工具采用IDEA或ECLIPSE，數(shù)據(jù)庫采用MYSQL數(shù)據(jù)庫。

首次使用，需要進(jìn)入src/com/util/DBOK 修改數(shù)據(jù)庫的相關(guān)信息，系統(tǒng)設(shè)置mysql的用戶名為root,密碼為root,可以根據(jù)需要修改為自己的賬戶信息。

實(shí)驗(yàn)室設(shè)備管理系統(tǒng)主要包含兩個用戶角色，一個是超級管理員，可以進(jìn)行系統(tǒng)的各種管理工作，一個是普通管理員，主要進(jìn)入系統(tǒng)進(jìn)行相應(yīng)的信息查看工作。系統(tǒng)的主要功能包含有：登陸用戶的信息修改，系統(tǒng)用戶管理，使用設(shè)備的用戶信息管理，實(shí)驗(yàn)設(shè)備管理，設(shè)備借出管理，設(shè)備維修管理，共建記錄管理，實(shí)驗(yàn)室設(shè)備統(tǒng)計(jì)（圖形報(bào)表的形式展示），注銷退出，登陸系統(tǒng)。

下面就部分功能進(jìn)行功能展示：

用戶登陸：

登陸后主界面：

系統(tǒng)用戶管理：

用戶信息管理：

設(shè)備信息管理：

設(shè)備借出管理：

設(shè)備維修管理：

共建記錄管理：

實(shí)驗(yàn)室設(shè)備統(tǒng)計(jì)：

以上是展示的系統(tǒng)部分功能，此項(xiàng)目功能完整，運(yùn)行無誤，比較適合畢業(yè)設(shè)計(jì)使用。

核心代碼：

package com.action;/** * 管理員登陸 增加 修改 刪除 ? */import java.io.IOException;import java.text.SimpleDateFormat;import java.util.Calendar;import java.util.List;import java.util.StringTokenizer;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import com.bean.ComBean; import com.util.Constant;import com.util.MD5;public class AdminServlet extends HttpServlet { /** * Constructor of the object. */ public AdminServlet() { super(); } /** * Destruction of the servlet. <br> */ public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } /** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } /** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to post. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(Constant.CONTENTTYPE); request.setCharacterEncoding(Constant.CHARACTERENCODING); String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime()); String date2=new SimpleDateFormat("yyyy-MM-dd").format(Calendar.getInstance().getTime()); try{ String method=request.getParameter("method").trim(); ComBean cBean = new ComBean(); HttpSession session = request.getSession(); ? if(method.equals("one")){//用戶登錄 String username = request.getParameter("username"); String password = request.getParameter("password"); ? String sf = request.getParameter("sf"); ? String sql="select realname from admin where username='"+username+"' and ?password='"+password+"' ?and ?sf='"+sf+"' "; String str=cBean.getString(sql); if(str==null){ request.setAttribute("message", "登錄信息錯誤！"); request.getRequestDispatcher("index.jsp").forward(request, response); } else{ session.setAttribute("user", username); session.setAttribute("sf", sf); request.getRequestDispatcher("admin/index.jsp").forward(request, response); } ? } else if(method.equals("uppwd")){//修改密碼 String username=(String)session.getAttribute("user"); String oldpwd = request.getParameter("oldpwd"); String newpwd = request.getParameter("newpwd"); String str=cBean.getString("select id from admin where username='"+username+"' and ?password='"+oldpwd+"'"); if(str==null){ request.setAttribute("message", "原始密碼信息錯誤！"); request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response); } else{ int flag=cBean.comUp("update admin set password='"+newpwd+"' where username='"+username+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response); } else { request.setAttribute("message", "操作失??！"); request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response); } } } else if(method.equals("adminexit")){//退出登錄 session.removeAttribute("user"); ?session.removeAttribute("sf"); request.getRequestDispatcher("index.jsp").forward(request, response); } else if(method.equals("addm")){//增加系統(tǒng)用戶 String username = request.getParameter("username"); String password = request.getParameter("password"); String realname = request.getParameter("realname"); String sex = request.getParameter("sex"); String age = request.getParameter("age"); String address = request.getParameter("address"); String tel = request.getParameter("tel"); String str=cBean.getString("select id from admin where username='"+username+"'"); if(str==null){ int flag=cBean.comUp("insert into admin(username,password,realname,sex,age,address,tel,addtime ) " + "values('"+username+"','"+password+"','"+realname+"','"+sex+"','"+age+"','"+address+"','"+tel+"','"+date+"' )"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/system/index.jsp").forward(request, response); } else { request.setAttribute("message", "操作失??！"); request.getRequestDispatcher("admin/system/index.jsp").forward(request, response); } } else{ request.setAttribute("message", "該用戶名已存在！"); request.getRequestDispatcher("admin/system/index.jsp").forward(request, response); } } else if(method.equals("upm")){//修改系統(tǒng)用戶 String id = request.getParameter("id"); String password = request.getParameter("password"); String realname = request.getParameter("realname"); String sex = request.getParameter("sex"); String age = request.getParameter("age"); String address = request.getParameter("address"); String tel = request.getParameter("tel"); ? int flag=cBean.comUp("update admin set password='"+password+"',realname='"+realname+"',sex='"+sex+"',age='"+age+"'," + "address='"+address+"',tel='"+tel+"' where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/system/index.jsp").forward(request, response); } else { request.setAttribute("message", "操作失?。?#34;); request.getRequestDispatcher("admin/system/index.jsp").forward(request, response); } } else if(method.equals("delm")){//刪除系統(tǒng)用戶 String id = request.getParameter("id"); ? int flag=cBean.comUp("delete from admin where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/system/index.jsp").forward(request, response); } else { request.setAttribute("message", "操作失敗！"); request.getRequestDispatcher("admin/system/index.jsp").forward(request, response); } } else{//無參數(shù)傳入轉(zhuǎn)到錯誤頁面 request.getRequestDispatcher("error.jsp").forward(request, response); } }catch(Exception e){ e.printStackTrace(); request.getRequestDispatcher("error.jsp").forward(request, response); } } /** * Initialization of the servlet. <br> * * @throws ServletException if an error occure */ public void init() throws ServletException { // Put your code here } }

package com.action;import java.io.IOException;import java.text.SimpleDateFormat;import java.util.Calendar;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import com.bean.ComBean;import com.util.Constant;public class ComServlet extends HttpServlet { /** * Constructor of the object. */ public ComServlet() { super(); } /** * Destruction of the servlet. <br> */ public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } /** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } /** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to post. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(Constant.CONTENTTYPE); request.setCharacterEncoding(Constant.CHARACTERENCODING); HttpSession session = request.getSession(); ComBean cBean = new ComBean(); String date=new SimpleDateFormat("yyyy-MM-dd").format(Calendar.getInstance().getTime()); String date2=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime()); String method = request.getParameter("method"); if(method.equals("addview1")){ ? //String xm="";String xb="";String nl="";String st="";String hj="";String sfz="";String lxr=""; //String dh="";String zz="";String cw="";String hg="";String rz="";String cy=""; String name = request.getParameter("name"); String sex = request.getParameter("sex"); String age = request.getParameter("age"); String build = request.getParameter("build"); int flag = cBean.comUp("insert into view1(name,sex,age,build) values('"+name+"','"+sex+"','"+age+"','"+build+"')"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view1/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失??！"); request.getRequestDispatcher("admin/view1/index.jsp").forward(request, response); } } else if(method.equals("upview1")){ ////修改信息 String id=request.getParameter("id"); String name = request.getParameter("name"); String sex= request.getParameter("sex"); String age = request.getParameter("age"); String build= request.getParameter("build"); int flag = cBean.comUp("update view1 set name='"+name+"',sex='"+sex+"',age='"+age+"',build='"+build+"' where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view1/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失??！"); request.getRequestDispatcher("admin/view1/index.jsp").forward(request, response); } ? } else if(method.equals("delview1")){//刪除信息 String id = request.getParameter("id"); int flag = cBean.comUp("delete from view1 where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view1/index.jsp").forward(request, response); } else{ request.setAttribute("message", "系統(tǒng)維護(hù)中，請稍后再試！"); request.getRequestDispatcher("admin/view1/index.jsp").forward(request, response); } } else if(method.equals("addview2")){ ? ? String lend1 = request.getParameter("lend1"); String lend2= request.getParameter("lend2"); String lend3 = request.getParameter("lend3"); ? String lend4 = request.getParameter("lend4"); String lend5= request.getParameter("lend5"); String lend6 = request.getParameter("lend6"); ? String lend7 = request.getParameter("lend7"); String lend8 = request.getParameter("lend8"); int flag = cBean.comUp("insert into view2(lend1,lend2,lend3,lend4,lend5,lend6,lend7,lend8) values('"+lend1+"','"+lend2+"','"+lend3+"','"+lend4+"','"+lend5+"','"+lend6+"','"+lend7+"','"+lend8+"')"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view2/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失??！"); request.getRequestDispatcher("admin/view2/index.jsp").forward(request, response); } } else if(method.equals("upview2")){ String id=request.getParameter("id"); String lend1= request.getParameter("lend1"); String lend2 = request.getParameter("lend2"); String lend3 = request.getParameter("lend3"); String lend4= request.getParameter("lend4"); String lend5 = request.getParameter("lend5"); String lend6 = request.getParameter("lend6"); String lend7 = request.getParameter("lend7"); String lend8 = request.getParameter("lend8"); int flag = cBean.comUp("update view2 set lend1='"+lend1+"',lend2='"+lend2+"',lend3='"+lend3+"',lend4='"+lend4+"',lend5='"+lend5+"',lend6='"+lend6+"',lend7='"+lend7+"',lend8='"+lend8+"' where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view2/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失?。?#34;); request.getRequestDispatcher("admin/view2/index.jsp").forward(request, response); } ? } else if(method.equals("delview2")){ String id = request.getParameter("id"); int flag = cBean.comUp("delete from view2 where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view2/index.jsp").forward(request, response); } else{ request.setAttribute("message", "系統(tǒng)維護(hù)中，請稍后再試！"); request.getRequestDispatcher("admin/view2/index.jsp").forward(request, response); } } else if(method.equals("addview3")){ ? String information = request.getParameter("information"); String total = request.getParameter("total"); String phone = request.getParameter("phone"); ? int flag = cBean.comUp("insert into view3(information,total,phone) values('"+information+"','"+total+"','"+phone+"' )"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view3/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失??！"); request.getRequestDispatcher("admin/view3/index.jsp").forward(request, response); } } else if(method.equals("upview3")){ String id=request.getParameter("id"); String information = request.getParameter("information"); String total = request.getParameter("total"); String phone = request.getParameter("phone"); ? ? ? int flag = cBean.comUp("update view3 set information='"+information+"',total='"+total+"',phone='"+phone+"' where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view3/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失?。?#34;); request.getRequestDispatcher("admin/view3/index.jsp").forward(request, response); } ? } else if(method.equals("delview3")){ String id = request.getParameter("id"); int flag = cBean.comUp("delete from view3 where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view3/index.jsp").forward(request, response); } else{ request.setAttribute("message", "系統(tǒng)維護(hù)中，請稍后再試！"); request.getRequestDispatcher("admin/view3/index.jsp").forward(request, response); } } else if(method.equals("addview4")){ ? String number = request.getParameter("number"); String name= request.getParameter("name"); String area = request.getParameter("area"); String price = request.getParameter("price"); String status = request.getParameter("status"); ? int flag = cBean.comUp("insert into view4(number,name,area,price,status) values('"+number+"','"+name+"','"+area+"','"+price+"','"+status+"')"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view4/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失?。?#34;); request.getRequestDispatcher("admin/view4/index.jsp").forward(request, response); } } else if(method.equals("upview4")){ String id=request.getParameter("id"); String number = request.getParameter("number"); String name = request.getParameter("name"); String area = request.getParameter("area"); String price= request.getParameter("price"); String status = request.getParameter("status"); int flag = cBean.comUp("update view4 set number='"+number+"',name='"+name+"',area='"+area+"',price='"+price+"',status='"+status+"' where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view4/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失??！"); request.getRequestDispatcher("admin/view4/index.jsp").forward(request, response); } ? } else if(method.equals("delview4")){ String id = request.getParameter("id"); int flag = cBean.comUp("delete from view4 where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view4/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失??！"); request.getRequestDispatcher("admin/view4/index.jsp").forward(request, response); } } else if(method.equals("addview5")){ ? ? ? String Repairnumber = request.getParameter("Repairnumber"); String BuildName = request.getParameter("BuildName"); String Repairdate = request.getParameter("Repairdate"); String Repairtime = request.getParameter("Repairtime"); String Repaircharge = request.getParameter("Repaircharge"); ? int flag = cBean.comUp("insert into view5(Repairnumber,BuildName,Repairdate,Repairtime,Repaircharge) values('"+Repairnumber+"','"+BuildName+"','"+Repairdate+"','"+Repairtime+"','"+Repaircharge+"')"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view5/index.jsp").forward(request, response); } else{ request.setAttribute("message", "系統(tǒng)維護(hù)中，請稍后再試！"); request.getRequestDispatcher("admin/view5/index.jsp").forward(request, response); } } else if(method.equals("upview5")){ String id=request.getParameter("id"); String Repairnumber = request.getParameter("Repairnumber"); String BuildName = request.getParameter("BuildName"); String Repairdate = request.getParameter("Repairdate"); String Repairtime= request.getParameter("Repairtime"); String Repaircharge = request.getParameter("Repaircharge"); int flag = cBean.comUp("update view5 set Repairnumber='"+Repairnumber+"',BuildName='"+BuildName+"',Repairdate='"+Repairdate+"',Repairtime='"+Repairtime+"',Repaircharge='"+Repaircharge+"' where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view5/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失??！"); request.getRequestDispatcher("admin/view5/index.jsp").forward(request, response); } ? } else if(method.equals("delview5")){ String id = request.getParameter("id"); int flag = cBean.comUp("delete from view5 where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/view5/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失??！"); request.getRequestDispatcher("admin/view5/index.jsp").forward(request, response); } } else if(method.equals("addxz")){ ? String lr = request.getParameter("lr"); String fy = request.getParameter("fy"); String kc = request.getParameter("kc"); String zt = request.getParameter("zt"); String xx = request.getParameter("xx"); ? float sji=Float.parseFloat(fy)-Float.parseFloat(kc); int flag = cBean.comUp("insert into xz(lr,fy,kc,zt,xx,sji) values('"+lr+"','"+fy+"','"+kc+"','"+zt+"','"+xx+"','"+sji+"' )"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/xz/index.jsp").forward(request, response); } else{ request.setAttribute("message", "系統(tǒng)維護(hù)中，請稍后再試！"); request.getRequestDispatcher("admin/xz/index.jsp").forward(request, response); } } else if(method.equals("upxz")){ String id=request.getParameter("id"); String lr = request.getParameter("lr"); String fy = request.getParameter("fy"); String kc = request.getParameter("kc"); String zt = request.getParameter("zt"); String xx = request.getParameter("xx"); float sji=Float.parseFloat(fy)-Float.parseFloat(kc); int flag = cBean.comUp("update xz set lr='"+lr+"',fy='"+fy+"',kc='"+kc+"',zt='"+zt+"',xx='"+xx+"',sji='"+sji+"' ?where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/xz/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失?。?#34;); request.getRequestDispatcher("admin/xz/index.jsp").forward(request, response); } ? } else if(method.equals("delxz")){ String id = request.getParameter("id"); int flag = cBean.comUp("delete from xz where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/xz/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失敗！"); request.getRequestDispatcher("admin/xz/index.jsp").forward(request, response); } } else if(method.equals("addhgqj")){ ? String lr = request.getParameter("lr"); String sj = request.getParameter("sj"); String xx = request.getParameter("xx"); ? int flag = cBean.comUp("insert into hgqj(lr,sj,xx) values('"+lr+"','"+sj+"','"+xx+"' )"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失敗！"); request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response); } } else if(method.equals("uphgqj")){ String id=request.getParameter("id"); String lr = request.getParameter("lr"); String sj = request.getParameter("sj"); String xx = request.getParameter("xx"); ? ? ? int flag = cBean.comUp("update hgqj set lr='"+lr+"',sj='"+sj+"',xx='"+xx+"' where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失??！"); request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response); } ? } else if(method.equals("delhgqj")){ String id = request.getParameter("id"); int flag = cBean.comUp("delete from hgqj where id='"+id+"'"); if(flag == Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response); } else{ request.setAttribute("message", "操作失敗！"); request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response); } } } /** * Initialization of the servlet. <br> * * @throws ServletException if an error occure */ public void init() throws ServletException { // Put your code here } }