spring+hibernate+mysql实例

spring+hibernate+mysq实例

applicationContext.xml

<beans>

 <bean id="dataSource"

class="org.springframework.jdbc.datasource.DriverManagerDataSource"><!--或者<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">-->

 

  <property name="driverClassName">
   <value>com.mysql.jdbc.Driver</value>
  </property>
  <property name="url">
   <value>jdbc:mysql://192.168.1.11/test</value>
  </property>
  <property name="username">
   <value>root</value>
  </property>
  <property name="password">
   <value>0</value>
  </property>
 </bean>
 <bean id="sessionFactory"
  class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
  <property name="dataSource">
   <ref bean="dataSource" />
  </property>
  <property name="hibernateProperties">
   <props>
    <prop key="hibernate.dialect">
     org.hibernate.dialect.MySQLDialect
    </prop>
   </props>
  </property>
  <property name="mappingResources">
   <list>
    <value>com/vo/User.hbm.xml</value></list>
  </property></bean>
 <bean id="UserDAO" class="com.vo.UserDAO">
  <property name="sessionFactory">
   <ref bean="sessionFactory" />
  </property>
 </bean></beans>

Test.java

                   User u =new User();
            u.setName("test123");
            ApplicationContext app=new FileSystemXmlApplicationContext

("src/applicationContext.xml");
            UserDAO dao=(UserDAO) app.getBean("UserDAO");
            dao.save(u);

User.java

public User() {
    }

    private Integer id;
     private String name;
   
    public Integer getId() {
        return this.id;
    }
   
    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return this.name;
    }
   
    public void setName(String name) {
        this.name = name;
    }

UserDao.java
 public void save(User transientInstance) {
      
        try {
            getHibernateTemplate().save(transientInstance);
          
        } catch (RuntimeException re) {
          
            throw re;
        }
    }

本实例运行成功。最后我使用的mysql驱动是:mysql-connector-java-5.1.6-bin.jar 运行时别忘了添加它呀！好了，祝各位好运了。