You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
83 lines
3.0 KiB
83 lines
3.0 KiB
<%@ page language="java" contentType="text/html; charset=UTF-8"
|
|
pageEncoding="UTF-8"%>
|
|
<%-- 导入java.sql.PreparedStatement类 --%>
|
|
<%@ page import="java.sql.*"%>
|
|
<%-- 创建ConnDB类的对象 --%>
|
|
<jsp:useBean id="conn" scope="page" class="com.tools.ConnDB" />
|
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
|
|
<html>
|
|
<head>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
|
|
<title>Insert title here</title>
|
|
</head>
|
|
<body>
|
|
<%
|
|
String username=request.getParameter("username");
|
|
username = new String(username.getBytes("ISO8859-1"), "UTF-8");
|
|
|
|
String truename=request.getParameter("truename");
|
|
truename = new String(truename.getBytes("ISO8859-1"), "UTF-8");
|
|
|
|
String passWord=request.getParameter("pwd");
|
|
passWord = new String(passWord.getBytes("ISO8859-1"), "UTF-8");
|
|
|
|
String city=request.getParameter("city");
|
|
city = new String(city.getBytes("ISO8859-1"), "UTF-8");
|
|
|
|
String address=request.getParameter("address");
|
|
address = new String(address.getBytes("ISO8859-1"), "UTF-8");
|
|
|
|
String postcode=request.getParameter("postcode");
|
|
postcode = new String(postcode.getBytes("ISO8859-1"), "UTF-8");
|
|
|
|
String cardNO=request.getParameter("cardNO");
|
|
cardNO = new String(cardNO.getBytes("ISO8859-1"), "UTF-8");
|
|
|
|
String cardType=request.getParameter("cardType");
|
|
cardType = new String(cardType.getBytes("ISO8859-1"), "UTF-8");
|
|
|
|
String grade=request.getParameter("grade");
|
|
String amount=request.getParameter("amount");
|
|
|
|
String tel=request.getParameter("tel");
|
|
tel = new String(tel.getBytes("ISO8859-1"), "UTF-8");
|
|
|
|
String email=request.getParameter("email");
|
|
email = new String(email.getBytes("ISO8859-1"), "UTF-8");
|
|
|
|
String sql = "update tb_Member set username=? ,truename=? ,passWord=? ,"
|
|
+"city=? ,address=? ,postcode=? ,cardNO=? ,cardType=? ,grade=? ,"
|
|
+"amount=? ,tel=? ,email=? where username=?";
|
|
try(PreparedStatement pstmt=conn.prepareStatement(sql)){
|
|
pstmt.setString(1,username);
|
|
pstmt.setString(2,truename);
|
|
pstmt.setString(3,passWord);
|
|
pstmt.setString(4,city);
|
|
pstmt.setString(5,address);
|
|
pstmt.setString(6,postcode);
|
|
pstmt.setString(7,cardNO);
|
|
pstmt.setString(8,cardType);
|
|
pstmt.setString(9,grade);
|
|
pstmt.setString(10,amount);
|
|
pstmt.setString(11,tel);
|
|
pstmt.setString(12,email);
|
|
pstmt.setString(13,username);
|
|
int i = pstmt.executeUpdate();
|
|
if (i!=0) {//如果成功修改
|
|
out.println(
|
|
"<script language='javascript'>alert('修改成功');"
|
|
+"window.location.href='modifyMember.jsp?username="+username+"';</script>");
|
|
}else{
|
|
out.println(
|
|
"<script language='javascript'>alert('修改失败');"
|
|
+"window.location.href='modifyMember.jsp?username="+username+"';</script>");
|
|
}
|
|
}catch (Exception e) {//处理异常
|
|
out.println(
|
|
"<script language='javascript'>alert('您的操作有误!');"
|
|
+"window.location.href='modifyMember.jsp?username="+username+"';</script>");
|
|
}
|
|
conn.close();//关闭数据库连接
|
|
%>
|
|
</body>
|
|
</html> |