81,094
社区成员
发帖
与我相关
我的任务
分享
public Connection getConnection()
{
Log log = LogFactory.getLog(DBConnection.class);
Connection conn = null;
DataSource ds = null;
try {
InitialContext ctx=new InitialContext();
ds=(DataSource)ctx.lookup("java:comp/env/jdbc/zltstruts");
conn = ds.getConnection();
System.out.println("访问数据库");
}
catch (SQLException ex) {
ex.printStackTrace();
log.error("数据库连接出错:" + ex.getMessage());
}
catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
<Host name="localhost" debug="0" appBase="webapps"
unpackWARs="true" autoDeploy="true"
xmlValidation="false" xmlNamespaceAware="false">
<Context displayName="zltWeb" docBase="zlt" path="/zlt" reloadable="true">
<Resource auth="Container" name="jdbc/zltstruts" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/zltstruts">
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433;databaseName=comm</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>0</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>150</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>3000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
</ResourceParams>
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
</Context>