.NET连接SqlServer的连接字符串
private
static
con
=
"
Server=
"
服务器
"
;uid=
"
用户名
"
;pwd=
"
密码
"
;database=
"
库名
""
;
SqlConnection myCon
=
new
SqlConnection(con);
<
data-sources
>
<
data-source
key
="Access"
>
<
set-property
property
="password"
value
="tuosi"
/>
<
set-property
property
="minCount"
value
="5"
/>
<
set-property
property
="maxCount"
value
="100"
/>
<
set-property
property
="user"
value
="tuosi"
/>
<
set-property
property
="driverClass"
value
="oracle.jdbc.driver.OracleDriver"
/>
<
set-property
property
="url"
value
="jdbc:oracle:thin:@100.100.99.152:1521:tuosi"
/>
<
set-property
property
="autoCommit"
value
="true"
/>
</
data-source
>
</
data-sources
>
在Action中调用连接
//
DateSource設定
DataSource ds
=
this
.getDataSource(request,
"
Access
"
) ;
//
Connection値設定
Connection conn
=
null
;
conn
=
ds.getConnection() ;


通过配置文件连接Oracle数据库Struts-config.xml















