modifymember_deal.jsp

来自「解压在c盘」· JSP 代码 · 共 55 行

JSP
55 行
字号 
<%@ page contentType="text/html;charset=gb2312"%> 
<%@ page import="java.sql.*"%> 
<html>
<head>
<title>会员信息修改!</title>
</head>

<body>

<% 
String spath="wangye/ec.mdb";   
String dbpath = application.getRealPath(spath);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); 
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;
Connection conn= DriverManager.getConnection(url,"",""); 
Statement stmt=conn.createStatement();


 %>
 <%
request.setCharacterEncoding("gb2312");


   String username=request.getParameter("username");
   String truename=request.getParameter("truename");
   String password=request.getParameter("pwd");
   String address=request.getParameter("address");
   String postcode=request.getParameter("postcode");
   String cardno=request.getParameter("cardno");
   String tel=request.getParameter("tel");
   String email=request.getParameter("email");

ResultSet rs=stmt.executeQuery("select * from person where username='"+username+"'");
if (rs.next()){
	out.println("<script language='javascript'>alert('用户名重复！');window.location.href='modifyMember.jsp';</script>");
}else{


	 String sql = "update person set truename='" +
          truename + "',password='" + password +
          "',address='" + address +
          "',postcode='" + postcode + "',cardno='" +
          cardno + "',Tel='" + tel +
          "',email='" + email + "' where username='"+username+"'";
      stmt.executeUpdate(sql);
	session.setAttribute("username",username);
          out.println("<script language='javascript'>alert('会员信息修改成功！');window.location.href='../index.jsp';</script>");
        }
rs.close(); 
stmt.close(); 
conn.close();
%>
</body>
</html>

modifymember_deal.jsp - 源码说明

本页面展示了「解压在c盘」中的 modifymember_deal.jsp 源码文件，采用 JSP 编程语言编写，共 55 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与电子商务相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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