java課程設(shè)計-電話號碼查詢系統(tǒng)

山東建筑大學(xué)Java課程設(shè)計報告設(shè)計題目 電話號碼查詢系統(tǒng)學(xué)生姓名 黃瑜 學(xué)號 專業(yè)班級 信計101 指導(dǎo)教師 王文 1、設(shè)計目的1、通過JAVA課程設(shè)計，使大家能夠?qū)W(xué)到的面向?qū)ο蟮脑O(shè)計思想運用在具體工作和學(xué)習(xí)中，加深對類和對象的理解，要求學(xué)生對生活中許多具體的事物抽象出類。2、通過這次課程設(shè)計掌握JAVA的編程思想，為后續(xù)設(shè)計編程打下基礎(chǔ)。3、培養(yǎng)實際操作能力和實踐能力，為以后的工作打下堅實的基礎(chǔ)。2、總體設(shè)計3、詳細設(shè)計homework\src\com\work為工作空間bean文件夾下的TelBean.java為Bean類operate文件夾下的TelOperate.java為服務(wù)器接收信息端，可以對所獲取的信息進行相應(yīng)的方法調(diào)用。TelSql.java寸數(shù)據(jù)庫中的數(shù)據(jù)進行增刪改查。sql文件夾下Conn.java為對數(shù)據(jù)庫提供驅(qū)動加載等操作。addInfo.jsp為添加信息頁面（截圖中有相應(yīng)的運行圖）index.jsp為首頁頁面信息listInfo.jsp為查詢之后顯示信息的頁面searchInfo.jsp為查詢條件選擇頁面4、調(diào)試與測試調(diào)試中部分功能的測試結(jié)果及截圖：1、電話管理功能列表2、添加電話號碼：添加成功顯示所有電話號碼信息按姓名查詢功能及查詢結(jié)果查詢結(jié)果5、按電話號碼查詢功能及查詢結(jié)果查詢結(jié)果6、按部門查詢5、源程序清單和執(zhí)行結(jié)果ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[search]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[dbo].[search]GOCREATETABLE[dbo].[search]([name][nvarchar](20)COLLATEChinese_PRC_CI_ASNOTNULL,[tel][varchar](11)COLLATEChinese_PRC_CI_ASNULL,[dep][nvarchar](20)COLLATEChinese_PRC_CI_ASNULL)ON[PRIMARY]GOBeanpublicclassTelBean{privateStringname;privateStringtel;privateStringdep;publicStringgetName(){returnname;}publicvoidsetName(Stringname){=name;}publicStringgetTel(){returntel;}publicvoidsetTel(Stringtel){this.tel=tel;}publicStringgetDep(){returndep;}publicvoidsetDep(Stringdep){this.dep=dep;}}OperateTeloperatepublicclassTelOperateextendsHttpServlet{/**ThedoGetmethodoftheservlet.<br>*Thismethodiscalledwhenaformhasitstagvaluemethodequalstoget.*@paramrequesttherequestsendbytheclienttotheserver@paramresponsetheresponsesendbytheservertotheclient@throwsServletExceptionifanerroroccurred@throwsIOExceptionifanerroroccurred/publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{request.setCharacterEncoding("utf-8");response.setCharacterEncoding("utf-8");//初始化PrintWriterpw=response.getWriter();Stringtype=request.getParameter("type");Stringname=request.getParameter("username");Stringtel=request.getParameter("tel");Stringdep=request.getParameter("dep");TelSqltelSql=newTelSql();//根據(jù)出入 type判斷操作方式if(type.equals("search")){//根據(jù)條件查詢ArrayList<TelBean>searchList=telSql.geTelListByInfo(name,tel,dep);request.getSession().setAttribute("listResult",searchList);request.getRequestDispatcher("listInfo.jsp").forward(request,response);}elseif(type.equals("add")){//添加if(telSql.addTelInfo(name,tel,dep))pw.print("true");elsepw.print("false");}elseif(type.equals("list")){//列表ArrayList<TelBean>displayList=telSql.geTelList();request.getSession().setAttribute("listResult",displayList);request.getRequestDispatcher("listInfo.jsp").forward(request,response);}elseif(type.equals("del")){//刪除指定信息telSql.delTelInfo(name);ArrayList<TelBean>displayList=telSql.geTelList();request.getSession().setAttribute("listResult",displayList);request.getRequestDispatcher("listInfo.jsp").forward(request,response);}}/**ThedoPostmethodoftheservlet.<br>*Thismethodiscalledwhenaformhasitstagvaluemethodequalstopost.*@paramrequesttherequestsendbytheclienttotheserver@paramresponsetheresponsesendbytheservertotheclient@throwsServletExceptionifanerroroccurred@throwsIOExceptionifanerroroccurred/publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{this.doGet(request,response);}}Telsqlimportjava.sql.*;importjava.util.*;publicclassTelSql{privateConnectionct=null;privatePreparedStatementps=null;privateResultSetrs=null;publicArrayList<TelBean>geTelList(){ArrayList<TelBean>al=newArrayList<TelBean>();TelBeantelBean=null;try{ct=newConn().getConn();ps=ct.prepareStatement("select*fromsearch");rs=ps.executeQuery();while(rs.next()){telBean=newTelBean();telBean.setName(rs.getString("name"));telBean.setTel(rs.getString("tel"));telBean.setDep(rs.getString("dep"));al.add(telBean);}}catch(Exceptione){e.printStackTrace();returnal;//TODO:handleexception}finally{this.close();}returnal;}publicArrayList<TelBean>geTelListByInfo(Stringname,Stringtel,Stringdep){ArrayList<TelBean>al=newArrayList<TelBean>();TelBeantelBean=newTelBean();if(dep.equals("tech")){dep="技術(shù)部"；}elseif(dep.equals("sale")){dep="銷售部"；}elseif(dep.equals("admin")){dep="行政部"；}try{ct=newConn().getConn();Stringsql="select*fromsearchwhere";if((!name.equals(""))&&(!tel.equals(""))&&(!dep.equals("no"))){sql=sql+"name='"+name+"'andtel='"+tel+"'anddep='"+dep+"'";}elseif((!name.equals(""))&&(!tel.equals(""))){sql=sql+"name='"+name+"'andtel='"+tel+"'";}elseif((!name.equals(""))&&(!dep.equals("no"))){sql=sql+"name='"+name+"'anddep='"+dep+"'"}elseif((!tel.equals(""))&&(!dep.equals("no"))){sql=sql+"tel='"+tel+"'anddep='"+dep+"'";}elseif(!name.equals("")){sql=sql+"name='"+name+"'";}elseif(!tel.equals("")){sql=sql+"tel='"+tel+"'";}elseif(!dep.equals("no")){sql=sql+"dep='"+dep+"'";}ps=ct.prepareStatement(sql);rs=ps.executeQuery();while(rs.next()){telBean.setName(rs.getString("name"));telBean.setTel(rs.getString("tel"));telBean.setDep(rs.getString("dep"));al.add(telBean);}}catch(Exceptione){e.printStackTrace();returnal;//TODO:handleexception}finally{this.close();}returnal;}publicbooleanaddTelInfo(Stringname,Stringtel,Stringdep){booleanflag=false;try{ct=newConn().getConn();ps=ct.prepareStatement("insertintosearchvalues(,,)");ps.setString(1,name);ps.setString(2,tel);if(dep.equals("tech")){ps.setString(3,"技術(shù)部 ");}elseif(dep.equals("sale")){ps.setString(3,"銷售部 ");}else{ps.setString(3,"行政部 ");}inttemp=ps.executeUpdate();if(temp!=0)flag=true;}catch(Exceptione){e.printStackTrace();returnflag;//TODO:handleexception}finally{this.close();}returnflag;}publicbooleandelTelInfo(Stringname){booleanflag=false;try{ct=newConn().getConn();ps=ct.prepareStatement("deletefromsearchwherename=");ps.setString(1,name);inttemp=ps.executeUpdate();if(temp!=0)flag=true;}catch(Exceptione){e.printStackTrace();returnflag;//TODO:handleexception}finally{this.close();}returnflag;}publicvoidclose(){try{if(rs!=null){rs.close();rs=null;}if(ps!=null){ps.close();ps=null;if(ct!=null){ct.close();ct=null;}}catch(Exceptione){e.printStackTrace();//TODO:handleexception}}}Sqlimportjava.sql.*;;publicclassConn{privateConnectionct=null;publicConnectiongetConn(){try{ct=DriverManager.getConnection("sa","");}catch(Exceptione){//TODO:handleexceptione.printStackTrace();}returnct;}6.設(shè)計心得我們完成了為期兩周的課程設(shè)計，通過這次課程設(shè)計我深深體會到，在已度過的大學(xué)時間里，我們大多數(shù)接觸的是專業(yè)課.我們在課堂上掌握的僅僅是專業(yè)課的