<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%-- 导入java.sql.PreparedStatement类 --%> <%@ page import="java.sql.*"%> <%-- 创建ConnDB类的对象 --%> Insert title here <% 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( ""); }else{ out.println( ""); } }catch (Exception e) {//处理异常 out.println( ""); } conn.close();//关闭数据库连接 %>