📄 modify_info.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改用户资料</title>
</head>
<body>
<%
String strSql="";
String database_username="root";
String database_password="";
String url="jdbc:mysql://localhost/ch3?useUnicode=true&characterEncoding=gb2312";
try
{
//数据库连接
Class.forName("org.gjt.mm.mysql.Driver");
Connection dbConn= DriverManager.getConnection(url,database_username,database_password);
Statement stmt=dbConn.createStatement();
String s_NickName = request.getParameter("NickName");
String s_Sex = request.getParameter("Sex");
String s_Email = request.getParameter("Email");
//获取session中保存的UserID值
String s_UserID = (String) session.getAttribute("UserID");
//将用户资料更新到数据库中
strSql = "update users set NickName='"+s_NickName+"',Sex='"+s_Sex+"',Email='"+s_Email+"' where UserID="+s_UserID;
stmt.executeUpdate(strSql);
out.println("<h1 align=center>用户资料修改成功！</h1>");
out.println("<div align=center><input type=button name=btn0 value=确定 onClick=\"window.location='user_info.jsp'\"></div>");
stmt.close();
dbConn.close();
}
catch(Exception ex)
{
out.println("<h1 align=center>用户资料修改失败</h1>");
out.println("<div align=center><input type=button name=btn1 value=返回 onClick='window.history.go(-1)'></div>");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -