📄 modifymessage.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %><%@ page import="java.sql.*" %><%@ page import="yy.Login" %><jsp:useBean id="login" class="Login" scope="session" ></jsp:useBean><% //如果客户直接进入该页面将被转向登录页面。 if(session.isNew()) {response.sendRedirect("login.jsp"); } //如果没有成功登录将被转向登录页面 String success=login.getSuccess(); if(success==null) {success=""; } if(!(success.equals("ok"))) {response.sendRedirect("login.jsp"); }%><HTML><BODY bgcolor=pink ><Font size=3><table align="center" border="0" width="790" height="12" bgcolor=cyan cellspacing="0"> <tr><td width="100%"><a href="<%=response.encodeURL("showMember.jsp")%>">浏览会员</a> | <a href="<%=response.encodeURL("register.jsp")%>">会员注册</a> | <a href="<%=response.encodeURL("login.jsp")%>">会员登录 </a> |<a href="<%=response.encodeURL("find.jsp")%>">查找会员 </a> | <a href="<%=response.encodeURL("Message.jsp")%>">留言板</a>|<a href="<%=response.encodeURL("publicMessage.jsp")%>">查看公共留言</a>|<a href="<%=response.encodeURL("secretMessage.jsp")%>">查看私人留言</a>|<a href="<%=response.encodeURL("modifyPassword.jsp")%>">修改密码 </a> |<a href="<%=response.encodeURL("modifyMessage.jsp")%>">修改个人信息 </a>| </td> </tr> </table></table><%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=pasword name="pasword"><BR>选择新的性别<Input type=radio name="sex" checked="o" value="男">男<Input type=radio name="sex" value="女">女<BR>输入新的年龄<Input type=text name="age" >*<BR>输入新的电话<Input type=text name="phone" >*<BR>输入新的email<Input type=text name="email" >*<BR>输入新的地址<Input type=text name="address" >*<BR>输入新的简历和交友条件: <BR><TextArea name="message" Rows="4" Cols="32"> </TextArea><BR><Input type=submit name="g" value="提交"></FORM><%!//处理字符串的一个常用方法: public String getString(String s) { if(s==null) s="?"; try {byte a[]=s.getBytes("ISO-8859-1"); s=new String(a); } catch(Exception e) {s="?"; } return s; } %><% //获取提交的用户名: String logname=request.getParameter("logname"); logname=getString(logname); //获取提交的密码: String pasword=request.getParameter("pasword"); pasword=getString(pasword); //获取新的性别: String sex=request.getParameter("sex"); sex=getString(sex); String age=request.getParameter("age"); age=getString(age); //获取新email:String email=request.getParameter("email"); email=getString(email); //获取新电话: String phone=request.getParameter("phone"); phone=getString(phone); //获取新地址: String address=request.getParameter("address"); address=getString(address); String message=request.getParameter("message"); message=getString(message); try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException event){} //验证身份: Connection con=null; Statement sql=null; boolean modify=false; try{ con=DriverManager.getConnection("jdbc:odbc:friend","sa",""); sql=con.createStatement(); boolean bo1=logname.equals(login.getLogname()), bo2=pasword.equals(login.getPasword()); if(bo1&&bo2) {//修改信息: String c1="UPDATE member SET sex = "+"'"+sex+"'"+ " WHERE logname = "+"'"+logname+"'"; String c2="UPDATE member SET age = "+"'"+age+"'"+ " WHERE logname = "+"'"+logname+"'"; String c3="UPDATE member SET email = "+"'"+email+"'"+ " WHERE logname = "+"'"+logname+"'"; String c4="UPDATE member SET phone = "+"'"+phone+"'"+ " WHERE logname = "+"'"+logname+"'"; String c5="UPDATE member SET address = "+"'"+address+"'"+ " WHERE logname = "+"'"+logname+"'"; String c6="UPDATE member SET message = "+"'"+message+"'"+ " WHERE logname = "+"'"+logname+"'"; sql.executeUpdate(c1); sql.executeUpdate(c2); sql.executeUpdate(c3); sql.executeUpdate(c4); sql.executeUpdate(c5); sql.executeUpdate(c6); out.print("<BR>您的信息已经更新"); } else {out.print("<BR>您还没有输入密码或您输入的密码或用户名有错误"); } con.close(); } catch(SQLException e1) { out.print("<BR>更新失败"); } %></FONT> </BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -