学生信息管理系统JSP版Eclipse.docx
- 文档编号:8909228
- 上传时间:2023-02-02
- 格式:DOCX
- 页数:25
- 大小:696.86KB
学生信息管理系统JSP版Eclipse.docx
《学生信息管理系统JSP版Eclipse.docx》由会员分享,可在线阅读,更多相关《学生信息管理系统JSP版Eclipse.docx(25页珍藏版)》请在冰豆网上搜索。
学生信息管理系统JSP版Eclipse
学生信息管理系统JSP版(Eclipse)
1、新建new->DynamicWebProject->名字为StudentJSP。
2、准备工作
1)编写JSP测试文件,名称为hello.jsp
修改hello.jsp的charset为UTF-8
加入代码:
Hello!代码:
<%@pagelanguage="java"contentType="text/html;charset=UTF-8"
pageEncoding="UTF-8"%>
DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http:
//www.w3.org/TR/html4/loose.dtd">
Hello!
附:
修改默认字符集步骤:
Windows->Preference->Web->JSPfiles->将Encoding改为UTF-8
2)右击项目->Properties->Resurce->修改字符集为UTF-8.
3)右击项目->Properties->JavaBuildPath改为如图(需先在WEB-INF下新建classes)
4)将MySQL中一个jar包复制到/WEB-INF/lib下,如图:
3、在/WebContent下new一个JSPfile,名字为display0.jsp
代码如下:
<%@pagelanguage="java"contentType="text/html;charset=UTF-8"
pageEncoding="UTF-8"%>
<%@pageimport="java.sql.*"%>//(注意要引入sql的包)
DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http:
//www.w3.org/TR/html4/loose.dtd">
<%
StringconnStr="jdbc:
mysql:
//localhost:
3306/yStudent?
characterEncoding=utf8";
Connectionconn=null;
Statementstmt=null;
ResultSetrs;
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection(connStr,"root","123456");
stmt=conn.createStatement();
}catch(Exceptionex){
ex.printStackTrace();
System.out.println("exceptioningetConnection");
}
Stringsql="select*fromstudentinfo";//表明为studentinfo
try{
rs=stmt.executeQuery(sql);
%>
<%while(rs.next()){%>
<%}%>
<%stmt.close();
conn.close();
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
%>
%>
4、在项目下新建一个文件夹DataBase,将用到的学生数据库脚本文件复制到此目录下
5、启动mysql,Tomcat],运行测试display0.
6、改进版本display1
1)将display0.jsp复制粘贴到本项目的/WebCont下并修改命名为display1.jsp
2)在/src下new一个新包,包名为com.ls.student.bean
并在此包下新建两个新类来处理SQL的Helper。
SQLHelper.java代码如下:
packagecom.ls.student.bean;
importjava.sql.*;//引入sql相关包
publicclassSQLHelper{
privateStringdriverStr="com.mysql.jdbc.Driver";
privateStringconnStr="jdbc:
mysql:
//localhost:
3306/yStudent?
characterEncoding=utf8";
privateStringdbusername="root";
privateStringdbpassword="123456";
privateConnectionconn=null;
privateStatementstmt=null;
publicSQLHelper(){
try{
Class.forName(driverStr);
conn=DriverManager.getConnection(connStr,dbusername,dbpassword);
stmt=conn.createStatement();
}catch(Exceptionex){
System.out.println("exceptioninSQLHelper");
}
}
publicintexecuteUpdate(Stringsql){
intresult=0;
try{
result=stmt.executeUpdate(sql);
}catch(Exceptionex){
System.out.println("ExceptioninexecuteUpdate");
}
returnresult;
}
publicResultSetexecuteQuery(Stringsql){
ResultSetrs=null;
try{
rs=stmt.executeQuery(sql);
if(!
rs.next())returnnull;
rs.previous();
}catch(Exceptionex){
System.out.println("ExceptioninexecuteQuery");
}
returnrs;
}
publicvoidclose(){
try{
stmt.close();
conn.close();
}catch(Exceptione){
}
}
}
在此包下新建student类,代码如下
packagecom.ls.student.bean;
publicclassstudent{
privateStringid,name;
privateintage;
publicstudent(){
super();
}
publicstudent(Stringid,Stringname,intage){
super();
this.id=id;
this.name=name;
this.age=age;
}
publicStringgetId(){
returnid;
}
publicvoidsetId(Stringid){
this.id=id;
}
publicStringgetName(){
returnname;
}
publicvoidsetName(Stringname){
this.name=name;
}
publicintgetAge(){
returnage;
}
publicvoidsetAge(intage){
this.age=age;
}
@Override
publicStringtoString(){
return"Student[id="+id+",name="+name+",age="+age+"]";
}
}
3)display1.jsp代码修改如下:
注意先引入java.sql.*包和com.ls.student.bean包
主要代码修改为
内的修改,代码如下:<%@pagelanguage="java"contentType="text/html;charset=UTF-8"
pageEncoding="UTF-8"%>
<%@pageimport="java.sql.*;importcom.ls.student.bean.*"%>//引入包
DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http:
//www.w3.org/TR/html4/loose.dtd">
<%
SQLHelperdb=newSQLHelper();
Stringsql="select*fromstudentinfo";
ResultSetrs=db.executeQuery(sql);
%>
<%while(rs.next()){%>
id=<%=rs.getString("id")%>">修改
id=<%=rs.getString("id")%>">删除
<%}%>
<%db.close();%>
7、实现增加功能
新建insert.jsp文件
<%@pagelanguage="java"contentType="text/html;charset=UTF-8"
pageEncoding="UTF-8"%>
<%@pageimport="java.sql.*"%>
DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http:
//www.w3.org/TR/html4/loose.dtd">
<%@includefile="head.jsp"%>
<%
request.setCharacterEncoding("UTF-8");
Stringid=request.getParameter("id");
Stringname=request.getParameter("name");
intage=Integer.parseInt(request.getParameter("age"));
Stringsql="insertintostudentinfovalues('"+id+"','"+name+"',"+age+")";
Class.forName("com.mysql.jdbc.Driver");
Connectionconn=DriverManager.getConnection("jdbc:
mysql:
//localhost:
3306/student","root","123456");
Statementstmt=conn.createStatement();
intresult=stmt.executeUpdate(sql);
if(result>0)
out.println("添加记录成功!
");
elseout.println("添加记录失败!
");
stmt.close();
conn.close();
%>
以及插入的html显示页面,代码:
DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http:
//www.w3.org/TR/html4/loose.dtd">
请输入学生信息
9、删除实现,delete.jsp
<%@pagelanguage="java"contentType="text/html;charset=UTF-8"
pageEncoding="UTF-8"%>
<%@pageimport="java.sql.*"%>
DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http:
//www.w3.org/TR/html4/loose.dtd">
<%@includefile="head.jsp"%>
<%
request.setCharacterEncoding("UTF-8");
Stringid=request.getParameter("id");
Stringsql="deletefromstudentinfowhereid='"+id+"'";
Class.forName("com.mysql.jdbc.Driver");
Connectionconn=DriverManager.getConnection("jdbc:
mysql:
//localhost:
3306/student","root","123456");
Statementstmt=conn.createStatement();
intresult=stmt.executeUpdate(sql);
if(result>0)
out.println("删除记录成功!
");
elseout.println("删除记录失败!
");
stmt.close();
conn.close();
%>
10、查找query.jsp
<%@pagelanguage="java"contentType="text/html;charset=UTF-8"
pageEncoding="UTF-8"%>
<%@pageimport="java.sql.*"%>
DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http:
//www.w3.org/TR/html4/loose.dtd">
<%@includefile="head.jsp"%>
<%
request.setCharacterEncoding("UTF-8");
Stringid=request.getParameter("id");
Stringname=request.getParameter("name");
StringminAge=request.getParameter("minAge");
StringmaxAge=request.getParameter("maxAge");
Stringsql="select*fromstudentinfowheretrue";
if(!
id.isEmpty())
sql+="andid='"+id+"'";
if(!
name.isEmpty())
sql+="andname='"+name+"'";
if(!
minAge.isEmpty())
sql+="andage>="+minAge;
if(!
maxAge.isEmpty())
sql+="andage<="+maxAge;
Class.forName("com.mysql.jdbc.Driver");
Connectionconn=DriverManager.getConnection("jdbc:
mysql:
//localhost:
3306/student","root","123456");
Statementstmt=conn.createStatement();
ResultSetrs=stmt.executeQuery(sql);
%>
<%while(rs.next()){%>
id=<%=rs.getString("id")%>">修改
id=<%=rs.getString("id")%>">删除
<%}
rs.close();stmt.close();conn.close();
%>
Query的html页面:
DOCTYPEhtmlPUBLI
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 学生 信息管理 系统 JSP Eclipse