我框架的结构基本是这样的,感谢jfy3d(剑事)提供 jfy3d(剑事) ( ) 信誉:98 2006-07-14 22:51:00 得分: 0
我大建好了
------------------------------------
<beans>
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName">
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</property>
<property name="url">
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=PropositionDB</value>
</property>
<property name="username">
<value>sa</value>
</property>
<property name="password">
<value>jfy</value>
</property>
</bean>
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="dataSource">
<ref local="dataSource"/>
</property>
<property name="configLocation">
<value>/WEB-INF/classes/sql-map-config.xml</value>
</property>
</bean>
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
<ref local="dataSource"/>
</property>
</bean>
<bean id="authorDao" class="com.mingti.dao.AuthorDao" singleton="false">
<property name="dataSource">
<ref local="dataSource"/>
</property>
<property name="sqlMapClient">
<ref local="sqlMapClient"/>
</property>
</bean>
<bean id="propositionTypeDao" class="com.mingti.dao.PropositionTypeDao" singleton="false"> <property name="sqlMapClient">
<ref local="sqlMapClient"/>
</property>
</bean>
<web-app> <context-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/classes/applicationContext.xml</param-value>
</context-param> <listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener> <listener>
<listener-class>com.atlassian.xwork.ext.ResolverSetupServletContextListener</listener-class>
</listener> <servlet>
<servlet-name>webwork</servlet-name>
<servlet-class>com.opensymphony.webwork.dispatcher.ServletDispatcher</servlet-class>
<load-on-startup>2</load-on-startup>
</servlet> <servlet>
<servlet-name>dataloader</servlet-name>
<servlet-class>com.mingti.servlets.DataLoader</servlet-class>
<load-on-startup>4</load-on-startup>
</servlet> <servlet>
<servlet-name>freeer</servlet-name>
<servlet-class>com.opensymphony.webwork.views.freeer.FreeerServlet</servlet-class>
<load-on-startup>6</load-on-startup>
</servlet> <servlet-mapping>
<servlet-name>webwork</servlet-name>
<url-pattern>*.ww</url-pattern>
</servlet-mapping>
我大建好了
------------------------------------
<beans>
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName">
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</property>
<property name="url">
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=PropositionDB</value>
</property>
<property name="username">
<value>sa</value>
</property>
<property name="password">
<value>jfy</value>
</property>
</bean>
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="dataSource">
<ref local="dataSource"/>
</property>
<property name="configLocation">
<value>/WEB-INF/classes/sql-map-config.xml</value>
</property>
</bean>
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
<ref local="dataSource"/>
</property>
</bean>
<bean id="authorDao" class="com.mingti.dao.AuthorDao" singleton="false">
<property name="dataSource">
<ref local="dataSource"/>
</property>
<property name="sqlMapClient">
<ref local="sqlMapClient"/>
</property>
</bean>
<bean id="propositionTypeDao" class="com.mingti.dao.PropositionTypeDao" singleton="false"> <property name="sqlMapClient">
<ref local="sqlMapClient"/>
</property>
</bean>
<web-app> <context-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/classes/applicationContext.xml</param-value>
</context-param> <listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener> <listener>
<listener-class>com.atlassian.xwork.ext.ResolverSetupServletContextListener</listener-class>
</listener> <servlet>
<servlet-name>webwork</servlet-name>
<servlet-class>com.opensymphony.webwork.dispatcher.ServletDispatcher</servlet-class>
<load-on-startup>2</load-on-startup>
</servlet> <servlet>
<servlet-name>dataloader</servlet-name>
<servlet-class>com.mingti.servlets.DataLoader</servlet-class>
<load-on-startup>4</load-on-startup>
</servlet> <servlet>
<servlet-name>freeer</servlet-name>
<servlet-class>com.opensymphony.webwork.views.freeer.FreeerServlet</servlet-class>
<load-on-startup>6</load-on-startup>
</servlet> <servlet-mapping>
<servlet-name>webwork</servlet-name>
<url-pattern>*.ww</url-pattern>
</servlet-mapping>
} public Account getAccount(Account account) {
return (Account) smcTemplate
.queryForObject("Account.getAccount", account);
}
-------------------------------------------------------------------------------public class AccountService {
/* Private Fields */
private AccountDao accountDao; public final void setAccountDao(AccountDao accountDao) {
this.accountDao = accountDao;
} /* Public Methods */ public Account getAccount(Account account) {
return (Account) accountDao.getAccount(account);
}------------------------------------------------------------------------------public class AccountBean extends AbstractBean { protected static final AccountService accountService = (AccountService) CustomBeanFactory
.getBean("AccountService");
public String formEditAccount() {
account = accountService.getAccount(account);
......
SELECT * FROM master..sysprocesses
查询之后,发现,所有连接都是被关闭了的!!!!!!!!
现实情况是,没有查询之前是14个线程,查询开始后变成15个,查询结束后又变成14个!!!!
**************************************************************
也就是说,我一开始的方向是错的,不是spring(ibatis)没有关闭连接。
**************************************************************但是现在面临的问题是,sql server的进程sqlservr.exe的内存占用率在高峰时能达到700兆,而在用户已经关闭浏览器离开,占用率也不会下降!到底问题出在哪儿啊??????