<?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.gxa.bj.dao.UserInfoMapper">  
  
    <insert id="getInsert" parameterType="com.gxa.bj.model.UserInfo">  
        insert into UserInfo(userid,username,userpwd,flag)  
        values(usernext.nextval,#{userName},#{userPwd},#{flag})  
    </insert>  
    <delete id="getDelete">  
        delete From UserInfo Where userid=#{id}   
    </delete>  
    <update id="getUpdate" parameterType="com.gxa.bj.model.UserInfo">  
        update UserInfo set  
        <if test="userName!=null">  
            userName=#{userName},  
        </if>  
        <if test="userPwd!=null">  
            userPwd=#{userPwd},  
        </if>  
        <if test="flag!=null">  
            flag=#{flag},  
        </if>  
        userId=#{userId} Where userId=#{userId}  
    </update>  
    <select id="getList" parameterType="com.gxa.bj.model.UserInfo" resultType="com.gxa.bj.model.UserInfo">  
        select * From UserInfo   
        <where>  
            <if test="userName!=null">  
                And userName=#{userName}  
            </if>  
            <if test="userPwd!=null">  
                And userPwd=#{userPwd}  
            </if>  
            <if test="flag!=null">  
                And flag=#{flag}  
            </if>  
            <if test="userId>0">  
                And userId=#{userId}  
            </if>  
        </where>  
    </select>  
   <select id="getModel" resultType="com.gxa.bj.model.UserInfo">  
        select * From UserInfo Where userid=#{id}  
   </select>  
   <select id="getUsers" parameterType="java.lang.String"  resultType="com.gxa.bj.model.UserInfo">  
        select * From UserInfo Where userName like '%${value}%'  
   </select>  
</mapper>  

8.Service层里的业务层内容如下:
加上@Service注解，才能吧Service扫描进Spring  IOC容器

package com.gxa.bj.service;  
  
import java.util.List;  
  
import org.springframework.stereotype.Service;  
  
import com.gxa.bj.dao.UserInfoMapper;  
import com.gxa.bj.model.UserInfo;  
@Service  
public class UserInfoService {  
    private UserInfoMapper userInfoMapper;  
    public List<UserInfo> getList(UserInfo u){  
        return userInfoMapper.getList(u);  
    }  
    public UserInfoMapper getUserInfoMapper() {  
        return userInfoMapper;  
    }  
    public void setUserInfoMapper(UserInfoMapper userInfoMapper) {  
        this.userInfoMapper = userInfoMapper;  
    }  
    public UserInfo getLogin(String name,String Pwd){  
        UserInfo u = new UserInfo();  
        u.setUserName(name);  
        u.setUserPwd(Pwd);  
        List<UserInfo> list=userInfoMapper.getList(u);  
        if(list.size()>0){  
            return list.get(0);  
        }else{  
            return null;  
        }  
    }  
}  

9.action层里的界面层内容如下:
Controller（控制器）主要负责处DispacherServlet分发的请求
定义i@Controller注解标记，然后使用@RequestMapping和@RequestParam等注解来定义url请求和方法直接的映射

package com.gxa.bj.action;  
  
import java.io.IOException;  
import java.io.UnsupportedEncodingException;  
import java.util.List;  
  
import javax.servlet.ServletException;  
import javax.servlet.http.HttpServletRequest;  
import javax.servlet.http.HttpServletResponse;  
  
import org.springframework.stereotype.Controller;  
import org.springframework.web.bind.annotation.RequestMapping;  
import org.springframework.web.servlet.ModelAndView;  
  
import com.gxa.bj.model.UserInfo;  
import com.gxa.bj.service.UserInfoService;  
  
@Controller  
public class UserInfoAction {  
    private UserInfoService userInfoService;  
    public UserInfoService getUserInfoService() {  
        return userInfoService;  
    }  
    public void setUserInfoService(UserInfoService userInfoService) {  
        this.userInfoService = userInfoService;  
    }  
    public List<UserInfo> getList(UserInfo u){  
        return userInfoService.getList(u);  
    }  
    @RequestMapping(value="/getalluser.action")  
    public ModelAndView getAllUser(){  
        ModelAndView model = new ModelAndView();  
        List<UserInfo> list = userInfoService.getList(null);  
        model.addObject("users", list);  
        model.setViewName("/index.jsp");  
        return model;  
    }  
    @RequestMapping(value="/login.action")  
    public void login(HttpServletRequest req,HttpServletResponse resp){  
        try {  
            req.setCharacterEncoding("UTF-8");  
        } catch (UnsupportedEncodingException e1) {  
            // TODO Auto-generated catch block  
            e1.printStackTrace();  
        }  
        String userName=req.getParameter("userName");  
        String userPwd=req.getParameter("userPwd");  
        UserInfo u=userInfoService.getLogin(userName,userPwd);  
        if(u!=null){  
            System.out.println("登陆成功");  
            req.getSession().setAttribute("userInfo",u);  
            try {  
                req.getRequestDispatcher("login.jsp").forward(req, resp);  
            } catch (ServletException e) {  
                // TODO Auto-generated catch block  
                e.printStackTrace();  
            } catch (IOException e) {  
                // TODO Auto-generated catch block  
                e.printStackTrace();  
            }  
        }else{  
            System.out.println("登陆失败");  
        }  
    }  
}