搭建Springmvc+Mybatis+Spring环境

本文主要讲述了搭建一个最基本的SSM框架流程，实现的功能就是读取数据库中的一张表并显示到jsp页面上
具体步骤如下：
1、在pom.xml文件中添加jetty插件，并测试jetty服务器功能，在jsp页面上显示Hello,world。
2、编写spring和mybatis的整合文件，配置web.xml。

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:javaee="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" id="WebApp_ID" version="2.4">
  <!--contextConfigLocation用做全局变量提供给整个项目使用  -->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:application-context.xml</param-value>
  </context-param>
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <!-- 中文过滤器 -->
  <filter>
    <filter-name>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>
  </filter>
  <filter-mapping>
    <filter-name>encoding</filter-name>
    <url-pattern>*.do</url-pattern>
  </filter-mapping>
  <filter-mapping>
    <filter-name>encoding</filter-name>
    <url-pattern>*.shtml</url-pattern>
  </filter-mapping>
  <servlet>
    <servlet-name>front</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:springmvc-front.xml</param-value>
    </init-param>
  </servlet>
  <servlet-mapping>
    <servlet-name>front</servlet-name>
    <url-pattern>*.shtml</url-pattern>
  </servlet-mapping>
</web-app>

3、在数据库中建立member表并创建Member类，表中包含编号、姓名和手机号，。

4、在MemberDao.xml文件中编写sql语句。

<?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.sohu.core.dao.MemberDao">
    <resultMap id="member" type="member">
        <result property="id" column="id" />
        <result property="name" column="name" />
        <result property="phone" column="phone" />
    </resultMap>
    <!-- Select SQL -->
    <sql id="memberSelector">
        SELECT
            id,name,phone
        FROM member
    </sql>
    <!--查询-->
    <select id="getMemberList" resultMap="member">
        <include refid="memberSelector" />
    </select>
</mapper>

5、编写MemberDao接口。

package com.sohu.core.dao;
import com.sohu.core.bean.Member;
import java.util.List;
public interface MemberDao {
    public List<Member> getMemberList();
}

6、编写MemberService接口。

public interface MemberService {
    public List<Member> getMemberList();
}

7、编写MemberServiceImpl类。

package com.sohu.core.service;
import com.sohu.core.bean.Member;
import com.sohu.core.dao.MemberDao;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import javax.annotation.Resource;
import java.util.List;
/**
 * Created by jinweilu on 2017/7/10.
 */
@Service
@Transactional
public class MemberServiceImpl implements MemberService {
    @Resource
    MemberDao memberDao;
    @Transactional(readOnly = true)
    public List<Member> getMemberList() {
        return memberDao.getMemberList();
    }
}

8、编写MemberController类。

package com.sohu.core.controller;
import com.sohu.core.bean.Member;
import com.sohu.core.service.MemberService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import java.util.List;
/**
 * Created by jinweilu on 2017/7/10.
 */
@Controller
public class MemberController {
    @Autowired
    private MemberService memberService;
    @RequestMapping(value = "/admin/member/list.shtml")
    public String list(ModelMap model) {
        List<Member> members = memberService.getMemberList();
        model.addAttribute("members", members);
        return "admin/member/list";
    }
}

9、编写list.jsp文件

<table cellspacing="1" cellpadding="0" wid<%@ page language="java"  pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn"%>th="100%" border="0" class="pn-ltable">
    <thead class="pn-lthead">
    <tr>
        <td>编号</td>
        <td>姓名</td>
        <td>手机号</td>
    </tr>
    </thead>
    <tbody class="pn-ltbody">
    <c:forEach items="${members}" var="entry">
        <tr bgcolor="#ffffff" onmouseover="this.bgColor='#eeeeee'" onmouseout="this.bgColor='#ffffff'">
            <td>${entry.id }</td>
            <td>${entry.name }</td>
            <td>${entry.phone}</td>
        </tr>
    </c:forEach>
    </tbody>
</table>

10.联合调试。测试的结果如下所示：