tj.jsp

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

<%@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();

        String sqlstr="insert into kecheng(kc_id,kc_mc,kc_qs,kc_js,kc_ss,kc_rs,kc_ny)  values('"+kc_id+"','"+kc_mc+"','"+kc_qs+"','"+kc_js+"','"+kc_ss+"','"+kc_rs+"','"+kc_ny+"')";
                                                                                 
        stmt.executeUpdate(sqlstr);
        response.sendRedirect("adminfanhui.jsp");
	stmt.close();
	conn.close();
%>