spring+hibernate配置文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
    "http://www.springframework.org/dtd/spring-beans.dtd"> 
<beans>
           
    <bean id="dataSource"
        class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName">
            <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
        </property>
        <property name="url">            
            <value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=suntek</value>
        </property>
        <property name="username">
            <value>sa</value>
        </property>
        <property name="password">
            <value></value>
        </property>
        <property name="maxActive">
            <value>25</value>
        </property>
        <property name="maxWait">
            <value>10000</value>
        </property>
        <property name="maxIdle">
            <value>10</value>
        </property>
        <property name="minIdle">
            <value>5</value>
        </property>
    </bean>    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource">
            <ref bean="dataSource" />
        </property>
                 <property name="mappingResources">
                         <list>
                                <value>com/suntek/khgl/zsxx/model/Zsxx.hbm.xml</value>
                          </list>
                </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">
                    org.hibernate.dialect.SQLServerDialect
                </prop>
                <prop key="show_sql">true</prop>
                <prop key="hibernate.connection.useUnicode">true</prop>
                <prop key="hibernate.connection.characterEncoding">
                    UTF-8
                </prop>
            </props>
        </property>
    </bean>
    <bean id="transactionManager"
        class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory">
            <ref local="sessionFactory" />
        </property>
    </bean>
   
    <bean id="iZsxx"
        class="com.suntek.khgl.zsxx.dao.hb.ZsxxDao">
                <property name="sessionFactory">
            <ref local="sessionFactory" />
        </property>
    </bean>  
</beans>
数据源配置文件:
<?xml version='1.0' encoding='utf-8'?>
<Context workDir="work\Catalina\localhost\suntek" path="/suntek" displayName="Struts Example Application" docBase="E:/suntek/suntek" reloadable="true">
  <Resource type="javax.sql.DataSource" name="jdbc/suntekDB"/>
  <ResourceParams name="jdbc/suntekDB">
    <parameter>
      <name>url</name>
      <value>jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=suntekDB</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>sa</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>4</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>5000</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>sa</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>2</value>
    </parameter>
  </ResourceParams>
</Context>
程序调用:
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/suntekDB");//指定所使用的连接池