cjsy.jsp

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

<%@page contentType="text/html;charset=GB2312"%>
<%@page import = "java.sql.*"%>
<% request.setCharacterEncoding("GB2312"); %>
<%	
	String user_id = request.getParameter("user_id");
	String kc_id = request.getParameter("kc_id");
        String kc_cj = request.getParameter("kc_cj");

	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection conn = DriverManager.getConnection("jdbc:odbc:movie");
	Statement stmt = conn.createStatement();

        String sqlstr="UPDATE xuanke SET kc_cj='"+kc_cj+"' WHERE user_id='"+user_id+"' AND kc_id='"+kc_id+"'";
                                                                                 
        stmt.executeUpdate(sqlstr);
        response.sendRedirect("cjtj.jsp");
	stmt.close();
	conn.close();
%>