📄 magtodb.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 user=request.getParameter("user");
//接收登陆用户的身份等级信息rankid
int rankid=Integer.parseInt(request.getParameter("rankid"));
//得到用户管理操作的内容（修改用户信息或删除用户）
String work=request.getParameter("work");
//加载数据库驱动并用连接池连结数据库
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();
//如果要修改用户信息
if(work.equals("mdfusr"))
{
String username=request.getParameter("username");
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");
boolean valid=true;
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("manage.jsp?rankid="+String.valueOf(rankid)+"&user="+user+"&work=mdfusr");
}
//如果要删除用户
else{
sql="delete * from User where UserName='"+user+"'";
stmt.executeUpdate(sql);
//删除完后转向到管理页面
response.sendRedirect("manage.jsp?rankid="+String.valueOf(rankid)+"&user="+user+"&work=delusr");
}%>
<%
//释放数据库连结
stmt.close();
conn.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -