Spring-config.xml数据库操作Bean配置

 

<?xml version="1.0" encoding="UTF-8"?>
<beans
    xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">
    <bean id="database"
        class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName"
            value="com.mysql.jdbc.Driver">
        </property>
        <property name="url"
            value="jdbc:mysql://localhost:3306/test?characterEncoding=gbk">
        </property>
        <property name="username" value="root"></property>
        <property name="password" value="sa"></property>
    </bean>
    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource">
            <ref bean="database" />
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">
                    org.hibernate.dialect.MySQLDialect
                </prop>
                <prop key="hibernate.show_sql">
                true
                </prop>
            </props>
        </property>
        <property name="mappingResources">
            <list>
                <value>com/model/Login.hbm.xml</value>
                <value>com/model/U.hbm.xml</value>
            </list>
        </property>
    </bean>
    <bean id="userDao" class="com.dao.UserDao">
        <property name="sessionFactory">
            <ref bean="sessionFactory"></ref>
        </property>
    </bean>
    <bean id="userBo" class="com.bo.UserBo">
    <property name="userDao">
            <ref bean="userDao"></ref>
        </property>
    </bean>
    <bean name="/register" class="com.action.RegisterAction">
        <property name="userBo">
            <ref bean="userBo"></ref>
        </property>
    </bean>
</beans>

数据库操作

public static void main(String[] args) {
  ApplicationContext context = new FileSystemXmlApplicationContext("WebRoot/WEB-INF/spring-config.xml");
  IUserBo userBo = (IUserBo)context.getBean("userBo");
  Login login = new Login();
  login.setUserName("zhong");
  login.setPassword("5");
  userBo.saveUserInfo(login);
 }