JavaEE实验报告.docx
《JavaEE实验报告.docx》由会员分享,可在线阅读,更多相关《JavaEE实验报告.docx(18页珍藏版)》请在冰豆网上搜索。
JavaEE实验报告
延安大学计算机学院实验报告附页
姓名
班级
实验名称
三、代码部分:
1.登录界面代码login.jsp:
<%@pagelanguage="java"import="java.util.*"pageEncoding="utf-8"%>
DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
用户登录
用户登录
|
用户:
|
密码: | |
|
延安大学计算机学院实验报告附页
姓名
班级
实验名称
2.学生列表代码studentlist.jsp:
<%@pagelanguage="java"contentType="text/html;charset=utf-8"
pageEncoding="utf-8"%>
<%@taglibprefix="c"uri="%>
DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http:
//www.w3.org/TR/html4/loose.dtd">
所有学生信息学生列表
学号 | 姓名 | 年龄 |
forEachvar="student"items="${studentlist}">
${student.sno} | ${student.sname} | ${student.sage} | action=delete&sno=${student.sno}">删除
| action=findedit&sno=${student.sno}">修改
|
forEach>
action=findadd">添加学生
延安大学计算机学院实验报告附页
姓名
班级
实验名称
3.学生编辑代码editstudent.jsp:
<%@pagelanguage="java"contentType="text/html;charset=utf-8"
pageEncoding="utf-8"%>
<%@taglibprefix="c"uri="%>
<%
Stringpath=request.getContentType();
StringbasePath=request.getScheme()+":
//"
+request.getServerName()+":
"+request.getServerPort()
+path+"/";
%>
DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http:
//www.w3.org/TR/html4/loose.dtd">
">
编辑学生信息iftest="${type=='add'}">添加学生
if>
iftest="${type=='edit'}">修改学生
if>
action=${type}"method="post">
学号 | iftest="${emptystudent}">
if> iftest="${! emptystudent}"> value="${student.sno}">
if> |
姓名 | 延安大学计算机学院实验报告附页
姓名
班级
实验名称
iftest="${! emptystudent}">value="${student.sname}"
if> >
|
年龄 | iftest="${! emptystudent}">value="${student.sage}"
if> >
|
|
|
延安大学计算机学院实验报告附页
姓名
班级
实验名称
4.显示学生、连接数据库的JavaBean代码Student:
packagejavabean;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importjava.util.ArrayList;
importjava.util.List;
publicclassStudent{
privateConnectioncon;
privateStatementstmt;
privateResultSetrs;
privateStringsno;
privateStringsname;
privateStringsage;
publicListgetAllStudents(){
Listlist=newArrayList();
Stringsql="select*fromstudent";
try{
rs=executeQuery(sql);
while(rs.next()){
Studenttemp=newStudent();
temp.setSno(rs.getString
(1));
temp.setSname(rs.getString
(2));
temp.setSage(rs.getString(3));
list.add(temp);
}
}catch(Exceptione){
System.out.println(e.toString());
}finally{
close();
}
returnlist;
}
publicvoidadd(Studentstu){
Stringsql="insertintostudentValues('"+stu.getSno()+"','"+stu.getSname()+"',"+stu.getSage()+")";
延安大学计算机学院实验报告附页
姓名
班级
实验名称
try{
executeUpdate(sql);
}catch(Exceptione){
System.out.println(e.toString());
}finally{
close();
}
}
publicvoiddelete(Stringsno){
Stringsql="deletefromstudentWheresno='"+sno+"'";
try{
executeUpdate(sql);
}catch(Exceptione){
System.out.println(e.toString());
}finally{
close();
}
}
publicvoidedit(Studentstu){
Stringsql="updatestudentsetsno='"+stu.getSno()+"',sname="+stu.getSname()+"Wheresage='"+stu.getSage()+"'";
try{
intn=executeUpdate(sql);
}catch(Exceptione){
System.out.println(e.toString());
}finally{
close();
}
}
publicStudentfindStudentByno(Stringsno){
Stringsql="select*fromstudentWheresno='"+sno+"'";
try{
rs=executeQuery(sql);
if(rs.next()){
Studenttemp=newStudent();
temp.setSno(rs.getString
(1));
temp.setSname(rs.getString
(2));
temp.setSage(rs.getString(3));
returntemp;
}
延安大学计算机学院实验报告附页
姓名
班级
实验名称
}catch(Exceptione){
System.out.println(e.toString());
}finally{
close();
}
returnnull;
}
publicintexecuteUpdate(Stringsql)throwsSQLException,ClassNotFoundException{
returngetStatement().executeUpdate(sql);
}
publicvoidclose(){
if(rs!
=null)
try{
rs.close();
}catch(Exceptione){
}
if(stmt!
=null)
try{
stmt.close();
}catch(Exceptione){
}
if(con!
=null)
try{
con.close();
}catch(Exceptione){
}
}
publicResultSetexecuteQuery(Stringsql)throwsSQLException,ClassNotFoundException{
returngetStatement().executeQuery(sql);
}
publicStatementgetStatement()throwsSQLException,ClassNotFoundException{
if(stmt==null){
stmt=getConnection().createStatement();
}
returnstmt;
}
延安大学计算机学院实验报告附页
姓名
班级
实验名称
publicConnectiongetConnection()throwsSQLException,ClassNotFoundException{
if(con==null){
Stringurl="jdbc:
mysql:
//localhost:
3306/Stud";
Stringuser="root";
Stringpassword="admin";
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(url,user,password);
}
returncon;
}
publicStringgetSno(){
returnsno;
}
publicvoidsetSno(Stringsno){
this.sno=sno;
}
publicStringgetSname(){
returnsname;
}
publicvoidsetSname(Stringsname){
this.sname=sname;
}
publicStringgetSage(){
returnsage;
}
publicvoidsetSage(Stringsage){
this.sage=sage;
}
}
延安大学计算机学院实验报告附页
姓名
班级
实验名称
5.处理登录跳转的代码LoginServlet:
packageservlet;
importjava.io.IOException;
importjava.io.PrintWriter;
importjava.sql.*;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
publicclassLoginServletextendsHttpServlet{
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
response.setContentType("text/html");
PrintWriterout=response.getWriter();
Stringid=request.getParameter("user");
Stringpwd=request.getParameter("password");
Connectionconn=null;
PreparedStatementps=null;
ResultSetrs=null;
try{
Class.forName("com.mysql.jdbc.Driver");
Stringurl="jdbc:
mysql:
//localhost:
3306/Stud";
Stringuser="root";
Stringpassword="admin";
conn=DriverManager.getConnection(url,user,password);
ps=conn.prepareStatement("select*fromuserwhereuser=?
andpassword=?
");
ps.setObject(1,id);
ps.setObject(2,pwd);
rs=ps.executeQuery();
if(rs.next()){
response.sendRedirect("studentlist.jsp");
}
else{
request.getRequestDispatcher("/login.jsp").forward(request,response);
}
}
catch(Exceptione){
延安大学计算机学院实验报告附页
姓名
班级
实验名称
catch(Exceptione){
System.out.println("链接数据库失败!
");
System.out.println(e.getMessage());
}
}
}
6.处理数据库编辑显示的跳转页面代码StudentServlet:
packageservlet;
importjava.io.IOException;
importjava.util.List;
importjavabean.Student;
importjavax.servlet.RequestDispatcher;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
publicclassStudentServletssextendsHttpServlet{
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
doPost(request,response);
}
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
request.setCharacterEncoding("utf-8");
Stringsno=request.getParameter("sno");
Stringsname=request.getParameter("sname");
Stringsage=request.getParameter("sage");
Stringaction=request.getParameter("action");
Studentstudent=newStudent();
if(action.equals("list")){
Listlist=student.getAllStudents();
request.setAttribute("studentlist",list);
}
elseif(action.equals("add")){
延安大学计算机学院实验报告附页
姓名
班级
实验名称
Studentinfo=newStudent();
info.setSno(sno);
info.setSname(sname);
info.setSage(sage);
student.add(info);
}
elseif(action.equals("findedit")){
Studentinfo=student.findStudentByno(sno);
request.setAttribute("student",info);
}
elseif(action.equals("delete")){
student.delete(sno);
}
Stringforward;
if(action.equals("findedit")){
request.setAttribute("type","edit");
forward="editstudent.jsp";
}
elseif(action.equals("findadd")){
request.se