spring+struts2+hibernate+mybatis

比眉伴天荒 2022-09-24 06:21 144阅读 0赞

配置文件：  
pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <groupId>com.ming</groupId>
        <artifactId>sshm</artifactId>
        <packaging>war</packaging>
        <version>1.0-SNAPSHOT</version>
        <name>sshm Maven Webapp</name>
        <url>http://maven.apache.org</url>
        <dependencies>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.11</version>
                <scope>test</scope>
            </dependency>
    
            
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-api</artifactId>
                <version>1.7.7</version>
            </dependency>
            <dependency>
                <groupId>ch.qos.logback</groupId>
                <artifactId>logback-core</artifactId>
                <version>1.1.1</version>
            </dependency>
            
            <dependency>
                <groupId>ch.qos.logback</groupId>
                <artifactId>logback-classic</artifactId>
                <version>1.1.1</version>
            </dependency>
    
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.36</version>
            </dependency>
            <dependency>
                <groupId>c3p0</groupId>
                <artifactId>c3p0</artifactId>
                <version>0.9.1.2</version>
            </dependency>
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.3.0</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>1.2.2</version>
            </dependency>
            
            <dependency>
                <groupId>org.hibernate</groupId>
                <artifactId>hibernate-core</artifactId>
                <version>4.3.5.Final</version>
            </dependency>
            <dependency>
                <groupId>org.hibernate</groupId>
                <artifactId>hibernate-entitymanager</artifactId>
                <version>4.3.5.Final</version>
            </dependency>
            <dependency>
                <groupId>org.hibernate</groupId>
                <artifactId>hibernate-annotations</artifactId>
                <version>3.5.4-Final</version>
            </dependency>
    
    
            
            <dependency>
                <groupId>taglibs</groupId>
                <artifactId>standard</artifactId>
                <version>1.1.2</version>
            </dependency>
            <dependency>
                <groupId>jstl</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-databind</artifactId>
                <version>2.5.4</version>
            </dependency>
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>javax.servlet-api</artifactId>
                <version>3.1.0</version>
            </dependency>
    
            
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-core</artifactId>
                <version>4.2.6.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-beans</artifactId>
                <version>4.1.7.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>4.1.7.RELEASE</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>4.1.7.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-tx</artifactId>
                <version>4.1.7.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-orm</artifactId>
                <version>4.1.7.RELEASE</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-web</artifactId>
                <version>4.1.7.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>4.1.7.RELEASE</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-test</artifactId>
                <version>4.0.2.RELEASE</version>
            </dependency>
        </dependencies>
        <build>
            <finalName>sshm</finalName>
        </build>
    </project>

hibernate-config.xml

<?xml version='1.0' encoding='utf-8'?>
    <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
    <hibernate-configuration>
        
        <session-factory>
    
            
            <property name="dialect">
                org.hibernate.dialect.MySQLDialect
            </property>
    
            
            <property name="hbm2ddl.auto">update</property>
            
            <property name="show_sql">true</property>
            <property name="connection.pool_size">1</property>
            <property name="hibernate.current_session_context_class">thread</property>
    
        </session-factory>
    </hibernate-configuration>

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
        
    <settings>
        
        <setting name="useGeneratedKeys" value="true"/>
        
        <setting name="useColumnLabel" value="true"/>
        
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>
    
    </configuration>

logback.xml

<?xml version="1.0"?>
    <configuration>
    
        
        <appender name="console" class="ch.qos.logback.core.ConsoleAppender">
            <encoder>
                <pattern>[%-5level] %d{HH:mm:ss.SSS} [%thread] %logger{36} - %msg%n</pattern>
            </encoder>
        </appender>
    
        
        <root>
            <level value="debug" />
            <appender-ref ref="console" />
        </root>
    
    </configuration>

jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://127.0.0.1:3306/student?useUnicode=true&characterEncoding=utf8
    jdbc.username=root
    jdbc.password=

spring配置：  
spring-dao.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" 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">
        
        
        <context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
        
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="driverClass" value="${jdbc.driver}"/>
            <property name="jdbcUrl" value="${jdbc.url}"/>
            <property name="user" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
    
            
            <property name="maxPoolSize" value="30"/>
            <property name="minPoolSize" value="10"/>
            
            <property name="autoCommitOnClose" value="false"/>
            
            <property name="checkoutTimeout" value="1000"/>
            
            <property name="acquireRetryAttempts" value="2"/>
        </bean>
    
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"/>
            
            <property name="configLocation" value="classpath:mybatis-config.xml"/>
            
            <property name="typeAliasesPackage" value="com.ming.entity"/>
            
            <property name="mapperLocations" value="classpath:mapper/*.xml"/>
        </bean>
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
            
            <property name="basePackage" value="com.ming.dao"/>
        </bean>
    
        
        <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"></property>
            
            <property name="configLocation" value="classpath:hibernate-config.xml"></property>
            <property name="packagesToScan">
                <list>
                    <value>com.ming.entity</value>
                </list>
            </property>
    
        </bean>
    </beans>

spring-service.xml

spring-web.xml

mapper：  
sql.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.ming.dao.UserDao">
        <select id="getAll" resultType="User">
    SELECT *
    FROM USER
    ORDER  BY userId DESC
    limit #{page.itemStart},#{page.pageSize}
    
        </select>
    
    </mapper>

web.xml  
springmvc或者struts2 还没有整合进去

