7. F9运行应用，myWeb目录中将会生成Tomcat子目录，其中包含了conf子目录，
在Tomcat_HOME/conf/Catalina/localhost目录中生成了DBTest.xml文件
8. 将myWeb/Tomcat/conf目录中的文件server8080.xml加入工程文件，修改server8080.xml的内容
server8080.xml:
＜?xml version="1.0" encoding="UTF-8"?＞
＜Server debug="0" port="8081" shutdown="SHUTDOWN"＞
＜Service name="Catalina"＞
＜Connector acceptCount="10" connectionTimeout="60000" debug="0" maxThreads="75" minSpareThreads="5" port="8080"/＞
＜Engine debug="0" defaultHost="localhost" name="Catalina"＞
＜Host appBase="C:/myWeb/Tomcat/webapps" autoDeploy="false" debug="0" deployXML="false" name="localhost" unpackWARs="false"＞
＜Context path="/DBTest" docBase="C:/myWeb/DBTest" debug="5" reloadable="true" crossContext="true" workDir="C:/myWeb/Tomcat/work/DBTest"＞
＜Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_DBTest_log." suffix=".txt" timestamp="true"/＞
＜Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"/＞
＜ResourceParams name="jdbc/TestDB"＞
＜parameter＞
＜name＞factory＜/name＞
＜value＞org.apache.commons.dbcp.BasicDataSourceFactory＜/value＞
＜/parameter＞
＜!--
Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to handle
all of your db connections. Set to 0 for no limit.
--＞
＜parameter＞
＜name＞maxActive＜/name＞
＜value＞100＜/value＞
＜/parameter＞
＜!--
Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
--＞
＜parameter＞
＜name＞maxIdle＜/name＞
＜value＞30＜/value＞
＜/parameter＞
＜!--
Maximum time to wait for a dB connection to become available
in ms, in this example 10 seconds. An Exception is thrown if
this timeout is exceeded. Set to -1 to wait indefinitely.
--＞
＜parameter＞
＜name＞maxWait＜/name＞
＜value＞10000＜/value＞
＜/parameter＞
＜!-- MySQL dB username and password for dB connections --＞
＜parameter＞
＜name＞username＜/name＞
＜value＞sa＜/value＞
＜/parameter＞
＜parameter＞
＜name＞password＜/name＞
＜value＞topcomputer＜/value＞
＜/parameter＞
＜!-- Class name for mm.mysql JDBC driver --＞
＜parameter＞
＜name＞driverClassName＜/name＞
＜value＞com.microsoft.jdbc.sqlserver.SQLServerDriver＜/value＞
＜/parameter＞
＜!--
The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
connection. mysqld by default closes idle connections after 8 hours.
--＞
＜parameter＞
＜name＞url＜/name＞
＜value＞jdbc:microsoft:sqlserver://nt04:1433;DatabaseName=test＜/value＞
＜/parameter＞
＜/ResourceParams＞
＜/Context＞
＜/Host＞
＜/Engine＞
＜/Service＞
＜/Server＞ |
9. 将JDBC驱动放在C:/Borland/JBuilder2005/thirdparty/jakarta-tomcat-5.0.27/common/lib目录中
10. 在SQL Server中建立数据库test，数据库表文件testdata
creatTable.sql:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[testdata]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[testdata]
GO
CREATE TABLE [dbo].[testdata] (
[id] [int] NOT NULL ,
[foo] [varchar] (50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[bar] [int] NOT NULL
) ON [PRIMARY]
GO
|
输入几条记录作为测试数据。
11. F9
说明：本教程来源互联网或网友上传或出版商，仅为学习研究或媒体推广，wanshiok.com不保证资料的完整性。
2/2 首页 上一页 1 2 |
