idea创建maven,spring,springmvc,mybatis,项目（三）

接上篇   idea创建maven,spring,springmvc,mybatis,项目（二） 

 http://blog.youkuaiyun.com/hcmony/article/details/77840891

1，UserController

 

package com.hcmony.controller;

import com.hcmony.model.User;
import com.hcmony.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

/**
 * Created by hcmony on 2017/9/1.
 */
@Controller
@RequestMapping("/user")
public class UserController {

   @Autowired
   private UserService userService;

   @RequestMapping("/findUser")
   public void findUser(Integer id){
      User user = userService.findUser(id);
      System.out.println("user的id是："+user.getId());
      System.out.println("user的名字是："+user.getName());
   }

   @RequestMapping("/saveUser")
   public void saveUser(Integer id,String name){
      Integer num = userService.saveUser(id,name);
      if(num!=null&&num>0){
         System.out.println("保存成功了！");
      }else {
         System.out.println("保存失败了！");
      }
   }

}

 

 

 

2，UserService

 

package com.hcmony.service;

import com.hcmony.model.User;

/**
 * Created by hcmony on 2017/9/1.
 */

public interface UserService {
   public Integer saveUser(Integer id,String name);
   public User findUser(Integer id);
}

 

 

 

3，UserServiceImpl

 

package com.hcmony.service.impl;

import com.hcmony.mapper.UserMapper;
import com.hcmony.model.User;
import com.hcmony.service.UserService;
import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * Created by hcmony on 2017/9/1.
 */
@Service
public class UserServiceImpl implements UserService {

   private static Logger logger = Logger.getLogger(UserService.class);

   @Autowired
   private UserMapper userMapper;

   @Override
   public Integer saveUser(Integer id, String name) {
      try {
         User user = new User();
         user.setId(id);
         user.setName(name);
         System.out.println(id+"--------------"+name);
         Integer num = userMapper.save(user);
         return num;
      }catch (Exception e){
         logger.error("保存用户失败",e);
      }
      return null;
   }

   @Override
   public User findUser(Integer id) {
      try {
         return userMapper.findById(id);
      }catch (Exception e){
         logger.error("查询用户失败",e);
      }
      return null;
   }
}

 

 

 

4，UserMapper

 

package com.hcmony.mapper;

import com.hcmony.model.User;

/**
 * Created by hcmony on 2017/9/1.
 */
public interface UserMapper {
   public Integer save(User user);
   public User findById (Integer id);
}

 

 

 

5，User

 

package com.hcmony.model;

/**
 * Created by hcmony on 2017/9/1.
 */
public class User {
   private Integer id;
   private String name;

   public Integer getId() {
      return id;
   }

   public void setId(Integer id) {
      this.id = id;
   }

   public String getName() {
      return name;
   }

   public void setName(String name) {
      this.name = name;
   }
}

 

 

 

5，UserMapper.xml

 

<?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.hcmony.mapper.UserMapper" >
  <resultMap id="resultMap" type="com.hcmony.model.User" >
    <constructor >
      <idArg column="id" jdbcType="INTEGER" javaType="java.lang.Integer" />
      <arg column="name" jdbcType="VARCHAR" javaType="java.lang.String" />
    </constructor>
  </resultMap>
  <sql id="sql" >
    id, name
  </sql>
  <select id="findById" resultMap="resultMap" parameterType="java.lang.Integer" >
    select 
    <include refid="sql" />
    from user
    where id = #{id,jdbcType=INTEGER}
  </select>

  <insert id="save"  parameterType="com.hcmony.model.User">
    insert into user (id, name)
    values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR})
  </insert>

</mapper>

 

 

 

 

6，EncodingInteceptor

 

package com.hcmony.interceptor;

import org.springframework.web.servlet.HandlerInterceptor;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Created by hcmony on 2017/9/1.
 */
public class EncodingInteceptor implements HandlerInterceptor {

   /**
    * 在controller前拦截
    */
   @Override
   public boolean preHandle(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o) throws Exception {
      httpServletRequest.setCharacterEncoding("UTF-8");
      httpServletResponse.setCharacterEncoding("UTF-8");
      return true;
   }

   @Override
   public void postHandle(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o, ModelAndView modelAndView) throws Exception {

   }

   @Override
   public void afterCompletion(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o, Exception e) throws Exception {

   }
}

 

 

 

7，创建sql语句

/*Table structure for table `user` */


DROP TABLE IF EXISTS `user`;


CREATE TABLE `user` (
  `id` tinyint(12) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `age` tinyint(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;


/*Data for the table `user` */

 

springcloud 源代码 https://github.com/hcmony/springcloud.git

idea创建maven项目，本教程适合各类小白（一）

idea创建maven,spring,springmvc,mybatis,项目（二） 

idea创建maven,spring,springmvc,mybatis,项目（三）

idea创建springboot项目图文教程（四）

idea创建springboot项目图文教程(配置文件)（五）

idea创建springcloud项目图文教程(EurekaServer注册中心)（六）

idea创建springcloud项目图文教程(创建服务提供者)（七）

idea创建springcloud项目图文教程(创建消费者)（八）

idea创建springcloud项目图文教程(Feign实现负载均衡)（九）

idea创建springcloud项目图文教程(config 实现配置中心)（十一）

idea创建springcloud项目图文教程(bus 消息总线)（十二）