sqlserver 的连接池配置

?<?xml version="1.0" encoding="UTF-8"?>

<!-- $Id: mysql-ds.xml,v 1.1.2.1 2003/12/12 19:19:56 starksm Exp $ -->
<!--? Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->

<datasources>
? <local-tx-datasource>
??? <jndi-name>MySqlServer</jndi-name>
??? <connection-url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=LEDDATA</connection-url>
??? <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<parameter>??
????????????? <name>maxActive</name>??
????????????? <value>20</value>??
????????? </parameter>??
????????? <parameter>??
????????????? <name>maxIdle</name>??
????????????? <value>10</value>??
????????? </parameter>??
????????? <parameter>??
????????????? <name>maxWait</name>??
????????????? <value>-1</value>???????
????????? </parameter>
??? <user-name>sa</user-name>
??? <password>guoyin</password>
<min-pool-size>20</min-pool-size>
?<max-pool-size>200</max-pool-size>
? </local-tx-datasource>
</datasources>

?

//java中写入

package com.prg.safety.model.business.LEDScreenSet.datasource;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import javax.naming.InitialContext;
import javax.sql.DataSource;

public class DataSourceManager {
?public DataSourceManager(){};
?private InitialContext ctx=null;
?private Connection conn=null;
?private DataSource ds=null;
?private Statement stmt=null;
?//datasource
?public boolean DataSourceConnection(String path){??
??try {
???ctx = new InitialContext();
???ds = (DataSource)ctx.lookup("java:/MySqlServer");//这里要和mySqlServer-ds.xml中对应
???if(null!=ds){
????//得到连接
????conn = ds.getConnection();
????if(null!=conn){
?????stmt= conn.createStatement();
?????String sql = "update PICNAME SET FILENAME='" + path + "'";
?????int i = stmt.executeUpdate(sql);
?????if(i>0){
??????return true;
?????}??????
????}
???}???
????
??} catch (Exception e) {
???// TODO Auto-generated catch block
???e.printStackTrace();
??} finally{
???if(stmt!=null)??????
?????stmt=null;
????
???if(conn!=null)????
?????conn=null;??????
??}
??return false;
?}

}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!