Spring + Springmvc + myBatis 简单实例

最新推荐文章于 2024-08-05 23:09:45 发布

csdn_wwp

最新推荐文章于 2024-08-05 23:09:45 发布

阅读量629

点赞数

分类专栏： java Spring 框架搭建文章标签： spring

本文链接：https://blog.csdn.net/wwp231/article/details/51059371

版权

java Spring 框架搭建专栏收录该内容

4 篇文章 0 订阅

订阅专栏

Spring + Springmvc + myBatis 简单实例

1，首先配置 web.xml 文件

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
    http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
    <!-- 启动 Spring 容器的监听器 -->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

    <!-- 业务 bean 的 Spring 配置文件 -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>

    <!-- Spring Mvc 核心控制器 -->
    <servlet>
        <servlet-name>springmvc</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:springmvc-servlet.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>springmvc</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

    <!--日志路径-->
    <context-param>
        <param-name>log4jConfigLocation</param-name>
        <param-value>classpath:log4j.properties</param-value>
    </context-param>

    <!--日志监听器-->
    <listener>
        <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
    </listener>

<!--打开session ，使getCurrentSession() 有效-->
    <filter>
        <filter-name>OpenSessionInViewFilter</filter-name>
        <filter-class>
            org.springframework.orm.hibernate3.support.OpenSessionInViewFilter
        </filter-class>
        <init-param>
            <param-name>sessionFactoryBeanName</param-name>
            <param-value>sessionFactory</param-value>
        </init-param>
        <init-param>
            <param-name>singleSession</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>OpenSessionInViewFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <!-- springmvc post请求中文乱码处理 -->
    <filter>
        <filter-name>Character Encoding</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
        <init-param>  
            <param-name>forceEncoding</param-name>  
            <param-value>true</param-value>  
        </init-param>  
    </filter>
    <filter-mapping>
        <filter-name>Character Encoding</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

</web-app>

分别配置了，spring 监听器，spring 配置文件，springmvc 核心控制器 以及post 请求时防中文乱码的过滤器；,

2，spring 配置文件

<?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">

    <!-- JDBC 连接 properties 文件 -->
    <context:property-placeholder location="classpath:jdbc.properties" />

    <!-- 依赖注入扫描范围 -->
    <context:component-scan base-package="myBatis.biz" />
    <context:component-scan base-package="myBatis.dao" />

    <!-- 配置 dbcp 数据源 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName" value="${jdbc.driver}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
        <!-- 初始化连接大小 -->
        <property name="initialSize" value="0"></property>
        <!-- 连接池最大数量 -->
        <property name="maxActive" value="20"></property>
        <!-- 连接池最大空闲 -->
        <property name="maxIdle" value="20"></property>
        <!-- 连接池最小空闲 -->
        <property name="minIdle" value="1"></property>
        <!-- 获取连接最大等待时间 -->
        <property name="maxWait" value="60000"></property>
    </bean>

    <!-- 配置 MyBatis 的 SessionFactory -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="mapperLocations" value="classpath:mapper/*.xml" />
        <property name="typeAliasesPackage" value="myBatis.entity" />
    </bean>

    <!-- 扫描 DAO 接口所在包名，Spring 会自动代理生成其下的接口实现类 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="myBatis.dao" />
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
    </bean>
</beans>

3，然后配置springmvc-servlet.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:mvc="http://www.springframework.org/schema/mvc"
    xsi:schemaLocation="http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
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">

    <!-- 申明注解驱动 -->
    <mvc:annotation-driven />

    <!-- springmvc 异步请求乱码处理 -->
    <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" >
        <property name="messageConverters">
            <list>
                <bean class = "org.springframework.http.converter.StringHttpMessageConverter">
                    <property name = "supportedMediaTypes">
                        <list>
                            <value>text/html;charset=UTF-8</value>
                            <value>text/plain;charset=UTF-8</value>
                        </list>
                    </property>
                </bean>
            </list>
        </property>
    </bean>

    <!-- mvc 注解扫描范围 -->
    <context:component-scan base-package="myBatis.controller" />

    <!-- 配置静态资源位置 -->
    <mvc:resources mapping="/css/**" location="/css/" />
    <mvc:resources mapping="/js/**" location="/js/" />
    <mvc:resources mapping="/images/**" location="/images/" />

    <!-- 配置视图解析器 -->
    <bean
        class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="viewClass"
            value="org.springframework.web.servlet.view.JstlView" />
        <property name="prefix" value="/" />
        <property name="suffix" value=".jsp" />
    </bean>
