在Tomcat安装目录,我的是:D:\INSTALL\Tomcat6.0\conf下的context.xml增加以下代码:
<Resource name="jdbc/fwxx" auth="Container" type="javax.sql.DataSource" maxIdle="30" maxActive="100" maxWait="1000" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://localhost:1433;DatabaseName=fwxx" username="sa" password="rootsa" />
在connectionManager类里面
public static Connection getConnection() throws DaoException {
try {
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/fwxx");
connection = ds.getConnection();
} catch(NamingException e) {
throw new DaoException("can not find datasource", e);
}catch (SQLException e) {
throw new DaoException("can not get database connection", e);
}
return connection;
}