注册 登录
编程论坛 J2EE论坛

请教 struts中microsoft sql server的配置

koman 发布于 2008-03-22 19:18, 1262 次点击
问题如题!
1 回复
#2
带头大哥2008-03-23 12:23
struts-config.xml中配置
<data-sources>
    <data-source key="org.apache.struts.action.DATA_SOURCE" type="org.
    <set-property property="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
    <set-property property="url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs" />
    <set-property property="username" value="sa" />
    <set-property property="password" value="" />
    <set-property property="maxActive" value="10" />
    <set-property property="maxIdle" value="3" />
    <set-property property="maxWait" value="60000" />
    <set-property property="defaultAutoCommit" value="true" />
    <set-property property="defaultReadOnly" value="false" />  
    </data-source>  
  </data-sources>
Action中调用
public ActionForward execute(ActionMapping mapping, ActionForm form,
            HttpServletRequest request, HttpServletResponse response) throws Exception {
        // TODO Auto-generated method stub
        DataSource ds = this.getDataSource(request);
        Connection con = ds.getConnection();
        System.out.println(con);
        return null;
    }

需要导的包:javax.sql.DataSource,java.sql.Connection
需要添加的外部开源包commons-pool-1.3.jar,commons-dbcp-1.2.1.jar(这两个包到网上去下多的很)
1