</beans>

其中已经做了异步请求 中文乱码处理 和静态资源位置配置 ；

4，需要加载的 jar 包的 maven 地址如下：

<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/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>maven</groupId>
    <artifactId>myBatis</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>war</packaging>

    <properties>
        <!-- 定义 Spring 的版本号 -->
        <springframework.version>3.2.4.RELEASE</springframework.version>
    </properties>

    <dependencies>
        <!-- jstl 依赖，jsp 页面中使用 JSTL 标签 -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
        <!-- servlet aip 依赖，jsp/servlet 核心对象的支持 -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
            <scope>provided</scope> <!-- 部署时由容器（Tomcat）提供 -->
        </dependency>
        <!-- Oracle 数据库的 JDBC 驱动，商业组件，非开源，需要自己注册到 maven 仓库 -->
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc14</artifactId>
            <version>10.2.0.4.0</version>
        </dependency>
        <!-- dbcp 数据源（连接池） ，必须 -->
        <dependency>
            <groupId>commons-dbcp</groupId>
            <artifactId>commons-dbcp</artifactId>
            <version>1.2.2</version>
        </dependency>
        <!-- MyBatis 核心，必须 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.2.5</version>
        </dependency>
        <!-- MyBatis 与 Spring 整合包 ，必须，整合 Spring 的关键 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.2.1</version>
        </dependency>
        <!-- Spring 核心包，必须 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${springframework.version}</version>
        </dependency>
        <!-- Spring ORM，必须 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</artifactId>
            <version>${springframework.version}</version>
        </dependency>
        <!-- Spring 切面， 用于配置事务切面， 若使用注解配置事务， 不需要切面的依赖 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aspects</artifactId>
            <version>${springframework.version}</version>
        </dependency>
        <!-- Spring Web, 启动 Spring 容器所需的监听器 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>${springframework.version}</version>
        </dependency>
        <!-- Spring MVC -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>${springframework.version}</version>
        </dependency>
        <!-- json 支持 -->
        <dependency>
            <groupId>net.sf.json-lib</groupId>
            <artifactId>json-lib-ext-spring</artifactId>
            <version>1.0.2</version>
        </dependency>


        <!-- Spring 测试，可选，仅用于单元测试 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>${springframework.version}</version>
        </dependency>
        <!-- Junit 测试，可选，仅用于单元测试 -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
        </dependency>
    </dependencies>
</project>

