JavaEE MVC学生登陆源代码Word格式.docx
- 文档编号:16422169
- 上传时间:2022-11-23
- 格式:DOCX
- 页数:23
- 大小:20.05KB
JavaEE MVC学生登陆源代码Word格式.docx
《JavaEE MVC学生登陆源代码Word格式.docx》由会员分享,可在线阅读,更多相关《JavaEE MVC学生登陆源代码Word格式.docx(23页珍藏版)》请在冰豆网上搜索。
doPost(request,response);
*@seeHttpServlet#doPost(HttpServletRequestrequest,HttpServletResponse
protectedvoiddoPost(HttpServletRequestrequest,
Stringaction=request.getParameter("
action"
);
Stringforword="
show.jsp"
;
DBUtildbUtil=newDBUtil();
try{
if(action==null||"
show"
.equals(action)){
request.setAttribute("
stus"
dbUtil.getAllList());
}elseif("
login"
Stringuser=request.getParameter("
user"
Stringpassword=request.getParameter("
password"
Stringpass=dbUtil.getPassword(user);
if(pass==null){
forword="
login.jsp"
request.getSession().setAttribute("
errMsg"
"
账号不存在"
}elseif(pass.equals(password)){
true);
ctrl"
}else{
账号密码不正确"
}
response.sendRedirect(forword);
return;
add"
forword="
edit.jsp"
save"
System.out.println(request.getParameter("
stuName"
));
StringoldStuNum=(String)request.getParameter("
oldStuNum"
StudentDetailstu=newStudentDetail();
stu.setStuNum(request.getParameter("
stuNum"
stu.setStuName(request.getParameter("
stu.setAge(Integer.parseInt(request.getParameter("
age"
)));
stu.setSex(request.getParameter("
sex"
stu.setStuClass(request.getParameter("
stuClass"
stu.setHomeAddress(request.getParameter("
homeAddress"
stu.setPostCode(request.getParameter("
postCode"
System.out.println(stu.toString());
if(oldStuNum!
=null&
&
oldStuNum!
="
"
){
dbUtil.update(stu,oldStuNum);
dbUtil.add(stu);
update"
StringstuNum=request.getParameter("
StudentDetailstu=dbUtil.getStuDetail(stuNum);
stu"
stu);
delete"
dbUtil.delete(stuNum);
addUser"
StringuserName=request.getParameter("
Stringpassword2=request.getParameter("
password2"
if(userName==null||password==null||password2==null){
register.jsp"
信息未填写完整"
elseif(userName.length()>
12||password.length()>
12){
账号密码过长"
}elseif(!
password.equals(password2)){
两次输入密码不一致"
Stringpass=dbUtil.getPassword(userName);
if(pass!
=null){
forword="
request.getSession().setAttribute("
该用户名已经存在"
}else{
dbUtil.addUser(userName,password);
注册成功"
}
response.sendRedirect(forword);
return;
}else{
thrownewException("
指定操作不存在"
}
}catch(Exceptione){
e.printStackTrace();
request.setAttribute("
e.getStackTrace());
forword="
error.jsp"
}
request.getRequestDispatcher(forword).forward(request,response);
}
CheckRight
packagecn.filter;
importjavax.servlet.Filter;
importjavax.servlet.FilterChain;
importjavax.servlet.FilterConfig;
importjavax.servlet.ServletRequest;
importjavax.servlet.ServletResponse;
importjavax.servlet.annotation.WebFilter;
importjavax.servlet.http.HttpSession;
*ServletFilterimplementationclassCheckRight
@WebFilter("
publicclassCheckRightimplementsFilter{
*Defaultconstructor.
publicCheckRight(){
//TODOAuto-generatedconstructorstub
*@seeFilter#destroy()
publicvoiddestroy(){
//TODOAuto-generatedmethodstub
*@seeFilter#doFilter(ServletRequest,ServletResponse,FilterChain)
publicvoiddoFilter(ServletRequestrequest,ServletResponseresponse,
FilterChainchain)throwsIOException,ServletException{
request.setCharacterEncoding("
UTF-8"
response.setCharacterEncoding("
HttpServletRequestreq=(HttpServletRequest)request;
HttpServletResponseres=(HttpServletResponse)response;
HttpSessionsession=req.getSession();
Objectlogin=session.getAttribute("
Stringaction=req.getParameter("
request.setAttribute("
right"
login!
=null);
if("
edit,delete,insert"
.contains(action==null?
"
xx"
:
action)
&
login==null){
res.sendRedirect("
}else
chain.doFilter(request,response);
*@seeFilter#init(FilterConfig)
publicvoidinit(FilterConfigfConfig)throwsServletException{
Encoding
*ServletFilterimplementationclassEncoding
/*"
publicclassEncodingimplementsFilter{
publicEncoding(){
//placeyourcodehere
//passtherequestalongthefilterchain
chain.doFilter(request,response);
DBUtil
packagecn.util;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.PreparedStatement;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importjava.util.ArrayList;
importcn.bean.StudentBean;
publicclassDBUtil{
staticStringlistSQL="
select*fromstudent"
staticStringdetailSQL="
select*fromstudentwherestuID=?
staticStringinsertSQL="
insertintostudent(stuID,stuName,sex,age,stuClass,homeAddress,postCode)values(?
?
)"
staticStringupdateSQL="
updatestudentsetstuID=?
stuName=?
sex=?
age=?
stuClass=?
homeAddress=?
postCode=?
wherestuID=?
staticStringdeleteSQL="
deletefromstudentwherestuID=?
staticStringuserPasswordSQL="
selectuser,passwordfromuserwhereuser=?
staticStringDBDriver="
com.mysql.jdbc.Driver"
staticStringdbURL="
jdbc:
mysql:
//localhost:
3306/student?
characterEncoding=UTF-8"
staticStringdbUser="
root"
staticStringdbPasswd="
115314"
staticStringgetUserAmountSQL="
selectcount(pk)fromuser"
staticStringaddUserSQL="
insertintouser(pk,user,password)values(?
privateConnectioncon;
privatevoidgetConnection()throwsClassNotFoundException,SQLException{
Class.forName(DBDriver);
con=DriverManager.getConnection(dbURL,dbUser,dbPasswd);
privateStatementgetStatement()throwsClassNotFoundException,
SQLException{
if(con==null){
getConnection();
returncon.createStatement();
privatePreparedStatementgetPStat(Stringsql)
throwsClassNotFoundException,SQLException{
returncon.prepareStatement(sql);
publicArrayList<
StudentBean>
getAllList()throwsSQLException,
ClassNotFoundException{
ResultSetrs=getStatement().executeQuery(listSQL);
ArrayList<
stus=newArrayList<
();
while(rs.next()){
StudentBeanstu=newStudentBean();
stu.setStuNum(rs.getString("
stuID"
stu.setStuName(rs.getString("
stu.setSex(rs.getString("
stu.setStuClass(rs.getString("
stus.add(stu);
rs.close();
if(con!
=null){
con.close();
returnstus;
publicStudentDetailgetStuDetail(Stringxh)throwsClassNotFoundException,
StudentDetailstu=null;
PreparedStatementpstat=getPStat(detailSQL);
pstat.setString(1,xh);
ResultSetrs=pstat.executeQuery();
if(r
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- JavaEE MVC学生登陆源代码 MVC 学生 登陆 源代码