用jsp编写的网上测试系统。



（1）以“Windows身份验证模式”连接SQL Server数据库。



（2）需要安装SQL Server 的补丁SP3。



（3）运行的时候可以参照书上的说明进行，如出试卷的时候，若试卷标题重复，可以从数据库中删除，然后添加试卷。



（4）出试卷路径为 http://localhost:8080/chap22/chujuan.jsp 如果放在根目录，则路径和书上的界面一样。



（5）选择题路径为 http://localhost:8080/chap22/xuanzeti.jsp



（6）判断题路径为 http://localhost:8080/chap22/panduanti.jsp



（7）如果采用本应用中连接数据库的方法调试不通，可以参照20章中通过ODBC连接数据库的方法来修改

将以下代码：

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")

String driver = "jdbc:microsoft:sqlserver://localhost:1433"

Connection conn = DriverManager.getConnection(driver,"","")



修改成：

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")

String driver = "jdbc:odbc:try"

Connection conn = DriverManager.getConnection(driver,"sa","")

//如果是windows验证，则不用用户名和密码 -jsp prepared using online testing system. (1) "Windows authentication model" to SQL Server databases. (2) the need to install SQL Server SP3 patches. (3) Run the reference book can be a descr iption, such as out of the papers, if the papers title repeat can deleted from the database, then add the papers. (4) The path to http://localhost papers : 8080/chap22/chujuan.jsp If on the root directory. while trails and a book on the same interface. (5) multiple-choice path to http://localhost : 8080/chap22/xuanzeti.jsp (6) judgment that path at http :// localhost : 8080/chap22/panduanti.jsp (7) If the application using the data link the method of debugging sense, can refer to Chapter 20 through ODBC to connect to the database approach to the revision of the following codes : JDBC ( &quo