学生管理信息系统Servlet版EclipseWord格式文档下载.docx
- 文档编号:18602069
- 上传时间:2022-12-29
- 格式:DOCX
- 页数:33
- 大小:1.15MB
学生管理信息系统Servlet版EclipseWord格式文档下载.docx
《学生管理信息系统Servlet版EclipseWord格式文档下载.docx》由会员分享,可在线阅读,更多相关《学生管理信息系统Servlet版EclipseWord格式文档下载.docx(33页珍藏版)》请在冰豆网上搜索。
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{
}
运行测试类,结果如图:
4、新建名为DataBase的folder,用于存放数据库。
将数据库Student脚本文件复制粘贴到/DataBase下:
5、各页面代码:
1)、com.ls.test下显示所有记录的测试类DisplayServlet
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
*ServletimplementationclassaddStudentServlet
/disp"
publicclassDisplayServletextendsHttpServlet{
publicDisplayServlet(){
protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throws
ServletException,IOException{
doPost(request,response);
protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throws
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"
rs=stmt.executeQuery(sql);
out.println("
<
tablealign=centerwidth=600border=1>
"
tr>
th>
编号<
/th>
姓名<
年龄<
/tr>
while(rs.next()){
out.println("
td>
+rs.getString("
id"
)+
"
/td>
name"
+rs.getInt("
age"
)+"
}
/table>
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){
this.id=id;
this.name=name;
this.age=age;
publicStringgetId(){
returnid;
publicvoidsetId(Stringid){
publicStringgetName(){
returnname;
publicvoidsetName(Stringname){
publicintgetAge(){
returnage;
publicvoidsetAge(intage){
@Override
publicStringtoString(){
return"
Student[id="
+id+"
name="
+name+"
age="
+age+"
]"
3)连接数据库的SQLHelper类
importjava.sql.*;
publicclassSQLHelper{
privateStringdriverStr="
privateStringconnStr="
privateStringdbusername="
privateStringdbpassword="
privateConnectionconn=null;
privateStatementstmt=null;
publicSQLHelper(){
Class.forName(driverStr);
conn=DriverManager.getConnection(connStr,dbusername,dbpassword);
exceptioninSQLHelper"
publicintexecuteUpdate(Stringsql){
intresult=0;
result=stmt.executeUpdate(sql);
ExceptioninexecuteUpdate"
returnresult;
publicResultSetexecuteQuery(Stringsql){
ResultSetrs=null;
if(!
rs.next())returnnull;
rs.previous();
ExceptioninexecuteQuery"
returnrs;
publicvoidclose(){
conn.close();
}catch(Exceptione){
4)com.ls.servlet下的addStudentServlet.java
packagecom.ls.student.servlet;
importcom.ls.student.bean.SQLHelper;
/add"
publicclassaddStudentServletextendsHttpServlet{
publicaddStudentServlet(){
request.setCharacterEncoding("
UTF-8"
//PrintWriterout=response.getWriter();
Stringid=request.getParameter("
Stringname=request.getParameter("
Stringage=request.getParameter("
SQLHelperdb=newSQLHelper();
insertintostudentinfovalues('
+id+
"
'
'
+name+"
"
+age+"
)"
db.executeUpdate(sql);
request.getRequestDispatcher("
/list2"
).forward(request,response);
db.close();
5)com.ls.servlet下的deleteStudentServlet.java
*ServletimplementationclassdeleteStudentServlet
/delete"
publicclassdeleteStudentServletextendsHttpServlet{
publicdeleteStudentServlet(){
deletefromstudentinfowhereid='
6)com.ls.servlet下的listStudentServlet.java
*Servleti
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 学生 管理信息系统 Servlet Eclipse