mapper.java

package com.elin4it.ssm.mapper;

import com.elin4it.ssm.pojo.User;
import java.util.List;

public interface UserMapper {
    //查询用户列表
    List
   
     findUser() throws Exception; }
   

mapper.xml

   


    
     select id, username, birthday, sex, address from user  
   

创建service接口和实现

创建一个service接口，添加一个方法，用来查询所用用户
UserService.java

package com.elin4it.ssm.service;

import com.elin4it.ssm.pojo.User;

import java.util.List;

/**
 * Created by elin on 15-7-1.
 */
public interface UserService {
    List
   
     findUser()throws Exception; } 
   

添加UserService的实现类UserServiceImpl.java

package com.elin4it.ssm.service;

import com.elin4it.ssm.mapper.UserMapper;
import com.elin4it.ssm.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * Description: UserServiceImpl
 * Author: Elin Zhou
 * Create: 2015-07-01 20:59
 */
@Service
public class UserServiceImpl implements UserService {

    //自动注入mapper接口
    @Autowired
    private UserMapper userMapper;


    @Override
    public List
   
     findUser() throws Exception { //调用mapper接口中的方法，获取用户列表 List
    
      users = userMapper.findUser(); return users; } } 
    
   

创建controller

创建后端控制器，前端控制器根据用户请求映射到后端控制器中的方法，并且返回视图和数据来渲染视图

package com.elin4it.ssm.controller;

import com.elin4it.ssm.pojo.User;
import com.elin4it.ssm.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

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

/**
 * Description: UserController
 * Author: Elin Zhou
 * Create: 2015-07-01 19:30
 */
@Controller
@RequestMapping(/user)
public class UserController {
    //自动注入service   
    @Autowired
    private UserService userService;

    @RequestMapping(/findUser)
    public String findUser(Map
   
     map) throws Exception{ //调用service中的查询用户列表方法来获取用户列表 List
    
      users = userService.findUser(); //把用户列表放到形参传入的map中，相当于执行request.addAttribute()方法 map.put(users,users); return user/userList; } } 
    
   

jsp页面">创建对应的jsp页面

在WEB-INF的views文件夹中添加user文件加，用来存放用户相关的视图，在添加一个userList.jsp文件

<%@ taglib prefix=c uri=http://java.sun.com/jsp/jstl/core %>
<%--
  Created by IntelliJ IDEA.
  User: elin
  Date: 15-7-1
  Time: 下午8:53
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType=text/html;charset=UTF-8 language=java %>

userList

?