📄 mod.jsp.htm
字号:
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<html>
<head>
<title>修改验证</title>
</head>
<body>
<%//防止某些用户不进行登陆，直接想进入此页面
if (session.getAttribute("username")==null){
response.sendRedirect("login1.jsp");
}%>
<%
//得到要管理的用户的用户名
String username=request.getParameter("username");
String mo="";
//加载数据库驱动并用连接池连结数据库
String sql="";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.print(e);
}
String strDirPath=application.getRealPath(request.getRequestURI());
strDirPath=strDirPath.substring(0,strDirPath.lastIndexOf('\\'))+"\\";
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+strDirPath+"forum.mdb";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
String password=request.getParameter("password");
String age=request.getParameter("age");
String email=request.getParameter("email");
String phone=request.getParameter("phone");
String address=request.getParameter("address");
int postnumber=Integer.parseInt(request.getParameter("postnumber"));
int rank=Integer.parseInt(request.getParameter("rank"));
String sex=request.getParameter("sex");
String face=request.getParameter("face");
sql="update User set Password='"+password+"',Email='"+email+"',Sex='"+sex+"',Phone='"+phone+"',Address='"+address+"',Age='"+age+"',PostNumber='"+postnumber+"',Rank='"+rank+"',Face='"+face+"' where UserName='"+username+"'";
stmt.executeUpdate(sql);
//修改完后转向到管理页面
response.sendRedirect("listboard.jsp?rankid="+String.valueOf(rank));
%>
<%
//释放数据库连结
stmt.close();
conn.close();
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -