📄 modifymember_deal.jsp

📁 解压在c盘

💻 JSP

字号:

<%@ 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>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -