本文共 7095 字，大约阅读时间需要 23 分钟。

1、导包

Spring         Spring MVC      mybatis

包:spring   springMVCshuju

2、配置文件

Spring 核心配置文件

Spring配置文件

mybatis配置文件

映射文件

db.properties

log4j.properties

ModelAndView:自动跳转页面

3、框架架构

 UserController.java

package cn.hd.controller;import cn.hd.entity.User;import cn.hd.service.UserService;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.servlet.ModelAndView;import javax.annotation.Resource;@Controllerpublic class UserController {    @Resource(name = "userServiceImpl")    private UserService userService;    @RequestMapping("/login.action")    public ModelAndView login(){        User userById = userService.getUserById(1);        System.out.println(userById);        ModelAndView mav = new ModelAndView();        mav.setViewName("/index.jsp");        return mav;    }    @RequestMapping("/add")    public void add(){        User user = new User();        //user.setId(7);        user.setName("张三");        user.setAddress("河南");        user.setBalance(20000);        user.setSex("男");        Integer row = userService.addUser(user);        System.out.println(row);    }    @RequestMapping("/updateUser")    public void updateUser(){        User user = new User();        user.setId(7);        user.setName("李四");        user.setAddress("河南");        user.setBalance(20000);        user.setSex("男");        Integer row = userService.updateUser(user);        System.out.println(row);    }}

User.java——》entity

package cn.hd.controller;import cn.hd.entity.User;import cn.hd.service.UserService;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.servlet.ModelAndView;import javax.annotation.Resource;@Controllerpublic class UserController {    @Resource(name = "userServiceImpl")    private UserService userService;    @RequestMapping("/login.action")    public ModelAndView login(){        User userById = userService.getUserById(1);        System.out.println(userById);        ModelAndView mav = new ModelAndView();        mav.setViewName("/index.jsp");        return mav;    }    @RequestMapping("/add")    public void add(){        User user = new User();        //user.setId(7);        user.setName("张三");        user.setAddress("河南");        user.setBalance(20000);        user.setSex("男");        Integer row = userService.addUser(user);        System.out.println(row);    }    @RequestMapping("/updateUser")    public void updateUser(){        User user = new User();        user.setId(7);        user.setName("李四");        user.setAddress("河南");        user.setBalance(20000);        user.setSex("男");        Integer row = userService.updateUser(user);        System.out.println(row);    }}

UserMapper

package cn.hd.mapper;import cn.hd.entity.User;import cn.hd.query_vo.QueryVo;import org.springframework.stereotype.Repository;@Repositorypublic interface UserMapper {    User findUserById(Integer id);    Integer addUser(QueryVo vo);    Integer updateUser(QueryVo vo);}

UserMapper.xml

   
           
            SELECT * FROM t_user WHERE id = #{id}        
    
             INSERT INTO        t_user(name,sex,address,balance)        VALUES (#{user.name},#{user.sex},#{user.address},#{user.balance})    
        
    
         UPDATE t_user    
             
      
                   name = #{user.name},        
              
      
                   balance=#{user.balance},        
              
      
                   sex=#{user.sex},        
              
      
                   address=#{user.address} ,        
          
         
     
              id = #{user.id}    
         
    
   

QueryVo

package cn.hd.query_vo;import cn.hd.entity.User;import java.util.List;public class QueryVo {    private User user;    private List
   
     list;    public List
    
      getList() {        return list;    }    public void setList(List
     
       list) {        this.list = list;    }    public User getUser() {        return user;    }    public void setUser(User user) {        this.user = user;    }    @Override    public String toString() {        return "QueryVo{" +                "user=" + user +                ", list=" + list +                '}';    }}
     
    
   

UserService

package cn.hd.service;import cn.hd.entity.User;public interface UserService {    User getUserById(Integer id);    Integer addUser(User user);    Integer updateUser(User user);}

UserServiceImpl

package cn.hd.service.impl;import cn.hd.entity.User;import cn.hd.mapper.UserMapper;import cn.hd.query_vo.QueryVo;import cn.hd.service.UserService;import org.springframework.stereotype.Service;import javax.annotation.Resource;@Servicepublic class UserServiceImpl implements UserService {    @Resource(name = "userMapper")    private UserMapper userMapper;    @Override    public User getUserById(Integer id) {        User user = userMapper.findUserById(id);        return user;    }    @Override    public Integer addUser(User user) {        QueryVo v = new QueryVo();        v.setUser(user);        Integer row = userMapper.addUser(v);        return row;    }    @Override    public Integer updateUser(User user) {        QueryVo v = new QueryVo();        v.setUser(user);        user.setBalance(10000);        Integer row = userMapper.updateUser(v);//        int i = 1/0;//        user.setBalance(1000);//        v.setUser(user);//        userMapper.updateUser(v);        return row;    }}

applicationContext.xml

db.properties

jdbc.driver=com.mysql.jdbc.Driverjdbc.url = jdbc:mysql://localhost:3306/mybatis_demo?useUnicode=true&characterEncoding=utf-8jdbc.username=rootjdbc.password=123

log4j.properties

# Global logging configuration#在开发环境下日志级别设置为debug，生产环境下设置成info或error#log4j.rootLogger=DEBUG, stdout# Console output...#log4j.appender.stdout=org.apache.log4j.ConsoleAppender#log4j.appender.stdout.layout=org.apache.log4j.PatternLayout#log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%nlog4j.rootLogger=INFO, stdoutlog4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.Threshold=INFOlog4j.appender.stdout.Target=System.outlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%d %p [%c,%L] - %m%n

SpringMVC.xml

SqlMapConfig.xml