xiugai.jsp

jsp+acess+tomcat6.0 编写的员工培训管理系统 供初学者参考

<%@page contentType="text/html;charset=GB2312"%>
<%@page import = "java.sql.*"%>
<% request.setCharacterEncoding("GB2312"); %>
<%	
        String user_id=(String)session.getAttribute("user_id");
	String user_nick= request.getParameter("nick");
	String user_name= request.getParameter("name");
	String user_IDcard= request.getParameter("IDcard");
	String user_sex = request.getParameter("sex");
	String user_email= request.getParameter("email");
	String user_tel= request.getParameter("tel");	
	String user_password = request.getParameter("password");
	String user_postalcode = request.getParameter( "postalcode" );
	String user_birthyear= request.getParameter( "birthyear");
	String user_birthmonth= request.getParameter( "birthmonth" );
	String user_favorite = request.getParameter( "favorite");
	String user_addr= request.getParameter( "addr");
	
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection conn = DriverManager.getConnection("jdbc:odbc:movie");
	Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);

	String String_SQL ="UPDATE person SET user_id='"+user_id+"',user_nick='"+user_nick+"',user_name='"+user_name+"',user_IDcard='"+user_IDcard+"',user_sex='"+user_sex+"',user_email='"+user_email+"',user_tel='"+user_tel+"',user_password='"+user_password+"',  user_postalcode='"+user_postalcode+"', user_birthyear='"+user_birthyear+"',user_birthmonth='"+ user_birthmonth+"',user_favorite='"+user_favorite+"',user_addr='"+user_addr+"'WHERE user_id = '" + user_id +"'";

		stmt.executeUpdate(String_SQL);
                response.sendRedirect("usefanhui.jsp");
	stmt.close();
	conn.close();
%>