学生管理系统(JSP版)

学生管理系统(JSP版)登录界面：%@pagelanguage=javacontentType=text/html;charset=gb2312pageEncoding=GB2312%htmlheadmetahttp-equiv=Content-Typecontent=text/html;charset=gb2312metahttp-equiv=Content-Languagecontent=zh-cntitle登录/title!--javaScript函数validateLogin()，用来验证是否填写了用户名和密码：--scriptlanguage=JavaScript!--functionvalidateLogin(){varstrUserName=document.frmLogin.StrName.value;varstrPassword=document.frmLogin.StrPassword.value;if(strUserName==){alert(请您输入用户名！);strUserName.focus();returnfalse;}if(strPassword==){alert(请输入密码！);strPassword.focus();returnfalse;}}--/scriptstyletype=text/css!--body{background-image:url(login.JPG);background-repeat:repeat;}--/style/headbodybgcolor=cyanpimgsrc=Logo.jpgwidth=1228height=193/pp /pformmethod=postname=frmLoginaction=Judge.jsponSubmit=javaScript:returnvalidateLogin();h1align=center学生管理系统/h1divalign=centerbrbrtablealign=centerbgColor=#CCCCCCborder=1cellPadding=1cellSpacing=1width=300trtdalign=centerheight=47width=94用户名：/tdtdheight=47width=172align=centerinputname=StrNametype=text/td/trtrtdalign=centerheight=47width=94密  码：/tdtdheight=47width=172align=centerinputname=StrPasswordtype=password/td/trtrtdalign=centerheight=47width=94/tdtdheight=47width=172inputname=Submittype=submitvalue=提交   inputname=Resettype=resetvalue=重置/td/tr/table/div/form/body/html用户验证：%@pagecontentType=text/html;charset=GB2312%%@pageimport=java.sql.*%%!publicStringgetString(Stringstr){Strings=str;try{bytebb[]=s.getBytes(GB2312);s=newString(bb);}catch(Exceptione){}returns;}%%Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver);Connectionconn;Statementstmt;ResultSetrs;Stringuri=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=stuMan;Stringuser=sa;Stringpassword=sa;conn=DriverManager.getConnection(uri,user,password);stmt=conn.createStatement();StringstrUser=request.getParameter(StrName);StringstrPwd=request.getParameter(StrPassword);Stringcondition=select*fromuserswhereuno='+strUser+'andupass='+strPwd+';rs=stmt.executeQuery(condition);if(rs.next()){Integers3=rs.getInt(3);if(s3==1){response.sendRedirect(StuInfo.jsp);}if(s3==0){session.setAttribute(StrName,getString(strUser));response.sendRedirect(Indiv.jsp);}}else{response.sendRedirect(Login.jsp);}rs.close();stmt.close();conn.close();%htmlheadtitleJudge.jsp/title/headbodybgcolor=cyan/body/html跳转界面1：%@pagelanguage=javaimport=java.util.*pageEncoding=GB2312%%@pageimport=myBean.Students%jsp:useBeanid=student1class=myBean.Studentsscope=request/jsp:useBeanhtmlheadtitle学生信息/titlemetahttp-equiv=Content-Typecontent=text/html;charset=gb2312styletype=text/css!--body{background-image:url(StuInfo.jpg);background-repeat:repeat;}--/style/headbodybgcolor=cyanh4align=center所有学生信息表/h4brjsp:getPropertyname=student1property=queryResult//body/html后台代码：packagemyBean;importjava.sql.*;publicclassStudents{StringBufferqueryResult;publicStudents(){queryResult=newStringBuffer();try{Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver);}catch(Exceptione){}}publicStringhandleString(Strings){Stringstr=s;try{bytebb[]=str.getBytes(GB2312);str=newString(bb);returnstr;}catch(Exceptione){returnstr;}}publicStringBuffergetQueryResult(){Connectionconn;Statementstmt;ResultSetrs;Stringuri=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=stuMan;Stringuser=sa;Stringpassword=sa;try{queryResult.append(tablealign=centerborder=1bgcolor=#FFFFFF);conn=DriverManager.getConnection(uri,user,password);stmt=conn.createStatement();rs=stmt.executeQuery(select*fromstudent);queryResult.append(tralign=center);queryResult.append(thalign=centerwidth=50学号/th);queryResult.append(thalign=centerwidth=50姓名/th);queryResult.append(thalign=centerwidth=50性别/th);queryResult.append(thalign=centerwidth=50班级/th);queryResult.append(thalign=centerwidth=100地址/th);queryResult.append(thalign=centerwidth=80出生日期/th);queryResult.append(thalign=centerwidth=100联系方式/th);queryResult.append(thalign=centerwidth=100电子邮件/th);queryResult.append(thalign=centerwidth=80操作列/th);queryResult.append(/tr);while(rs.next()){queryResult.append(tralign=center);for(intk=1;k=8;k++){queryResult.append(tdalign=center+handleString(rs.getString(k))+/td);}queryResult.append(tdalign=centerahref=Update.jsp?sno=+handleString(rs.getString(1))+修改/a|ahref=Delete.jsp?sno=+handleString(rs.getString(1))+删除/a/td);queryResult.append(/tr);}queryResult.append(/table);queryResult.append(br);queryResult.append(divalign='center');queryResult.append(ahref='Addshow.jsp'增加/a);queryResult.append( );queryResult.append( );queryResult.append( );queryResult.append( );queryResult.append(ahref='Login.jsp'返回登录界面/a);queryResult.append(/div);conn.close();}catch(SQLExceptione){e.printStackTrace();}returnqueryResult;}}跳转界面2：%@pagelanguage=javaimport=java.util.*pageEncoding=GB2312%%@pag