userupdate.jsp

java + sqlserver2000编写的一个网上购书系统,实现了一些基本的功能,但对于初学者来说这个系统已经足以起到帮助作用

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="databean" scope="session" class="ConnBean.conn" />
<%
	ResultSet rset = null;
	ResultSet rset2 = null;
	String userName = (String) session.getAttribute("user");
	String rname = request.getParameter("realname");
	String sex = request.getParameter("sex");
	String telephone = request.getParameter("telephone");
	String address = request.getParameter("address");
	String post = request.getParameter("post");
	String email = request.getParameter("email");
	String birthday = request.getParameter("birthday");
	String educate = request.getParameter("educate");
	try {

		String sql = "select * from userinfo where userName='"
				+ userName + "'";
		String sql1 = "update userinfo set RealName='" + rname
				+ "',Sex='" + sex + "',Telephone='" + telephone
				+ "',Address='" + address + "',Post='" + post
				+ "',Email='" + email + "',Birthday='" + birthday
				+ "',Educate='" + educate + "' where UserName='"
				+ userName + "'";

		rset = databean.executeQuery(sql);

		if (rset.next()) {
			int a = databean.executeUpdate(sql1);
			rset.close();
			//rset2.close();
			out
					.print("<script language=\"JavaScript\">alert(\"修改成功！\");location.href=\"mybandao.jsp\"</script>");

			//response.sendRedirect("index.jsp");

		} else {
			out
					.print("<script language=\"JavaScript\">alert(\"网页存在错误，重新操作！\");location.href=\"mybandao.jsp\"</script>");
		}
	} catch (SQLException e) {
		e.printStackTrace();
	}
%>