jsp實(shí)現(xiàn)通訊錄系統(tǒng)

1、個(gè)人通信錄管理系統(tǒng) 計(jì)算機(jī)學(xué)院2008級(jí)2班 張俊發(fā) 學(xué)號(hào)：200821010321 需求分析由于紙制或電子形式的通訊錄，攜帶不方便，或容易忘記等方面的缺點(diǎn)，所以要開發(fā)一個(gè)網(wǎng)絡(luò)通訊錄，方便用戶提供使用：1. 用戶注冊(cè)、登錄功能2. 登錄后，顯示出與當(dāng)前用戶相關(guān)的聯(lián)系人名單 3. 添加新聯(lián)系人 4. 刪除聯(lián)系人5. 根據(jù)聯(lián)系人類型查找聯(lián)系人信息根據(jù)以上要求，開發(fā)一個(gè)網(wǎng)絡(luò)通訊錄。2 數(shù)據(jù)庫實(shí)現(xiàn)過程創(chuàng)建在線通訊錄數(shù)據(jù)庫、表，數(shù)據(jù)庫名為：addressbook。數(shù)據(jù)表為：users、book.實(shí)現(xiàn)代碼如下：user表：book表：set foreign_key_checks=0;- - table s

2、tructure for book- -drop table if exists book;create table book ( bookid int(11) not null auto_increment, name varchar(50) character set utf8 default null, sex char(2) character set utf8 default null, phone varchar(50) character set utf8 default null, homeaddr varchar(50) character set utf8 default

3、null, mobilephone varchar(50) character set utf8 default null, email varchar(50) character set utf8 default null, company varchar(50) character set utf8 default null, comaddr varchar(50) character set utf8 default null, relation varchar(50) character set utf8 default null, userid int(11) not null, p

4、rimary key (bookid) engine=innodb auto_increment=2 default charset=latin1;- - table structure for user- -drop table if exists user;create table user ( userid int(11) not null auto_increment, username varchar(50) character set utf8 default null, password varchar(50) character set utf8 default null, p

5、rimary key (userid) engine=innodb auto_increment=3 default charset=latin1;3在線通訊錄的實(shí)體類設(shè)計(jì)用戶類：userbean.java通訊錄類：bookbean.java實(shí)體類數(shù)據(jù)庫表userbean.javabookbean.javauserbook對(duì)應(yīng)關(guān)系系屬性對(duì)應(yīng)字段4在線通訊錄的功能l 用戶登錄驗(yàn)證l 添加新聯(lián)系人l 刪除聯(lián)系人信息l 查找所有聯(lián)系人l 按照類別查找聯(lián)系人用 戶登錄驗(yàn)證查找所有聯(lián)系人添加聯(lián)系人刪除聯(lián)系人分類查找聯(lián)系人查詢聯(lián)系人5在線通訊錄mvc模式設(shè)計(jì)模型(model)就是業(yè)務(wù)流程/狀態(tài)的處理以及業(yè)

6、務(wù)規(guī)則的制定。視圖（view）視圖就是用戶交互的界面。控制器（controller）可以理解為從用戶接受請(qǐng)求，將模型與視圖匹配在一起，共同完成用戶的請(qǐng)求。6 各階段具體實(shí)現(xiàn)過程6.1項(xiàng)目文件結(jié)構(gòu)圖6.2 用戶注冊(cè)的實(shí)現(xiàn)用戶登錄文件為register.jsp ，用戶輸入用戶名和密碼后，提交“adduserservlet”進(jìn)行驗(yàn)證處理，若用戶名已存在則提示“用戶名已存在,請(qǐng)重新輸入!”，并返回注冊(cè)頁面，否則，把信息寫入數(shù)據(jù)庫，注冊(cè)新用戶?！癮dduserservlet”部分代碼：string username = request.getparameter("name");str

7、ing password = request.getparameter("password");userdbmanager usermng = new userdbmanager();userbean user = usermng.finduser(username);if (user != null && user.getname()!=null && user.getname().equals(username) printwriter out = response.getwriter();out.println("<sc

8、ript>alert('用戶名已存在, 請(qǐng)重新輸入!');history.back();</script>");out.flush();out.close(); else int result = usermng.adduser(username, password);if (result > 0) request.getrequestdispatcher("success.jsp"). forward(request,response); else system.out.println("添加數(shù)據(jù)失敗"

9、);request.getrequestdispatcher("error.jsp"). forward(request,response);6.3 用戶登錄的實(shí)現(xiàn)用戶登錄文件為login.jsp，用來實(shí)現(xiàn)用戶的登錄。用戶輸入用戶名和密碼后，提交"loginservlet"進(jìn)行驗(yàn)證處理，驗(yàn)證正確之后,實(shí)現(xiàn)登陸，轉(zhuǎn)到"displayservlet"，查詢數(shù)據(jù)庫，顯示通訊錄信息。具體代碼如下：“l(fā)oginservle”部分： string username = request.getparameter("name");

10、string password = request.getparameter("password");userdbmanager usermng = new userdbmanager();userbean user = usermng.finduser(username);if(user!=null && user.getpwd()!=null && user.getpwd().equals(password) httpsession session = request.getsession();session.setattribute(&

11、quot;user", user);request.getrequestdispatcher("displayservlet"). forward(request,response);else printwriter out = response.getwriter();out.println("<script>alert('用戶名或密碼錯(cuò)誤, 請(qǐng)重新輸入!');history.back();</script>");out.flush();out.close();“displayservlet”部分：ht

12、tpsession session = request.getsession();userbean user = (userbean) session.getattribute("user");bookdbmanager bookmng = new bookdbmanager();arraylist list = bookmng.findbookbyuserid(user.getid();session.setattribute("books", list);request.getrequestdispatcher("mainpage.jsp&

13、quot;).forward(request, response);登錄成功：6.4 通訊錄名片的添加、修改、刪除操作實(shí)現(xiàn)名片的增加操作，涉及到一下頁面：addbook.jsp 、updatebook.jsp 、bookservlet.java其中，addbook.jsp 、updatebook.jsp 為用戶所見的界面；bookservlet.java處理數(shù)據(jù)實(shí)現(xiàn)數(shù)據(jù)的添加、修改和刪除，將數(shù)據(jù)寫入數(shù)據(jù)庫。添加新聯(lián)系人：修改聯(lián)系人信息：“bookservlet.java”部分代碼：private bookbean makebook(httpservletrequest request) htt

14、psession session = request.getsession();userbean user = (userbean) session.getattribute("user");bookbean book = new bookbean();book.setname(request.getparameter("name");book.setsex(request.getparameter("sex");book.setphone(request.getparameter("phone");book.se

15、thomeaddr(request.getparameter("homeaddr"); book.setmobilephone( request.getparameter("mobilephone");book.setemail(request.getparameter("email");book.setcompany(request.getparameter("company");book.setcomaddr(request.getparameter("comaddr");book.setr

16、elation(integer.parseint( request.getparameter("relation");book.setuserid(user.getid();return book;“dopost”函數(shù)：string type = request.getparameter("type");int result = 0;bookdbmanager bookmng = new bookdbmanager();if (type.equals("del") int bookid = integer.parseint( requ

17、est.getparameter("bookid");result = bookmng.deletebookbyid(bookid); else if (type.equals("add") bookbean book = makebook(request);result = bookmng.addbook(book); else if (type.equals("update") int bookid = integer.parseint( request.getparameter("bookid");bookb

18、ean book = makebook(request);result = bookmng.updatebook(book, bookid);if (result = 0) request.getrequestdispatcher("error.jsp").forward(request, response); else request.getrequestdispatcher("displayservlet") .forward(request,response); 6.5通訊錄名片的分類查詢操作實(shí)現(xiàn)通訊錄名片的分類查詢操作，需要以下頁面：selectservlet.java、mainpage.jsp。其中，selectservlet.java通過查詢數(shù)據(jù)庫中“book”表中“relation”字段，將用戶查詢的分類信息交給mainpage.jsp向用戶顯示，完成交互。代碼如下：httpsession session = request.getsession();userbean user = (userbean) session.getattribute("user");int relation = integer.p