学生信息管理系统JSP版

1、学生信息管理系统JSPfK( Eclipse1、新建 newDynamic Web Project名字为 StudentJSP启j New Dynamic Web PrejectDynamic Web Project匚 reate a standalone Dy nsmic V.eb project or add it to a new or existing Ent erprie Application.default configuration provider a good 处arbug 卩oint. Additional facets car later be inftjlled to

2、 dd rewfunctionaIity to the project.EAR membership| | Add prefect to an EAREAR project namNfV/ PfOJ Ct.FinishCaned2、准备工作1)编写JSP测试文件，名称为hello.jsp 修改 hello.jsp的 charset为 UTF-8 加入代码：Hello!v/body世| web .xml国 Hel Io World jva目殆刖西即 3 I= E1 3 DOC TYPE html PUBLIC -/W3C/DTD HTML 4,01 TransitionalZ/EM* http:

3、//TR/l- 4T 5G b rreta h tt p - eq u i v=Con tent - TypeJt co nt en t=J (twt; choretTF-By7 Insert title here8 5二,10 Hello!11 代码：lnsert title hereHello!附：修改默认字符集步骤：Windows-Preference-Web-JSPfiles-将 Encoding 改为 UTF-8tS referente?type filter text:HelpInftall/Upd3：e卜 Java卜 Java E日曲 PersistenceJ

4、avaScriptt MavenL Myl/nPlug-in Development Remcter- RurvrDebugp Server TeamTenTiinalValidation“ W出CSS FilsHTML Fi 已JevsServer Faces ToeJSP FitesWeb Page Editor卜 V sb Serviceip XMLJSP FilesCreating files為dd thii; suffix (rF rot specificd)； jsp*The follcwing encoding will apply：Fgjdirg:至Q舸圧聽愿匹f朝_“”._”

5、_”_” vJANA:UTF-8Search Include JSP matches in Java scarehsRestore DefaultsApplyOICCancel2) 右击项目-Properties-Resurce修改字符集为UTF-8.assepWLdNI-a3M 丑W)Plna BAer-sai)Jadojd-目蚯爭孚 (宙适4)将MySQL中一个jar包复制到/WEB-INF/lib下，如图:戸爲I M耳 JAX-WSWeb 5erwi Bl Libraries* S JavaScript Re&ources一 build.却 WebContEntP B META-INFj

6、 WEB-INF j 占 libt my s q ll-c on necto r-j a va -servlet-a pi.jarj hello.jsp3、在/WebContent下 new 一个 JSPfile 名字为 displayO.jsp代码如下：/ (注意要引入 sql 的包)meta http-equiv=Content-Typelnsert title here 编号 姓名 年龄 %4、在项目下新建一个文件夹 DataBase将用到的学生数据库脚本文件复制到此 目录下Project Explorerb 口亡j山ritJBP前 Deplcyment Descriptor: Stud

7、eniJP b & JAX-WSWeb Service-3 Java Resources马 Java Script Reto urc吕 buildJ 、 DataBase二 stud&nt.sqlj iebContent占 META-INF & WEE-INF卩 & lib国 ditplayO.js-p 舀 displaylsp 冷 hellcjsp5、启动 mysq, Tomcat运行测试 display。.6、改进版本displayl1 )将displayO.jsp复制粘贴到本项目的/WebCont下并修改命名为displayl.jsp2) 在/src下 new一个新包，包名为 coms.

