学生管理信息系统Servlet版Eclipse.docx
- 文档编号:5614962
- 上传时间:2022-12-29
- 格式:DOCX
- 页数:33
- 大小:1.15MB
学生管理信息系统Servlet版Eclipse.docx
《学生管理信息系统Servlet版Eclipse.docx》由会员分享,可在线阅读,更多相关《学生管理信息系统Servlet版Eclipse.docx(33页珍藏版)》请在冰豆网上搜索。
学生管理信息系统Servlet版Eclipse
学生管理信息系统Servlet版(Eclipse)
1、新建DynamicWebProject,命名StudentServlet
2、配置项目
1)右击项目->Properties->修改JavaBuilderPath->Browse->在Webcontent下的Web-INF下新建classes文件夹,并选择.
2)复制粘贴两个包到/WEB-INF/lib下,如图:
3)修改字符集,Properties->Resource->将GBK改为UTF-8
3、编写测试类
/src下新建包,包名为com.ls.test,在此包下新建Servlet,创建继承与HttpServlet类的HelloWorld测试类。
代码如下:
packagecom.ls.test;
importjava.io.IOException;
importjava.io.PrintWriter;
importjavax.servlet.ServletException;
importjavax.servlet.annotation.WebServlet;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
/**
*ServletimplementationclassHelloWorld
*/
@WebServlet("/HelloWorld")
publicclassHelloWorldextendsHttpServlet{
privatestaticfinallongserialVersionUID=1L;
/**
*@seeHttpServlet#HttpServlet()
*/
publicHelloWorld(){
super();
//TODOAuto-generatedconstructorstub
}
/**
*@seeHttpServlet#doGet(HttpServletRequestrequest,HttpServletResponseresponse)
*/
protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{
//TODOAuto-generatedmethodstub
response.setContentType("text/html;charset=UTF8");
PrintWriterout=response.getWriter();
out.println("HelloWorld");
}
/**
*@seeHttpServlet#doPost(HttpServletRequestrequest,HttpServletResponseresponse)
*/
protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{
//TODOAuto-generatedmethodstub
}
}
运行测试类,结果如图:
4、新建名为DataBase的folder,用于存放数据库。
将数据库Student脚本文件复制粘贴到/DataBase下:
5、各页面代码:
1)、com.ls.test下显示所有记录的测试类DisplayServlet
packagecom.ls.test;
importjava.io.IOException;
importjava.io.PrintWriter;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importjavax.servlet.ServletException;
importjavax.servlet.annotation.WebServlet;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
/**
*ServletimplementationclassaddStudentServlet
*/
@WebServlet("/disp")
publicclassDisplayServletextendsHttpServlet{
privatestaticfinallongserialVersionUID=1L;
/**
*@seeHttpServlet#HttpServlet()
*/
publicDisplayServlet(){
super();
//TODOAuto-generatedconstructorstub
}
/**
*@seeHttpServlet#doGet(HttpServletRequestrequest,HttpServletResponseresponse)
*/
protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throws
ServletException,IOException{
//TODOAuto-generatedmethodstub
doPost(request,response);
}
/**
*@seeHttpServlet#doPost(HttpServletRequestrequest,HttpServletResponseresponse)
*/
protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throws
ServletException,IOException{
//TODOAuto-generatedmethodstub
response.setContentType("text/html;charset=UTF-8");
PrintWriterout=response.getWriter();
StringconnStr="jdbc:
mysql:
//localhost:
3306/Student?
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";
try{
rs=stmt.executeQuery(sql);
out.println("
out.println("
while(rs.next()){
out.println("
"
"
}
out.println("");
stmt.close();conn.close();
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
}
}
2)com.ls.student.bean下的实体类Student.java
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)连接数据库的SQLHelper类
packagecom.ls.student.bean;
importjava.sql.*;
publicclassSQLHelper{
privateStringdriverStr="com.mysql.jdbc.Driver";
privateStringconnStr="jdbc:
mysql:
//localhost:
3306/Student?
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){
}
}
}
4)com.ls.servlet下的addStudentServlet.java
packagecom.ls.student.servlet;
importjava.io.IOException;
importjava.io.PrintWriter;
importjavax.servlet.ServletException;
importjavax.servlet.annotation.WebServlet;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importcom.ls.student.bean.SQLHelper;
/**
*ServletimplementationclassaddStudentServlet
*/
@WebServlet("/add")
publicclassaddStudentServletextendsHttpServlet{
privatestaticfinallongserialVersionUID=1L;
/**
*@seeHttpServlet#HttpServlet()
*/
publicaddStudentServlet(){
super();
//TODOAuto-generatedconstructorstub
}
/**
*@seeHttpServlet#doGet(HttpServletRequestrequest,HttpServletResponseresponse)
*/
protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{
//TODOAuto-generatedmethodstub
doPost(request,response);
}
/**
*@seeHttpServlet#doPost(HttpServletRequestrequest,HttpServletResponseresponse)
*/
protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{
//TODOAuto-generatedmethodstub
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
//PrintWriterout=response.getWriter();
Stringid=request.getParameter("id");
Stringname=request.getParameter("name");
Stringage=request.getParameter("age");
SQLHelperdb=newSQLHelper();
Stringsql="insertintostudentinfovalues('"+id+
"','"+name+"',"+age+")";
db.executeUpdate(sql);
request.getRequestDispatcher("/list2").forward(request,response);
db.close();
}
}
5)com.ls.servlet下的deleteStudentServlet.java
packagecom.ls.student.servlet;
importjava.io.IOException;
importjavax.servlet.ServletException;
importjavax.servlet.annotation.WebServlet;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importcom.ls.student.bean.SQLHelper;
/**
*ServletimplementationclassdeleteStudentServlet
*/
@WebServlet("/delete")
publicclassdeleteStudentServletextendsHttpServlet{
privatestaticfinallongserialVersionUID=1L;
/**
*@seeHttpServlet#HttpServlet()
*/
publicdeleteStudentServlet(){
super();
//TODOAuto-generatedconstructorstub
}
/**
*@seeHttpServlet#doGet(HttpServletRequestrequest,HttpServletResponseresponse)
*/
protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{
//TODOAuto-generatedmethodstub
doPost(request,response);
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
//PrintWriterout=response.getWriter();
Stringid=request.getParameter("id");
SQLHelperdb=newSQLHelper();
Stringsql="deletefromstudentinfowhereid='"+id+
"'";
db.executeUpdate(sql);
request.getRequestDispatcher("/list2").forward(request,response);
db.close();
}
/**
*@seeHttpServlet#doPost(HttpServletRequestrequest,HttpServletResponseresponse)
*/
protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{
//TODOAuto-generatedmethodstub
}
}
6)com.ls.servlet下的listStudentServlet.java
packagecom.ls.student.servlet;
importjava.io.IOException;
importjava.io.PrintWriter;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjavax.servlet.ServletException;
importjavax.servlet.annotation.WebServlet;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importcom.ls.student.bean.SQLHelper;
/**
*Servleti
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 学生 管理信息系统 Servlet Eclipse
![提示](https://static.bdocx.com/images/bang_tan.gif)