1.jar包
mysql: mysql-connector-java-5.1.0-bin.jar
sqlserver: sqljdbc4-3.0.jar
2.tomcat配置文件
conf/context.xml
<Context>
<Resource name="JNDI名称" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000" username="root" password="root" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/数据库名?useUnicode=true&characterEncoding=utf-8" />
</Context>
mysql:
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/数据库名"
sqlserver:
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost:1433;DatabaseName=数据库名"