SQL Server数据源连接数据库:
首先在META-INF下新建context.xml,内容如下:
<?xml version="1.0" encoding="UTF-8"?>
<Context reloadable = "true">
<Resource
name="jdbc/__name__" //__name__的值应该和BaseDao中的一致
type="javax.sql.DataSource"
maxActive="4"
maxIdle="2"
maxWait="5000"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost:1433;databaseName=dbname"
username="sa"
password="sasa"/>
</Context>
BaseDao的代码如下:
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.*;
public class BaseDao
{
DataSource datasource;
public BaseDao()
{
try
{
Context context=new InitialContext();
datasource=(DataSource)context.lookup("java:comp/env/jdbc/__name__");
}
catch(NamingException e)
{
e.printStackTrace();
}
}
}
MySql的数据源配置如下:
<?xml version="1.0" encoding="UTF-8"?>
<Context reloadable = "true">
<Resource
name="jdbc/__name__"
type="javax.sql.DataSource"
maxActive="4"
maxIdle="2"
maxWait="5000"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/dbname?serverTimezone=GMT%2B8"
username="root"
password="passwd"/>
</Context>