modify_deal.jsp

来自「采用TOMCAT+SQL编程」· JSP 代码 · 共 50 行

JSP
50
字号
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<jsp:useBean id="conndb" scope="page" class="beans.connDB"/>
<jsp:useBean id="chstr" scope="page" class="beans.chStr"/>
<html>
<head>
<title>用户修改信息</title>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
</head>
<body>
<%String username=(String)session.getAttribute("Username");
  
  if(username.equals(request.getParameter("username")))
 {
   String password=chstr.chStr(request.getParameter("password"));
   String truename=chstr.chStr(request.getParameter("truename"));
   String card=chstr.chStr(request.getParameter("card"));
   String tel=chstr.chStr(request.getParameter("tel"));
   String area=chstr.chStr(request.getParameter("area"));
   String city=chstr.chStr(request.getParameter("city"));
   String email=chstr.chStr(request.getParameter("email"));
   String address=chstr.chStr(request.getParameter("address"));
   String postcode=chstr.chStr(request.getParameter("postcode"));
   int ret=0;
   
  String sql="update userdata set password='"+password+"',truename='"+truename+"',card='"+card+"',tel='"+tel+"',city='"+city+"',email='"+email+"',address='"+address+"',postcode='"+postcode+"'where username='"+username+"'";
  ret=conndb.executeUpdate(sql);
  if(ret!=0){
%>
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
  <tr bgcolor="E0E0E0" valign="top"> 
    <td bgcolor="E0E0E0" align="center"><%out.println("资料修改成功");%></td>
  </tr>
  <tr bgcolor="E0E0E0" valign="top"> 
    <td bgcolor="E0E0E0"><div align="center">
        <input name="submit" type="button" value="确定" onClick="window.location.href='interest.jsp';">
      </div></td>
  </tr>
</table>
<%}else{%>
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
  <tr bgcolor="E0E0E0" valign="top"> 
    <td bgcolor="E0E0E0" align="center"><%out.println("资料修改失败");%></td>
  </tr>
  <tr bgcolor="E0E0E0" valign="top"> 
    <td bgcolor="E0E0E0"><div align="center">
        <input name="submit" type="button" value="确定" onClick="window.location.href='modify.jsp';">
      </div></td>
  </tr>
</table>
<%}}%>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?