5，其中一个 mapper.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="myBatis.dao.MovieDao">
    <resultMap type="myBatis.entity.Movie" id="movieResultMap">
        <id column="id" property="id"/>
        <result column="movieCode" property="movieCode"/>
        <result column="title" property="title"/>
        <result column="director" property="director"/>
        <result column="dateReleased" property="dateReleased"/>
        <result column="categoryName" property="categoryName"/>
    </resultMap>

    <select id="fetchById" parameterType="int" resultMap="movieResultMap" >
        select m.*,c.name categoryName 
            from movie m left outer join category c 
            on m.categoryId = c.id 
        where m.id = #{id}
    </select>
    <select id="getAllMovies" resultMap="movieResultMap" >
        select m.*,c.name categoryName 
            from movie m left join category c
            on m.categoryId = c.id
        order by m.id desc
    </select>
    <select id="getPageMovies" parameterType="hashmap" resultMap="movieResultMap" >
        select * from (
            select m.*,c.name categoryName,rowNum rn
                from movie m left join category c
                on m.categoryId = c.id
                where 1 = 1
                <if test="title != null">
                    and m.title like '%' || #{title} || '%' 
                </if>
                <if test="id != 0">
                    and m.categoryId = #{id}
                </if>
        ) 
        where rn &gt; (#{pageNum}-1)*#{pageSize} and rn &lt;= #{pageNum}*#{pageSize}
    </select>
    <select id="getCount" parameterType="hashmap" resultType="int">
        select count(*) from (
            select m.*,c.name categoryName,rowNum rn
                from movie m left join category c
                on m.categoryId = c.id
                where 1 = 1
                <if test="title != null ">
                    and m.title like '%' || #{title} || '%' 
                </if>
                <if test="id != 0">
                    and m.categoryId = #{id}
                </if>
        ) 
    </select>

</mapper>

6,控制器内容：

package myBatis.controller;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import myBatis.biz.MovieBiz;
import myBatis.entity.Movie;
import net.sf.json.spring.web.servlet.view.JsonView;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

@Controller("movieController")
@Scope("prototype")
@RequestMapping("movie")
public class MovieController {
    @Autowired
    private MovieBiz movieBiz;

    /**
     * 电影列表
     */
    @RequestMapping(value="movies.do")
    public ModelAndView movies(int pageNum, int pageSize, String title, int id){
        Map<String, Object> json = new HashMap<String, Object>();
        if(pageNum == 0 ){
            pageNum = 1;
        }
        if(pageSize == 0){
            pageSize = 5; 
        }
        if(title == null )
            title = "";
        List<Movie> movies = movieBiz.getPageMovies(pageNum, pageSize, title,id);
        int count = movieBiz.getCount(pageNum, pageSize, title, id);
        int totalPage = count%pageSize==0?count/pageSize:(count/pageSize+1);
        json.put("movies", movies);
        json.put("totalPage", totalPage);
        json.put("pageNum", pageNum);
        json.put("pageSize", pageSize);
        json.put("title", title);
        json.put("cid", id);
        return new ModelAndView(new JsonView(), json);
    }

}

7，js 的内容为：

/**
 * 
 */
$(function(){
    //显示电影分类列表
    viewCategories();
    //显示电影列表
    viewMovies(0,0,"",0);


});

//显示电影分类列表
function viewCategories(){
    $.ajax({
        url:"../category/list.do",
        type:"post",
        success:function(json){
            var movieHtml = "";
            $.each(json.categories, function(i, c){
                movieHtml += "<li ><a onclick='viewMovies("+0+","+0+",\"\","+c.id+")'>"+c.name+"<a></li>";
            });
            $("#categories").html(movieHtml);
        }
    });
}

//显示电影列表
function viewMovies(pageNum, pageSize, title, id){
    var data = {"pageNum":pageNum, "pageSize":pageSize, "title":title, "id":id };
    $.ajax({
        url:"../movie/movies.do",
        type:"post",
        data:data,
        success:function(json){
            var html="";
            $.each(json.movies, function(index, m){
                html += "<tr><td>"+m.id+"</td>" +
                        "<td>"+m.title+"</td>" +
                        "<td>"+m.director+"</td>" +
                        "<td>"+m.categoryName+"</td></tr>";
            });
            $("#movies").html(html);

            //分页标签
            var pageHtml = "<ul class='pagination'>";
            if(json.pageNum <=1 ){
                pageHtml += "<li class='disabled'><span>&laquo; </span></li>";
            } else {
                pageHtml += "<li ><span onclick='viewMovies("+(json.pageNum-1)+","+json.pageSize+",\""+json.title+"\","+json.cid+")'>&laquo; </span></li>";
            }
            for(var i=1; i<=json.totalPage; i++){
                if(i<8){
                    if(i == json.pageNum){
                        pageHtml += "<li class='active'><a href='' >"+i+"</a></li>";
                    } else {
                        /*pageHtml += "<li><span onclick=\"viewMovies("+i+","+json.pageSize+",\'"+json.title+"\',"+json.cid+")\">"+ i +"</span></li>";*/
                        pageHtml += "<li><span onclick='viewMovies("+i+","+json.pageSize+",\""+json.title+"\","+json.cid+")'>"+ i +"</span></li>";
                    }
                } else{
                    pageHtml += "<li><a href='' >....</a></li>";
                    break;
                }
            }
            if(json.pageNum >= json.totalPage ){
                pageHtml += "<li class='disabled'><span>&raquo; </span></li>";
            } else {
                pageHtml += "<li ><span onclick='viewMovies("+(json.pageNum+1)+","+json.pageSize+",\""+json.title+"\","+json.cid+")'>&raquo; </span></li>";
            }

            pageHtml += "</ul>";
            $("#moviePage").html(pageHtml);
        }
    });
}