如何利用JBuilder2005开发Web应用程序

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

startup.bat:

C:\Borland\JBuilder2005\

JDK1.4\bin\Javaw -classpath

"C:\Borland\JBuilder2005\thirdparty\

jakarta-tomcat-5.0.27\bin\bootstrap.jar;

C:\Borland\JBuilder2005\jdk1.4\lib\tools.jar" 

"-Dcatalina.home=C:/Borland/JBuilder2005

/thirdparty/jakarta-tomcat-5.0.27" 

org.apache.catalina.startup.Bootstrap -config 

"C:\myWeb\Tomcat\conf\server8080.XML" start

Shutdown.bat:

C:\Borland\JBuilder2005\jdk1.4

\bin\javaw -classpath 

"C:\Borland\JBuilder2005\thirdparty\

jakarta-tomcat-5.0.27\bin\bootstrap.jar;

C:\Borland\JBuilder2005\jdk1.4\lib\tools.jar" 

"-Dcatalina.home=C:/Borland/JBuilder2005

/thirdparty/jakarta-tomcat-5.0.27" 

org.apache.catalina.startup.Bootstrap -config 

"C:\myWeb\Tomcat\conf\server8080.xml" stop

DBTest.xml

＜!--

　Context configuration file for 

the Tomcat Administration Web App

$Id: admin.xml,

v 1.2 2002/07/23 12:13:05 remm Exp $



--＞



＜Context path="/DBTest" 

docBase="/DBTest" debug="5" 

reloadable="true" crossContext="true" 

workDir="../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＞