Location:
Search - JDBC SP3
Search list
Description: 用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 description, 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
Platform: |
Size: 11861 |
Author: fly |
Hits:
Description: 用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 description, 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
Platform: |
Size: 11264 |
Author: fly |
Hits:
Description: jdbc sqlserver2000 驱动。用java操作数据库必须安装此驱动程序-jdbc sqlserver2000 drive. Operation of the database using java to be installed this driver
Platform: |
Size: 2167808 |
Author: 冯小二 |
Hits:
Description: SQLserver2003的java数据库驱动内含三个（msbase.jar mssqlserver.jar msutil.jar）
希望对大家有所作用-The java database-driven SQLserver2003 containing three (msbase.jar mssqlserver.jar msutil.jar) the role of hope all of you
Platform: |
Size: 390144 |
Author: 21 |
Hits:
Description: 用jsp实现网上购书功能
使用说明：
1.将解压得到的BookMarket\WebRoot目录下所有文件拷到tomcat发布目录下新建的文件夹BookMarket下
2.附加...\BookMarket\DataBase目录下db_bookmanage数据库
3.建立数据源book,使其指向上面附加的数据库,注意一定是系统数据源,不然会抛出空指针异常
4.在浏览器里输入http://localhost:8080/BookMarket,则打开了主页
注意:此为MyEclipse6.0.1下的一个Web Project工程
或者升级SQL Server 2000到SP3，使用专用通道进行数据库的JDBC连接
SQL Server2000 SP3要注意，解压之后看到setup.bat这个文件,打开这个文件就开始安装SP3补丁。记得安装后,SQL 服务器是停止了,需要重新启动!安装之后，启动SQL服务器，打开查询分析器，输入select @@version，按F5执行，如果出现Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 3) 则说明SQL Server2000的补丁SP3安装成功。
驱动也要对应SP3的.-To achieve the online purchasing capabilities
Platform: |
Size: 1930240 |
Author: satcon |
Hits:
Description: jsp 平台搭建 操作系统 Microsoft Windows XP Professional (SP3)、
软件 Microsoft SQL Server2000（sp4）、java_ee_sdk-5_06-windows-ml.exe、apache-tomcat-5.5.26.exe、SQL Server 2000 Driver for JDBC.exe
-jsp platform to build the operating system Microsoft Windows XP Professional (SP3), software, Microsoft SQL Server2000 (sp4), java_ee_sdk-5_06-windows-ml.exe, apache-tomcat-5.5.26.exe, SQL Server 2000 Driver for JDBC.exe
Platform: |
Size: 240640 |
Author: ishede |
Hits:
Description: sql2000 sp3 java包，连接数据库的时候必须要引入这个包的-sql2000 sp3 java
Platform: |
Size: 390144 |
Author: huangwenwei |
Hits: