📄 reset.jsp
字号:
<!-- programmed by fqf
Date:2004/4/12
-->
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html; charset=GBK"%>
<%
String userId=new String();
String userpassword=new String();
String userName=new String();
String userSex=new String();
String userCardNo=new String();
String userPostcode=new String();
String userPhoneNo=new String();
String userAddress=new String();
String userMail=new String();
%>
<%-- 取出用户提交的表单数据--%>
<%
userId=(String)session.getValue("logName");
userpassword=request.getParameter("mima"); //密码
userName=request.getParameter("cnname"); //用户真实姓名
userSex=request.getParameter("sex"); //性别
userCardNo=request.getParameter("code"); //证件号码
userPostcode=request.getParameter("postcode"); //邮政编码
userPhoneNo=request.getParameter("tel"); //电话号码
userAddress=request.getParameter("address"); //地址
userMail=request.getParameter("email"); //E-mail地址
%>
<%-- 更新信息--%>
<% try
{
String url=new String();
url="jdbc:odbc:bookStore";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String SQL=new String();
SQL="update client set ";
SQL=SQL+"password='"+userpassword;
SQL=SQL+"',realName='"+userName;
SQL=SQL+"',sex='"+userSex;
SQL=SQL+"',cardID='"+userCardNo;
SQL=SQL+"',postcode='"+userPostcode;
SQL=SQL+"',telNumber='"+userPhoneNo;
SQL=SQL+"',address='"+userAddress;
SQL=SQL+"',mailbox='"+userMail;
SQL=SQL+"' where logName='"+userId+"'";
stmt.executeUpdate(SQL);
response.sendRedirect("resetOk.htm");
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(e.toString());
}
%>
<html>
<head>
<meta HTTP-EQUIV="Content-Type" CONTENT="text/html;CHARSET=GBK">
<title>修改用户信息</title></head>
<body>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -