用spring配置的连接,
<bean id="DataSource"
class="com.xxx.web.common.MyBasicDataSource">
<property name="driverClassName"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver">
</property>
<property name="url"
value="jdbc:sqlserver://172.16.9.5:1433;database=intercontract;Reconnection=true">
</property>
<property name="username" value="intercon"></property>
<property name="password" value="98b27691680137ca86818e3e34744a94"></property>
</bean>
在应用中使用JdbcTemplate进行数据库操作,但是sql server 连接数很快就会达到200,用户也只有几个人,请问这是为什么?
<bean id="DataSource"
class="com.xxx.web.common.MyBasicDataSource">
<property name="driverClassName"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver">
</property>
<property name="url"
value="jdbc:sqlserver://172.16.9.5:1433;database=intercontract;Reconnection=true">
</property>
<property name="username" value="intercon"></property>
<property name="password" value="98b27691680137ca86818e3e34744a94"></property>
</bean>
在应用中使用JdbcTemplate进行数据库操作,但是sql server 连接数很快就会达到200,用户也只有几个人,请问这是为什么?
public class DetailImportAction extends DispatchAction{
private ArrayList<String> init (){ ArrayList<String> list1 = new ArrayList<String>(); JdbcTemplate jdbctemp = JDBCUtil.getJdbcTemplate();
StringBuffer kind = new StringBuffer(); //0出厂性质
StringBuffer subcomp = new StringBuffer(); //1子公司
StringBuffer customerkind = new StringBuffer(); //2客户类型
StringBuffer prodkind = new StringBuffer(); //3产品类别
StringBuffer tradelang = new StringBuffer(); //4贸易术语
StringBuffer currency = new StringBuffer(); //5币种
String sql;
ArrayList list = new ArrayList();
ArrayList templist = new ArrayList();
try{
sql = "select * from leave_kind"; //基本信息录入.出厂性质
kind.append("<select id=\"kind\" name=\"kind\"> ");
kind.append("<option value=\"\">出厂性质</option>"); SqlRowSet rs = jdbctemp.queryForRowSet(sql);
while (rs.next()){
kind.append("<option value=\"" + rs.getString(1) + "\">" + rs.getString(2) + "</option>");
} kind.append("</select>");
list1.add(kind.toString());
sql = "select * from sub_comp"; //基本信息录入.子公司
subcomp.append("<select id=\"subcomp\" name=\"subcomp\"> ");
subcomp.append("<option value=\"\">子公司</option>"); rs = jdbctemp.queryForRowSet(sql);
while (rs.next()){
subcomp.append("<option value=\"" + rs.getString(1) + "\">" + rs.getString(2) + "</option>");
} subcomp.append("</select>");
list1.add(subcomp.toString());
sql = "select * from customer_kind"; //基本信息录入.客户类型
customerkind.append("<select id=\"customerkind\" name=\"customerkind\"> ");
customerkind.append("<option value=\"\">客户类型</option>"); rs = jdbctemp.queryForRowSet(sql);
while (rs.next()){
customerkind.append("<option value=\"" + rs.getString(1) + "\">" + rs.getString(2) + "</option>");
} customerkind.append("</select>");
list1.add(customerkind.toString());
sql = "select * from prod_kind"; //基本信息录入.产品类别
prodkind.append("<select id=\"prodkind\" name=\"prodkind\"> ");
prodkind.append("<option value=\"\">产品类别</option>"); rs = jdbctemp.queryForRowSet(sql);
while (rs.next()){
prodkind.append("<option value=\"" + rs.getString(1) + "\">" + rs.getString(2) + "</option>");
} prodkind.append("</select>");
list1.add(prodkind.toString());
sql = "select * from trade_lang"; //基本信息录入.贸易术语
tradelang.append("<select id=\"tradelang\" name=\"tradelang\"> ");
tradelang.append("<option value=\"\">贸易术语</option>"); rs = jdbctemp.queryForRowSet(sql);
while (rs.next()){
tradelang.append("<option value=\"" + rs.getString(1) + "\">" + rs.getString(2) + "</option>");
} tradelang.append("</select>");
list1.add(tradelang.toString());
sql = "select * from currency_kind where 1=1 "; //基本信息录入.币种
currency.append("<select id=\"currency\" name=\"currency\"> ");
currency.append("<option value=\"\">币种</option>"); rs = jdbctemp.queryForRowSet(sql);
while (rs.next()){
currency.append("<option value=\"" + rs.getString(1) + "\">" + rs.getString(2) + "</option>");
} currency.append("</select>");
list1.add(currency.toString());
} catch (Exception ex) { ex.printStackTrace();
}
finally { }
return list1;
}这个要怎么关?
stmt.close();
con.close();
sp_unprepare;1
select * from currency_kind where 1=1
的进程
sp_unprepare;1
select * from currency_kind where 1=1
的进程
参考http://www.javaeye.com/topic/32378