modifymember_deal2.jsp

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

JSP
53 行
字号 
<%@ page contentType="text/html;charset=gb2312"%> 
<%@ page import="java.sql.*"%> 
<html>
<head>
</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 user=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 maijia where username='"+user+"'");
if (rs.next()){
	out.println("<script language='javascript'>alert('用户名重复！');window.location.href='modifyMember2.jsp';</script>");
}else{


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

modifymember_deal2.jsp - 源码说明

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

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

⌨️ 快捷键说明

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