?? 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 + -