在C:/Program Files/Apache Software Foundation/Tomcat 5.5/conf/server.xml中
将如下格式的Resource描述插入server.xml的<Context></Context>中:
<Context path="/rongbin" docBase="rongbin"
debug="5" reloadable="true" crossContext="true">
<Logger
className="org.apache.catalina.logger.FileLogger"
prefix="localhost_MysqlTest_log." suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/rongbin" type="javax.sql.DataSource" username="sa" password="11" driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver" maxIdle="30" maxWait="5000" url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=line" maxActive="100"/>
</Context>
--------------------------
</Host>
--------------------------------------------------------------web.xml------------------------------------------------------------------------------<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/rongbin</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
----------------------------------------------------------------代码-------------------------------------------------------------------------------public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) throws NamingException, SQLException {
LoginForm loginForm = (LoginForm) form;
Connection conn = null;
String JNDINAME = "java:comp/env/jdbc/rongbin";
Context cont = new InitialContext();
DataSource ds = (DataSource) cont.lookup(JNDINAME);
conn = ds.getConnection();
System.out.println("getConnection()--->" + conn);
return (mapping.findForward("Super_Success"));
}-
----------------------------------------------------------------------------------------------------------------------------------------------------
将:msutil.jar、mssqlserver.jar、msbase.jar加到系统classpath里并将这三个文件拷到Tomcat/common/lib和虚拟目录WEB-INF/lib中