数据库连接字符串

.NET连接SqlServer的连接字符串

private   static  con = " Server= " 服务器 " ;uid= " 用户名 " ;pwd= " 密码 " ;database= " 库名 "" ;
SqlConnection myCon = new  SqlConnection(con);

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

< 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() ;