8、student.bean圖 New Packageava PackageCreate a rieava package.匚 reatcs folders c orres pcndingta pac 馬 g 已.Sourcefclden StudentJSP/srcEfw洋”Name:(rndsHStudErit.bein厂 reete pclcjge-infojavaFinishCancel并在此包下新建两个新类来处理 SQL的Helper。Java ClassCr&at& a new Java cla.StudentJSP/srci.camE,5tuMwnt”bE3nBra wee.Brow

9、se. “Scuict folder:Package:1 Enclosing type：Name:Modifiers：Superclass!Interfact:SQLHelper9i public package j private protetted abstract 二| fin別 _ staticjavjangQ 師 ctBrowse. “R;Add.emcjveA hi ch methed stubs would you like to create?O public static void inain&tringn args I_ Constrijctorsfronn supercl

10、assHInherited abtrct methodsDo you v.ant to add connmerits?（匚 onfigure temp Ila and default value i 廿白 Generate commentsFinish匚 an celSQLHelper.jav代码如下：package coms.student.bean;import java.sal.*:/ 引入 sal 相关包public class SQLHelper private Stri ng driverStr = com.mysql.jdbc.Driver private Stri ngconn

11、 Str =jdbc:mysql:/localhost:3306/yStude nt?characterE ncodi ng=utf8privateStr ingdbuser name=root:privateStri ngdbpassword=123456privateConn ecti onconn =n ull :privateStateme ntstmt =null :dbuser name);););public SQLHelper() try Class. forName ( driverStr );conn = DriverMa nager. getC onn ecti on(c

12、onn Strdbpassword );stmt = conn .createStatement(); catch (Exceptionex) System. out .println(exception in SQLHelperpublic int executeUpdate(Stringsql ) int result = 0;try result = stmt .executeUpdate( sql ); catch (Exceptionex) System. out .println(Exception in executeUpdatereturn result ;publicResu

13、ltSet executeQuery(Stringsql ) ResultSet rs = null ;try rs = stmt .executeQuery( sql );if (! rs .next()returnnull ;rs .previous。； catch (Exceptionex) System. out .println(Exception in executeQueryreturn rs ;publicvoidclose() trystmt.close();conn.close();catch(Excepti one) 在此包下新建student类，代码如下package

14、com.ls.student.bean;public class stude nt privateStringid , name;private int age;public stude nt() super ();public student(Stringid , String name, int age) super ();this . id = id ;this .name = name;this . age = age ;public Stri ng getId() return id ;public void setId(Stringid ) this . id = id ;publ

15、ic Stri ng getName() return n ame;public void setName(Stringname) this .name = name;public int getAge() return age;public void setAge( int age) this . age = age ;Overridepublic String toString() + age + retur nStude nt id=+ id + , n ame=+ n ame + , age=直 1孙吕 EE - StudenUSP/rc7com/ls/studenVbejn;5tuc

16、：entjFile Edrt curce Refactor Navigate Sejarth Prcjet:rt U .: - g 虫 M1 食丨 .- lProject Explorer 療 | 戸:笔 -1=1 B* 旳 StudentJSPlDeploynn&ntD etcri ptc r Stu den tJSP 0 JAX-WS Web Servicesj自 R.Ktursj E comJstudEnt-tiEjnff SQLHd|Kr.ja4i student .javaS Libraryb- 啊 JavaScript RejourcesE build卜 L DdtaBaser J

17、 Wphr.nntpnt3) displayl.jsp弋码修改如下：注意先弓I入 java.sql.*包和 com.ls.student.bean包主要代码修改为rt的修改，代码如下： / 引入包meta http-equiv=Content-Typecon te nt =text/html; charset=UTF-8ln sert title here 编号 姓名 年龄 操作 name ) %= rs.getString( ahref =update.jsp?id= 修改   ;  ;  ;  ;  ;  ;  ; a hr

18、ef =delete.jsp?id= 删除 7、实现增加功能新建insert.jsp文件! DOCTYPE html PUBLIC -/W3C/DTD HTML 4.01 Transitional/EN/TR/html4/loose.dtdmeta http-equiv=Content-Typelnsert studentint age=Integer.parseInt(request.getParameter(UTF-8);id);name);age);Stri ng sql= in sert into stude ntinfo values(+id+ ,+

19、n ame+ ,+age+);Class.forName( com.mysql.jdbc.Driver);Conn ecti onconn=DriverManager.getConnection(jdbc:mysql:/localhost:3306/student, root , 123456);Stateme nt stmt= conn. createStateme nt();int result= stmt.executeUpdate(sql);if (result0)out.println(添加记录成功！);else out.println( 添加记录失败！);stmt.close();

20、conn .close();%以及插入的html显示页面，代码：meta http-equiv=Content-Typecontent =text/html; charset=UTF-8lnsert title here请输入学生信息 vform method =postacti on =i nsert.jsp 学号 姓名 年龄 9、删除实现，delete.jsp! DOCTYPE html PUBLIC -/W3C/DTD HTML 4.01 Transitional/EN /TR/html4/loose.dtdcon te nt =text/html; ch

21、arset=UTF-8UTF-8);id);meta http-equiv =Content-Typedelete student 0)out.println(删除记录成功！);else out.println(删除记录失败！)；stmt.close();conn .close();%10、查找 query.jspquery result =+ min Age;if (!maxAge.isEmpty()sql += and age 编号 姓名 年龄 操作(rs. next() %=rs.getString( %=rs.getString( name ) %age ) %x/ td ahref

22、=update.jsp?id= 修改   ;  ;  ;  ;  ;  ;  ; a href =delete.jsp?id= 删除 Query 的 html 页面：meta http-equiv=Content-Typecontent =text/html; charset=UTF-8lnsert title here请输入查询条件 vform method =postacti on =query.jsp 学号 姓名 最小年龄最大年龄 11、查询的 query.jspconten tType=text/html; charse

23、t=UTF-8vhtml vhead query result =+ minAge;if (!maxAge.isEmpty()sql+= and age 编号 姓名 年龄 操作 ahref =update.jsp?id= 修改   ;  ;  ;  ;  ;  ;  ; a href =delete.jsp?id= 删除 12、修改的 update.jsp,! DOCTYPE html PUBLIC -/W3C/DTD HTML 4.01 Transitional/EN /TR/html4/loose.dtdcon te nt =text/html; charset=UTF-8UTF-8);id);name);meta http-equiv =Content-Type update the re