📄 modifymessage.jsp
字号:
<HTML>
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*" %>
<%@page import="Register" %>
<%@page import="Login" %>
<jsp:useBean id="login" class="Login" scope="session">
</jsp:useBean>
<% if(session.isNew())
response.sendRedirect("userLogin.jsp");
String success=login.getSuccess();
if(success==null)success="";
if(!(success.equals("ok")))
response.sendRedirect("userLogin.jsp");
%>
<BODY bgcolor=white><Font size=3>
<%@include file="head1.txt"
%>
<% String str=response.encodeURL("modifyMessage.jsp");
%>
<P>输入你的基本信息：真实姓名、电子邮件、电话、邮寄地址。
<FORM action="<%=str%>" method=post>
<BR>输入您的用户名：
<BR><INPUT type="text" name="logname" value="<%=login.getLogname()%>">
<BR>输入您的密码：
<BR><INPUT type="password" name="password">
<BR>输入新的姓名<INPUT type="text" name="realname">*
<BR>输入新的电子邮件<INPUT type="text" name="email">*
<BR>输入新的电话<INPUT type="text" name="phone">*
<BR>输入新的地址<INPUT type="text" name="address">*
<BR><INPUT type="submit" value="提交" name="g">
</FORM>
<%! public String getString(String s)
{
if(s==null)s="";
try
{
byte b[]=s.getBytes("ISO-8859-1");
s=new String(b);
}catch(Exception e){ }
return s;
}
%>
<% String logname,realname,password,email,phone,address;
logname=request.getParameter("logname");
logname =getString(logname);
realname=request.getParameter("realname");
realname =getString(realname);
password=request.getParameter("password");
password =getString(password);
email=request.getParameter("email");
email =getString(email);
phone=request.getParameter("phone");
phone =getString(phone);
address=request.getParameter("address");
address =getString(address);
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){}
Connection con=null;
Statement sql=null;
boolean modify=false;
try
{
con=DriverManager.getConnection("jdbc:odbc:shop","","");
sql=con.createStatement();
boolean bo1=logname.equals(login.getLogname());
boolean bo2=password.equals(login.getPassword());
if(bo1&&bo2)
{
modify=true;
out.print("<BR>您的信息已经更新");
String c1="UPDATE user SET realname="+"'"+ realname+"'"+" WHERE logname="+"'"+logname+"'";
String c2="UPDATE user SET email="+"'"+ email+"'"+" WHERE logname="+"'"+logname+"'";
String c3="UPDATE user SET phone="+"'"+ phone+"'"+" WHERE logname="+"'"+logname+"'";
String c4="UPDATE user SET address="+"'"+ address+"'"+" WHERE logname="+"'"+logname+"'";
sql.executeUpdate(c1);
sql.executeUpdate(c2);
sql.executeUpdate(c3);
sql.executeUpdate(c4);
}
else
out.print("<BR>您还没有输入密码，或您输入的密码或用户名有错误");
con.close();
}catch(SQLException e1){out.print("更新失败");}
%>
</FONT>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -