tomcat怎样连接两个数据库？

如果是tomcat5以下，则修改conf/server.xml文件，tomcat5及以上则修改／conf/Catalina/localhost目录中的一个xml文件。在</Host>行之前插入如下的一段标签：

(以oralce为例，假设你应用的上下文根是／test,jndi是jdbc/test)

<Context path="/test" docBase="E:\test" >

<Resource name="jdbc/test" auth="Container" type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/test">

<parameter>

<name>username</name>

<value>system</value>

</parameter>

<parameter>

<name>password</name>

<value>manager</value>

</parameter>

<parameter>

<name>driverClassName</name>

<value>oracle.jdbc.driver.OracleDriver</value>

</parameter>

<parameter>

<name>url</name>

<value>jdbc:oracle:thin:@192.168.0.27:1521:titan</value>

</parameter>

</ResourceParams>

</Context>

一、直连接数据库

1 Java 连接 Oralce

[java] view plaincopy

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance()

String url="jdbc:oracle:thin:@localhost:1521:orcl"

Connection conn= DriverManager.getConnection(url,user,password)

2 Java 连接 MySQL

[java] view plaincopy

Class.forName("org.gjt.mm.mysql.Driver ").newInstance()

String URL = "jdbc:mysql://localhost/test"

Connection conn= DriverManager.getConnection(url,user,password)

3 Java 连接SQLServer

[java] view plaincopy

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

String URL =” jdbc:microsoft:sqlserver://localhost:1433DatabaseName=pubs"

Connection conn= DriverManager.getConnection(url,user,password)

4 Java 连接DB2

[java] view plaincopy

Class.forName(“com.ibm.db2.jdbc.app.DB2Driver ").newInstance()

String URL =”jdbc:db2://localhost:5000/sample"

Connection conn= DriverManager.getConnection(url,user,password)

5 Java 连接 Infomix

[java] view plaincopy

Class.forName("com.informix.jdbc.IfxDriver ").newInstance()

String URL ＝jdbc:informix-sqli://123.45.67.89:1533/testDB:INFORMIXSERVER=myserver

Connection conn= DriverManager.getConnection(url,user,password)

6 Java 连接 SyBase

[java] view plaincopy

Class.forName("com.sybase.jdbc.SybDriver").newInstance()

Properties sysProps = System.getProperties()

SysProps.put("user","userid")

SysProps.put("password","user_password")

Connection conn= DriverManager.getConnection(url, SysProps)

7 Java连接 PostgreSQL

[java] view plaincopy

Class.forName("org.postgresql.Driver").newInstance()

String url ="jdbc:postgresql://localhost/soft"

Connection conn= DriverManager.getConnection(url,user,password)

---