• SSH整合之spring整合hibernate


    SSH整合要导入的jar包:

    MySQL中创建数据库

    create database ssh_db;
    ssh_db

    一、spring整合hibernate带有配置文件hibernate.cfg.xml

    1、项目结构:

    2、新建接口UserDao及实现类UserDaoImpl;实现类中有HibernateTemplate 字段及setter方法,是用来执行数据库操作的。  

    package com.hjp.dao;
    
    import com.hjp.domain.User;
    
    /**
     * Created by JiaPeng on 2015/11/21.
     */
    public interface UserDao {
        void save(User user);
    }
    接口UserDao
    package com.hjp.dao.impl;
    
    import com.hjp.dao.UserDao;
    import com.hjp.domain.User;
    import org.hibernate.HibernateException;
    import org.hibernate.Session;
    import org.springframework.orm.hibernate3.HibernateCallback;
    import org.springframework.orm.hibernate3.HibernateTemplate;
    
    import java.sql.SQLException;
    
    /**
     * Created by JiaPeng on 2015/11/21.
     */
    public class UserDaoImpl implements UserDao {
    
        HibernateTemplate hibernateTemplate;
    
        public void setHibernateTemplate(HibernateTemplate hibernateTemplate) {
            this.hibernateTemplate = hibernateTemplate;
        }
    
        @Override
        public void save(User user) {
            this.hibernateTemplate.save(user);
        }
    }
    UserDao实现类UserDaoImpl

     3、新建接口UserService及实现类UserServiceImpl;实现类中有UserDao字段级setter方法,调用userDao中的公共方法

    package com.hjp.service;
    
    import com.hjp.domain.User;
    
    /**
     * Created by JiaPeng on 2015/11/21.
     */
    public interface UserService {
        void register(User user);
    }
    接口UserService
    package com.hjp.service.impl;
    
    import com.hjp.dao.UserDao;
    import com.hjp.domain.User;
    import com.hjp.service.UserService;
    
    /**
     * Created by JiaPeng on 2015/11/21.
     */
    public class UserServiceImpl implements UserService {
    
        private UserDao userDao;
    
        public void setUserDao(UserDao userDao) {
            this.userDao = userDao;
        }
    
        @Override
        public void register(User user) {
            this.userDao.save(user);
        }
    }
    UserService实现类UserServiceImpl

    4、新建hibernate.cfg.xml文件

    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE hibernate-configuration PUBLIC
            "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
            "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
    <hibernate-configuration>
        <session-factory>
            <!--基本四项-->
            <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
            <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/ssh_db</property>
            <property name="hibernate.connection.username">root</property>
            <property name="hibernate.connection.password">hjp123</property>
            <!--方言-->
            <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
            <!--sql优化,显示,格式化-->
            <property name="hibernate.show_sql">true</property>
            <property name="hibernate.format_sql">true</property>
            <!--自动创建表-->
            <property name="hibernate.hbm2ddl.auto">update</property>
            <!--整合C3P0-->
            <property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
            <!--添加映射文件-->
            <mapping resource="com/hjp/domain/User.hbm.xml"></mapping>
        </session-factory>
    </hibernate-configuration>
    hibernate.cfg.xml

    5、新建applicationContext.xml文件

    <?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:aop="http://www.springframework.org/schema/aop"
           xmlns:tx="http://www.springframework.org/schema/tx"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
                               http://www.springframework.org/schema/beans/spring-beans.xsd
                               http://www.springframework.org/schema/context
                               http://www.springframework.org/schema/context/spring-context.xsd
                               http://www.springframework.org/schema/aop
                               http://www.springframework.org/schema/aop/spring-aop.xsd
                               http://www.springframework.org/schema/tx
                               http://www.springframework.org/schema/tx/spring-tx.xsd">
        <!--获得sessionFactory,spring加载hibernate.cfg.xml文件-->
        <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
            <property name="configLocation" value="classpath:hibernate.cfg.xml"></property>
        </bean>
        <!--hibernateTemplate模板-->
        <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
            <property name="sessionFactory" ref="sessionFactory"></property>
        </bean>
        <!--dao-->
        <bean id="userDao" class="com.hjp.dao.impl.UserDaoImpl">
            <property name="hibernateTemplate" ref="hibernateTemplate"></property>
        </bean>
        <!--service-->
        <bean id="userService" class="com.hjp.service.impl.UserServiceImpl">
           <property name="userDao" ref="userDao"></property>
        </bean>
        <!--事务管理,首先有事务管理器-->
        <bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
            <property name="sessionFactory" ref="sessionFactory"></property>
        </bean>
        <!--事务通知-->
        <tx:advice id="txAdvice" transaction-manager="txManager">
            <tx:attributes>
                <tx:method name="register"/>
            </tx:attributes>
        </tx:advice>
        <!--aop配置-->
        <aop:config>
            <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.hjp.service..*.*(..))"></aop:advisor>
        </aop:config>
    </beans>
    applicationContext

    6、新建测试类TestApp

    package com.hjp.test;
    
    import com.hjp.domain.User;
    import com.hjp.service.UserService;
    import org.junit.Test;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    /**
     * Created by JiaPeng on 2015/11/21.
     */
    public class TestApp {
        @Test
        public void demo1() {
            User user=new User();
            user.setUsername("Jack");
            user.setPassword("123");
            String xmlPath = "applicationContext.xml";
            ApplicationContext applicationContext= (ApplicationContext) new ClassPathXmlApplicationContext(xmlPath);
            UserService userService= (UserService) applicationContext.getBean("userService");
            userService.register(user);
        }
    }
    TestApp

     二、spring整合hibernate,没有hibernate.cfg.xml配置文件

    从含有hibernate.cfg.xml配置文件中项目进行删改

    1、删除hibernate.cfg.xml配置文件,修改applicationContext.xml文件

    <?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:aop="http://www.springframework.org/schema/aop"
           xmlns:tx="http://www.springframework.org/schema/tx"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
                               http://www.springframework.org/schema/beans/spring-beans.xsd
                               http://www.springframework.org/schema/context
                               http://www.springframework.org/schema/context/spring-context.xsd
                               http://www.springframework.org/schema/aop
                               http://www.springframework.org/schema/aop/spring-aop.xsd
                               http://www.springframework.org/schema/tx
                               http://www.springframework.org/schema/tx/spring-tx.xsd">
        <!--配置数据源-->
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
            <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/ssh_db"></property>
            <property name="user" value="root"></property>
            <property name="password" value="hjp123"></property>
        </bean>
        <!--获得sessionFactory,spring不再加载hibernate.cfg.xml文件-->
        <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
            <!--注入数据源-->
            <property name="dataSource" ref="dataSource"></property>
            <!--其他属性设置-->
            <property name="hibernateProperties">
                <props>
                    <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
                    <prop key="hibernate.show_sql">true</prop>
                    <prop key="hibernate.format_sql">true</prop>
                    <prop key="hibernate.hbm2ddl.auto">update</prop>
                </props>
            </property>
            <!--添加映射文件,一般用mappingLocations
                mappingResources 加载映射文件,从src下获取,必须确定指定资源 com/hjp/domain/User.hbm.xml
                mappingLocations 建议带着"classpath:",可用通配符
                    classpath:com/hjp/*/User.hbm.xml 代表目录任意
                    classpath:com/hjp/domain/*.hbm.xml 代表文件名任意
                mappingDirectoryLocations 设置目录 classpath:com/hjp/domain
                mappingJarLocations 从jar中获得配置文件
            -->
            <property name="mappingLocations" value="classpath:com/hjp/domain/User.hbm.xml"></property>
        </bean>
        <!--hibernateTemplate模板-->
        <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
            <property name="sessionFactory" ref="sessionFactory"></property>
        </bean>
        <!--dao-->
        <bean id="userDao" class="com.hjp.dao.impl.UserDaoImpl">
            <property name="hibernateTemplate" ref="hibernateTemplate"></property>
        </bean>
        <!--service-->
        <bean id="userService" class="com.hjp.service.impl.UserServiceImpl">
           <property name="userDao" ref="userDao"></property>
        </bean>
        <!--事务管理,首先有事务管理器-->
        <bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
            <property name="sessionFactory" ref="sessionFactory"></property>
        </bean>
        <!--事务通知-->
        <tx:advice id="txAdvice" transaction-manager="txManager">
            <tx:attributes>
                <tx:method name="register"/>
            </tx:attributes>
        </tx:advice>
        <!--aop配置-->
        <aop:config>
            <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.hjp.service..*.*(..))"></aop:advisor>
        </aop:config>
    </beans>
    applicationContext.xml

    2、删除hibernate模板,修改applicationContext.xml文件及使UserDao继承HibernateDaoSupport类

    package com.hjp.dao.impl;
    
    import com.hjp.dao.UserDao;
    import com.hjp.domain.User;
    import org.hibernate.HibernateException;
    import org.hibernate.Session;
    import org.springframework.orm.hibernate3.HibernateCallback;
    import org.springframework.orm.hibernate3.HibernateTemplate;
    import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
    
    import java.sql.SQLException;
    
    /**
     * Created by JiaPeng on 2015/11/21.
     */
    public class UserDaoImpl extends HibernateDaoSupport implements UserDao {
    
    //    HibernateTemplate hibernateTemplate;
    //
    //    public void setHibernateTemplate(HibernateTemplate hibernateTemplate) {
    //        this.hibernateTemplate = hibernateTemplate;
    //    }
    
        @Override
        public void save(User user) {
            this.getHibernateTemplate().save(user);
        }
    }
    UserDaoImpl
    <?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:aop="http://www.springframework.org/schema/aop"
           xmlns:tx="http://www.springframework.org/schema/tx"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
                               http://www.springframework.org/schema/beans/spring-beans.xsd
                               http://www.springframework.org/schema/context
                               http://www.springframework.org/schema/context/spring-context.xsd
                               http://www.springframework.org/schema/aop
                               http://www.springframework.org/schema/aop/spring-aop.xsd
                               http://www.springframework.org/schema/tx
                               http://www.springframework.org/schema/tx/spring-tx.xsd">
        <!--配置数据源-->
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
            <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/ssh_db"></property>
            <property name="user" value="root"></property>
            <property name="password" value="hjp123"></property>
        </bean>
        <!--获得sessionFactory,spring不再加载hibernate.cfg.xml文件-->
        <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
            <!--注入数据源-->
            <property name="dataSource" ref="dataSource"></property>
            <!--其他属性设置-->
            <property name="hibernateProperties">
                <props>
                    <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
                    <prop key="hibernate.show_sql">true</prop>
                    <prop key="hibernate.format_sql">true</prop>
                    <prop key="hibernate.hbm2ddl.auto">update</prop>
                </props>
            </property>
            <!--添加映射文件,一般用mappingLocations
                mappingResources 加载映射文件,从src下获取,必须确定指定资源 com/hjp/domain/User.hbm.xml
                mappingLocations 建议带着"classpath:",可用通配符
                    classpath:com/hjp/*/User.hbm.xml 代表目录任意
                    classpath:com/hjp/domain/*.hbm.xml 代表文件名任意
                mappingDirectoryLocations 设置目录 classpath:com/hjp/domain
                mappingJarLocations 从jar中获得配置文件
            -->
            <property name="mappingLocations" value="classpath:com/hjp/domain/User.hbm.xml"></property>
        </bean>
        <!--hibernateTemplate模板
        <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
            <property name="sessionFactory" ref="sessionFactory"></property>
        </bean>-->
        <!--dao
            UserDaoImpl继承了HibernateDaoSupport类,所以只注入sessionFactory即可,在UserDaoImpl实现类
            中可以通过getHibernateTemplate()方法得到hibernate模板对象
        -->
        <bean id="userDao" class="com.hjp.dao.impl.UserDaoImpl">
            <property name="sessionFactory" ref="sessionFactory"></property>
        </bean>
        <!--service-->
        <bean id="userService" class="com.hjp.service.impl.UserServiceImpl">
           <property name="userDao" ref="userDao"></property>
        </bean>
        <!--事务管理,首先有事务管理器-->
        <bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
            <property name="sessionFactory" ref="sessionFactory"></property>
        </bean>
        <!--事务通知-->
        <tx:advice id="txAdvice" transaction-manager="txManager">
            <tx:attributes>
                <tx:method name="register"/>
            </tx:attributes>
        </tx:advice>
        <!--aop配置-->
        <aop:config>
            <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.hjp.service..*.*(..))"></aop:advisor>
        </aop:config>
    </beans>
    applicationContext.xml

     补充

    package com.hjp.domain;
    
    /**
     * Created by JiaPeng on 2015/11/21.
     */
    public class User {
        private Integer id;
        private String username;
        private String password;
        private Integer age;
    
        public Integer getId() {
            return id;
        }
    
        public void setId(Integer id) {
            this.id = id;
        }
    
        public String getUsername() {
            return username;
        }
    
        public void setUsername(String username) {
            this.username = username;
        }
    
        public String getPassword() {
            return password;
        }
    
        public void setPassword(String password) {
            this.password = password;
        }
    
        public Integer getAge() {
            return age;
        }
    
        public void setAge(Integer age) {
            this.age = age;
        }
    }
    User
    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE hibernate-mapping PUBLIC
            "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
            "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
    <hibernate-mapping>
        <class name="com.hjp.domain.User" table="t_user">
            <id name="id">
                <generator class="native"/>
            </id>
            <property name="username" length="50"/>
            <property name="password" length="32"/>
            <property name="age"/>
        </class>
    </hibernate-mapping>
    View Code
  • 相关阅读:
    电路中的VCC和VDD
    动态数码管 什么是位选 段选
    pytest文档62-内置fixture之request
    pytest文档61-fixture之name参数使用别名
    pytest文档60-pytest.main()的使用
    python笔记49-yaml文件中变量的使用(锚点& 与 引用*)
    python笔记48-面试题:m1={'a':1,'b':2,'c':1} 将同样的value的key集合在list里,输出{1:['a','c'],2:['b']}
    jenkins学习15-Allure报告不用登陆也能给领导看
    python接口自动化35-pyppeteer-install下载没反应,r.html.render() 下载无反应问题解决
    kvm内存优化--KSM
  • 原文地址:https://www.cnblogs.com/hujiapeng/p/4984276.html
Copyright © 2020-2023  润新知