<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd" >
    
    <web-app>
      <display-name>Archetype Created Web Application</display-name>
    </web-app>

java代码  
BaseDao.java

package com.ming.dao;
    
    
    import java.util.List;
    
    import org.hibernate.Query;
    import org.hibernate.Session;
    
    
    import com.ming.util.Page;
    import org.hibernate.SessionFactory;
    import org.springframework.stereotype.Repository;
    
    import javax.annotation.Resource;
    
    public class BaseDao<T> {
    
        private SessionFactory sessionFactory;
        private Session session = null;
    
    
        private Class<T> clazz;
    
        public BaseDao(Class<T> clazz, SessionFactory sessionFactory) {
            this.clazz = clazz;
            this.sessionFactory = sessionFactory;
            session = sessionFactory.openSession();
        }
    
        public void save(T t) {
            session.save(t);
        }
    
        public void delete(T t) {
            session.delete(t);
        }
    
        public void delete(int id) {
            session.delete(getById(id));
        }
    
        public void update(T t) {
            session.update(t);
        }
    
        public T getById(int id) {
            return (T) session.get(clazz, id);
        }
    
        public List<T> getAll(final Page page) {
            Query query = session.createQuery("from " + clazz.getSimpleName());
            query.setMaxResults(page.getPageSize());
            query.setFirstResult(page.getItemStart());
            return query.list();
        }
    
        //条件分页
        @SuppressWarnings("unchecked")
        public List<T> search(final String hql, final List<Object> params, final Page page) {
    
            // 先统计有多少条数据
            //hql from XXX
            String countHql = "";
            if (hql.indexOf("order") != -1) {
                countHql = hql.substring(0, hql.indexOf("order"));
            }
    
            countHql = "select count(*) " + countHql;
    
            Query countquery = session.createQuery(countHql);
    
            // 设置参数
            for (int i = 0; i < params.size(); i++) {
                countquery.setParameter(i, params.get(i));
            }
    
            // uniqueResult 必须Long
            Long a = (Long) countquery.uniqueResult();
            page.setItmeCount(a.intValue());
    
    
            Query query = session.createQuery(hql);
            // 设置参数
            for (int i = 0; i < params.size(); i++) {
                query.setParameter(i, params.get(i));
            }
    
            // 分页
            query.setFirstResult(page.getItemStart());
            query.setMaxResults(page.getPageSize());
    
            return query.list();
        }
    
    
    }

UserDao.java

package com.ming.dao;
    
    import com.ming.entity.User;
    import com.ming.util.Page;
    import org.apache.ibatis.annotations.Param;
    import org.apache.ibatis.annotations.Select;
    import org.springframework.stereotype.Repository;
    
    import java.util.List;
    
    /** * Created by ming on 2016/7/14. */
    public interface UserDao { 
        @Select("select * from user where userId=#{userId}")
        public User getById(int userId);
        public List<User> getAll(@Param("page") Page page);
    
    }

User.java

package com.ming.entity;
    
    import javax.persistence.*;
    
    /** * Created by ming on 2016/7/14. */
    @Entity
    @Table(name="user")
    public class User { 
        private int userId;
        private String userName;
        private String passWord;
        @Id
        @GeneratedValue
        public int getUserId() {
            return userId;
        }
    
        public void setUserId(int userId) {
            this.userId = userId;
        }
    @Column(name = "userName")
        public String getUserName() {
            return userName;
        }
    
        public void setUserName(String userName) {
            this.userName = userName;
        }
    @Column(name = "passWord")
        public String getPassWord() {
            return passWord;
        }
    
        public void setPassWord(String passWord) {
            this.passWord = passWord;
        }
    
        @Override
        public String toString() {
            return "User{" +
                    "userId=" + userId +
                    ", userName='" + userName + '\'' +
                    ", passWord='" + passWord + '\'' +
                    '}';
        }
    }

Page.java

package com.ming.util;
    
    import java.io.Serializable;
    
    /** * 分页信息对象 * @author Administrator * */
    public class Page implements Serializable{ 
    
        private int itmeCount;//总数
        private int pageCount;//总页数
        private int pageSize;//每页显示数量
        private int currentPage;//当前页
        private int itemStart;//开始位
        private int itemEnd;//结束位
    
    
        public Page(){
            pageSize=10;
            currentPage=1;
        }
    
        public int getItmeCount() {
            return itmeCount;
        }
        public void setItmeCount(int itmeCount) {
            this.itmeCount = itmeCount;
        }
        public int getPageSize() {
            return pageSize;
        }
        public void setPageSize(int pageSize) {
            this.pageSize = pageSize;
        }
        public int getCurrentPage() {
            if(currentPage<1){
                currentPage=1;
            }
            return currentPage;
        }
        public void setCurrentPage(int currentPage) {
            this.currentPage = currentPage;
        }
        /** * 总页数 * @return */
        public int getPageCount() {
            //99 10 100/10 总条数/每页的数量
            return itmeCount%pageSize==0?itmeCount/pageSize:(itmeCount/pageSize+1);
        }
        public int getItemStart() {
            return (getCurrentPage() - 1) * pageSize;
        }
        public int getItemEnd() {
            return getItemStart()+pageSize;
        }
    
    
    
    
    }

demo地址：  
[http://download.csdn.net/detail/qq\_16055765/9587374][http_download.csdn.net_detail_qq_16055765_9587374]

[http_download.csdn.net_detail_qq_16055765_9587374]: http://download.csdn.net/detail/qq_16055765/9587374