数据源配置(Tomcat)

在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中