1234阿塞企业网站系统
<%@page contentType="text/html; charset=gb2312" import="java.sql.*"%> <% String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; //驱动程序,见第十四章 String url = "jdbc:odbc:stud"; //数据库连接语句,见第十四章 String userID = "sa", pwd = "", sql = ""; try { Class.forName(driver); //调入JDBC-ODBC桥的驱动程序 Connection conn = DriverManager.getConnection(url, userID, pwd); //建立与数据的连接 //request对象见第四章 request.setCharacterEncoding("gb2312"); //乱码转换成中文 Statement stmt = conn.createStatement(); //建立Statement的实例,相当于创建一个查询分析器的运行环境 sql = "insert department values('" + request.getParameter("depName") + "')"; if (stmt.executeUpdate(sql) > 0) { response.sendRedirect("DepList.jsp"); //response对象见第四章,连接到memCenter.jsp页面 } } catch (Exception e) { System.out.println(e.getMessage()); } %>