📄 modifymember_deal2.jsp

📁 解压在c盘

💻 JSP

字号:

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

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -