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

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

 http://blog.csdn.net/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. */@Servicepublic 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` */

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实现负载均衡)（九）