📄 user_updateext.jsp
字号:
<%@page contentType="text/html;charset=Gb2312"
import="java.sql.*,java.util.Date"%>
<jsp:useBean id="pool" scope="application" class="com.PoolBean"/>
<%
String strLoginUser = (String)session.getAttribute("LoginUser");
if (strLoginUser == null || strLoginUser.length() == 0)
response.sendRedirect("Login.jsp");
%>
<html>
<head>
<title><h1>用户信息修改</h1></title>
</head>
<body>
<%
String user_password,user_sex,user_birthday,user_year;
String user_month,user_day,user_duty,user_workplace;
String user_tel,user_address,user_email;
user_password = new
String( request.getParameter("user_password").getBytes("8859_1"));
user_sex = new
String( request.getParameter("user_sex").getBytes("8859_1"));
user_year = new
String( request.getParameter("user_year").getBytes("8859_1"));
user_month = new
String( request.getParameter("user_month").getBytes("8859_1"));
user_day = new
String( request.getParameter("user_day").getBytes("8859_1"));
user_duty = new
String( request.getParameter("user_duty").getBytes("8859_1"));
user_workplace = new
String( request.getParameter("user_workplace").getBytes("8859_1"));
user_address = new
String( request.getParameter("user_address").getBytes("8859_1"));
user_tel = new
String( request.getParameter("user_tel").getBytes("8859_1"));
user_email = new
String( request.getParameter("user_email").getBytes("8859_1"));
out.println(user_email);
user_birthday=user_year+"-"+user_month+"-"+user_day;
try
{
if (pool.getConnectionSize() == 0)
{
pool.initializePool();
}
Connection con = null;
Statement stmt = null;
con = pool.getConnection();
stmt= con.createStatement();
String strUpd ="update user set password='" + user_password + "',sex='"+user_sex+"',birthday='"+user_birthday+"',duty='"+user_duty+"',workplace='"+user_workplace+"',address='"+user_address+"',telephone='"+user_tel+"',email='"+user_email+"' where code='"+strLoginUser+"'";
//out.println(strUpd);
stmt.executeUpdate(strUpd);
stmt.close();//关闭Statement对象
pool.releaseConnection(con);
response.sendRedirect("Login.jsp");
}
catch (Exception e)
{
out.println(e.getMessage());
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -