接上篇 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.
*/
@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,spring,springmvc,mybatis,项目(二)
idea创建maven,spring,springmvc,mybatis,项目(三)
idea创建springboot项目图文教程(配置文件)(五)
idea创建springcloud项目图文教程(EurekaServer注册中心)(六)
idea创建springcloud项目图文教程(创建服务提供者)(七)
idea创建springcloud项目图文教程(创建消费者)(八)
idea创建springcloud项目图文教程(Feign实现负载均衡)(九)
idea创建springcloud项目图文教程(config 实现配置中心)(十一)
idea创建springcloud项目图文教程(bus 消息总线)(十二)