xg.jsp

来自「jsp+acess+tomcat6.0 编写的员工培训管理系统 供初学者参考」· JSP 代码 · 共 24 行

<%@page contentType="text/html;charset=GB2312"%>
<%@page import = "java.sql.*"%>
<% request.setCharacterEncoding("GB2312"); %>
<%	
	String kc_id = request.getParameter("kc_id");
	String kc_mc = request.getParameter("kc_mc");
        String kc_qs = request.getParameter("kc_qs");
        String kc_js = request.getParameter("kc_js");
	String kc_ss = request.getParameter("kc_ss");
	String kc_rs = request.getParameter("kc_rs");
	String kc_ny = request.getParameter("kc_ny");
	
	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 sqlstr="UPDATE  kecheng  SET      kc_id='"+kc_id+"',kc_mc='"+kc_mc+"',kc_qs='"+kc_qs+"',kc_js='"+kc_js+"',kc_ss='"+kc_ss+"',kc_rs='"+kc_rs+"',kc_ny='"+kc_ny+"' where kc_id='"+kc_id+"'";
                                                                                 
        stmt.executeUpdate(sqlstr);
        response.sendRedirect("adminfanhui.jsp");
	stmt.close();
	conn.close();
%>