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

转载于:https://www.cnblogs.com/hubcarl/archive/2011/04/28/2031711.html