北信科JavaWeb基于MVC的簡單數(shù)據(jù)庫管理系統(tǒng)

1、實(shí) 驗(yàn) 報 告課程名稱： web程序設(shè)計 實(shí)驗(yàn)題目： 實(shí)驗(yàn)四 基于mvc的簡單數(shù)據(jù)庫管理系統(tǒng) 學(xué) 院： 計算機(jī)學(xué)院 專 業(yè)： 網(wǎng)絡(luò)工程 指導(dǎo)教師： 施 運(yùn) 梅 日 期： 2013年 6 月 19日 實(shí)驗(yàn)四 基于mvc的簡單數(shù)據(jù)庫管理系統(tǒng)1、 實(shí)驗(yàn)?zāi)康?、理解mvc設(shè)計思想。2、掌握基于mvc的編程技術(shù)，掌握視圖層、模型層和控制層的設(shè)計方法。2、 實(shí)驗(yàn)內(nèi)容及要求用mvc思想，編寫根據(jù)姓名查找學(xué)生記錄的應(yīng)用。三、實(shí)驗(yàn)步驟（1）創(chuàng)建數(shù)據(jù)庫用mysql創(chuàng)建一個名為student的數(shù)據(jù)庫、設(shè)置xuehao幾項(xiàng)并填入數(shù)據(jù) （2）設(shè)計模型層和視圖層模型層兩個類：studentbean.java：存放學(xué)生信息

2、（實(shí)體類）。studentdao.java：查詢數(shù)據(jù)庫。視圖層三個文件： queryform.jsp：為用戶提供輸入查詢條件的表單。 queryresult.jsp：如果查詢到記錄，則顯示響應(yīng)的結(jié)果。noresult.jsp：如果沒有查詢到記錄，顯示提示信息。（3） queryform.jsp頁面 queryresult.jsp頁面noresult.jsp頁面 studentbean.java代碼public class studentbean private string num;private string name;private string sex;private string bi

3、rth;private string add;public string getxuehao() return num;public void setxuehao(string xuehao) this.num = num;public string getname() return name;public void setname(string name) = name;public string getsex() return sex;public void setsex(string sex) this.sex = sex;public string getbirth

4、() return birth;public void setbirth(string birth) this.birth = birth;public string getadd() return add;public void setadd(string add) this.add = add; studentdao.java代碼package student;import java.sql.connection;import java.sql.drivermanager;import java.sql.resultset;import java.sql.sqlexception;impo

5、rt java.util.arraylist;import student.studentbean;public class studentdao /*此dao用于連接數(shù)據(jù)庫*/先定義一個connection,方便在以后的各個方法當(dāng)中進(jìn)行調(diào)用private connection conn = null;/采用構(gòu)造函數(shù)進(jìn)行數(shù)據(jù)庫連接的初始化public studentdao() try class.forname("com.mysql.jdbc.driver");/加載驅(qū)動conn = drivermanager.getconnection("jdbc:mysql:

6、/localhost:3306/test","root","000120"); catch (classnotfoundexception e) e.printstacktrace(); catch (sqlexception e) e.printstacktrace();public arraylist querylike(string sname) arraylist al = new arraylist();/先實(shí)例化一個容器string sql = "select * from student where name ='

7、;" + sname + "'"try resultset rs = conn.createstatement().executequery(sql);while(rs.next() studentbean st = new studentbean();/實(shí)例化一個實(shí)體類/將結(jié)果集當(dāng)前記錄當(dāng)中的id設(shè)置給st對象當(dāng)中，完成數(shù)據(jù)的封裝，以下類同st.setnum(rs.getstring("num");st.setname(rs.getstring("name");st.setsex(rs.getstring(&quo

8、t;sex");st.setbirth(rs.getstring("birth");st.setadd(rs.getstring("add");al.add(st);/將結(jié)果保存在list當(dāng)中 catch (sqlexception e) e.printstacktrace();finally this.closeconn();/最后關(guān)閉連接return al;/將數(shù)據(jù)返回/關(guān)閉connpublic void closeconn() try if(conn !=null) conn.close();conn = null; catch (sql

9、exception e) e.printstacktrace();queryservlet.java代碼queryservlet.java功能：接收用戶的查詢請求，并根據(jù)用戶輸入的姓名調(diào)用studentdao類查詢數(shù)據(jù)庫。根據(jù)查詢結(jié)果轉(zhuǎn)至不同的頁面。package servlet;import java.io.ioexception;import java.io.printwriter;import java.util.arraylist;import javax.servlet.servletexception;import javax.servlet.http.httpservlet;im

10、port javax.servlet.http.httpservletrequest;import javax.servlet.http.httpservletresponse;import student.studentbean;import student.studentdao;public class queryservlet extends httpservlet /* * constructor of the object. */public queryservlet() super();/* * destruction of the servlet. <br> */pu

11、blic void destroy() super.destroy(); /* * 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

12、 servletexception if an error occurred * throws ioexception if an error occurred */public void dopost(httpservletrequest request, httpservletresponse response)throws servletexception, ioexception request.setcharacterencoding("gb2312");response.setcharacterencoding("gb2312");strin

13、g sname = request.getparameter("sname");/實(shí)例化dao，并調(diào)用dao的查詢方法，將sname做為參數(shù)傳入進(jìn)去studentdao qd = new studentdao();arraylist al = qd.querylike(sname);/調(diào)用查詢方法request.setattribute("al", al);/將結(jié)果保存在request當(dāng)中，方便jsp調(diào)用/頁面跳轉(zhuǎn)if(al.isempty()request.getrequestdispatcher("/noresult.jsp").forward(request, response);elserequest.getrequestdispatcher("/queryresult.jsp").forward(request, response);/* * initialization of the servlet. <br> *