modify_deal.jsp

来自「jsp留言簿,包括留言和回复功能等等」· JSP 代码 · 共 24 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="connBean" scope="page" class="beans.connDB"/>
<%
String username=(new String(request.getParameter("username").getBytes("iso-8859-1"),"gb2312"));
 String PWD=(new String(request.getParameter("PWD1").getBytes("iso-8859-1"),"gb2312"));
String birthday=request.getParameter("birthday");	
 String sex=(new String(request.getParameter("sex").getBytes("iso-8859-1"),"gb2312"));
 String OICQ=(new String(request.getParameter("OICQ").getBytes("iso-8859-1"),"gb2312"));
String tel=(new String(request.getParameter("tel").getBytes("iso-8859-1"),"gb2312"));
 String homepage=(new String(request.getParameter("homepage").getBytes("iso-8859-1"),"gb2312"));
 String address=(new String(request.getParameter("address").getBytes("iso-8859-1"),"gb2312"));
String postcode=request.getParameter("postcode");
 String Email=(new String(request.getParameter("Email").getBytes("iso-8859-1"),"gb2312"));
	int ret=0;
	String sql="update tb_User set PWD='"+PWD+"',Birthday='"+birthday+"',Sex='"+sex+"',OICQ='"+OICQ+"',Tel='"+tel+"',homepage='"+homepage+"',address='"+address+"',postcode='"+postcode+"',Email='"+Email+"' where UserName='"+username+"'";
	ret=connBean.executeUpdate(sql);
	if(ret!=0){
	out.println("<script language='javascript'>alert('资料修改成功！');window.location.href='index.jsp';</script>");
	}else{
	out.println("<script language='javascript'>alert('资料修改失败！');window.location.href='modify.jsp';</script>");
	}
%>