本文主要讲述了搭建一个最基本的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.联合调试。测试的结果如下所示: