配数据库的方式

1 jndi
配置数所源

< context:property-placeholder  location ="jdbc.properties" /> //引入资源文件
     < bean  id ="datasource"  class ="org.apache.commons.dbcp.BasicDataSource"  destroy-method ="close" >
             < property  name ="driverClassName"  value ="org.git.mm.mysql.Driver[${driverClassName}]" />
             < property  name ="url"  value ="jdbc:mysql://localhost:3306/database?useUnicode=true &amp; characterEncoding=UTF-8[${url}]" />
             < property  name ="username"  value ="root[${username}]" />
             < property  name ="password"  value ="root[${password}]" />
             <!--  连接池启动时的初始值勤  -->
             < property  name ="initialSize"  value ="1[${initialSize}]" />
             <!--  连接池的最大值  -->
             < property  name ="maxActive"  value ="500[${maxActive}]" />
             <!--  最大空闲值，当经过一个高峰时间后，连接池可以慢慢将已经用不到的连接释放一部分,一直减少到maxIdle为止  -->
             < property  name ="maxIdle"  value ="2[${maxIdle}]" />
             <!--  最小空闲值，当连接池的连接数量少于阀值时,连接池就会申请一些连接,以免洪峰时来不及申请  -->
             < property  name ="minIdle"  value ="1[${minIdle}]" />
         </ bean >

2 bean

< bean  id ="datasource"  class ="org.apache.commons.dbcp.BasicDataSource" >
         < property  name ="driverClassName"  value ="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
         < property  name ="url"  value ="jdbc:sqlserver://127.0.0.1:1433;databaseName=somken" />
         < property  name ="username"  value ="sa" />
         < property  name ="password"  value ="123456" />
  </ bean >
    
     < bean  id ="sf"  class ="org.springframework.orm.hibernate3.LocalSessionFactoryBean" >
         < property  name ="dataSource"  ref ="datasource" />
        
         < property  name ="mappingResources" >
             < list >
                 < value > org/somken/entity/UserInfo.xml </ value >
             </ list >
         </ property >
        
         < property  name ="hibernateProperties" >
             < props >
                 < prop  key ="hibernate.dialect" > org.hibernate.dialect.SQLServerDialect </ prop >
                 < prop  key ="hibernate.show_sql" > true </ prop >
             </ props >
         </ property >
     </ bean >

3 读取hibernate.cfg.xml

< bean  id ="sf"  class ="org.springframework.orm.hibernate3.LocalSessionFactoryBean" >
           < property  name ="configLocation"  value ="classpath:hibernate.cfg.xml" />
</ bean >