DatabaseConn.java:
import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;
//一个用于查找数据源的工具类。
public class DatabaseConn {
public static synchronized Connection getConnection() throws Exception
{
try
{
Context initCtx = new javax.naming.InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/store"); ;
return ds.getConnection();//-----------第27行
}
catch(SQLException e)
{
throw e;
}
catch(NamingException e)
{
throw e;
}
}}common/lib下三个包已经放进去,其中msbase.jar包大小是296k.server.xml配置如下
<Context path="/store" reloadable="true" docBase="E:\soft\eclipse\workspace\store" debug="0" crossContext="true">
<Resource name="jdbc/store" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/store">
<parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter>
<parameter> <name>driverClassName</name> <value>com.microsoft.jdbc.sqlserver.SQLServerDriver </value> </parameter>
<parameter> <name>url</name> <value>
jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=store </value> </parameter>
<parameter> <name>username</name> <value>sys </value> </parameter>
<parameter> <name>password</name> <value>sys </value> </parameter>
<parameter> <name>maxActive</name> <value>20 </value> </parameter>
<parameter> <name>maxIdle</name> <value>10 </value> </parameter>
<parameter> <name>maxWait</name> <value>-1 </value> </parameter>
</ResourceParams> </Context>web.xml配置
<resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/store</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>
import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;
//一个用于查找数据源的工具类。
public class DatabaseConn {
public static synchronized Connection getConnection() throws Exception
{
try
{
Context initCtx = new javax.naming.InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/store"); ;
return ds.getConnection();//-----------第27行
}
catch(SQLException e)
{
throw e;
}
catch(NamingException e)
{
throw e;
}
}}common/lib下三个包已经放进去,其中msbase.jar包大小是296k.server.xml配置如下
<Context path="/store" reloadable="true" docBase="E:\soft\eclipse\workspace\store" debug="0" crossContext="true">
<Resource name="jdbc/store" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/store">
<parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter>
<parameter> <name>driverClassName</name> <value>com.microsoft.jdbc.sqlserver.SQLServerDriver </value> </parameter>
<parameter> <name>url</name> <value>
jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=store </value> </parameter>
<parameter> <name>username</name> <value>sys </value> </parameter>
<parameter> <name>password</name> <value>sys </value> </parameter>
<parameter> <name>maxActive</name> <value>20 </value> </parameter>
<parameter> <name>maxIdle</name> <value>10 </value> </parameter>
<parameter> <name>maxWait</name> <value>-1 </value> </parameter>
</ResourceParams> </Context>web.xml配置
<resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/store</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货