首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > JAVA > J2SE开发 >

DataSource解决思路

2012-04-05 
DataSource请问一下,如何用java程序编写一个DataSource连接的数据库呀?[解决办法] data-sourcesdata-so

DataSource
请问一下,如何用java程序编写一个DataSource连接的数据库呀?

[解决办法]
<data-sources>
<data-source type= "org.apache.commons.dbcp.BasicDataSource ">
<set-property property= "driverClassName "
value= "com.microsoft.jdbc.sqlserver.SQLServerDriver " />
<set-property property= "url "
value= "jdbc:microsoft:sqlserver://localhost:1433;databaseName=baidu " />
<set-property property= "username " value= "sa " />
<set-property property= "password " value= " " />
<set-property property= "maxActive " value= "20 " />
<set-property property= "maxWait " value= "5000 " />
<set-property property= "defaultAutoCommit " value= "true " />
<set-property property= "defaultReadOnly " value= "false " />
<set-property property= "validationQuery " value= "SELECT 1 " />
<set-property property= "removeAbandoned " value= "true " />
<set-property property= "removeAbandonedTimeout " value= "120 " />
<set-property property= "encoding " value= "false " />
</data-source>
</data-sources>

热点排行
Bad Request.