spring-mvc框架学习（三）

上一章完成了基本的spring  web 项目，后边有很多可以添加完善的地方，就又研究了下 spring+maven+mybatis 实现与数据库的交互，其中额外涉及了 zk、dubbo 等内容

UserController.java

package com.springmvc.controller;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;

import org.springframework.stereotype.Controller;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import com.springmvc.domain.User;
import com.springmvc.service.IUserService;

@Controller
@RequestMapping(value = "/user")
@ContextConfiguration(locations = { "classpath:spring-mybatis.xml" })
public class UserController {
	@Resource
	private IUserService userService;

	@RequestMapping(value = "/showUser")
	public String toIndex(HttpServletRequest request, Model model) {

		int userId = Integer.parseInt(request.getParameter("id"));
		User user = this.userService.getUserById(userId);
		model.addAttribute("user", user);
		return "showUser";
	}
}

IUserDao.java

package com.springmvc.domain;

public class User {
	private Integer id;

	private String userName;

	private String password;

	private Integer age;

	public Integer getId() {
		return id;
	}

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

	public String getUserName() {
		return userName;
	}

	public void setUserName(String userName) {
		this.userName = userName == null ? null : userName.trim();
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password == null ? null : password.trim();
	}

	public Integer getAge() {
		return age;
	}

	public void setAge(Integer age) {
		this.age = age;
	}
}

User.java 其实这部分实现了多个查询功能，代码中仅调用了第一个根据 id 查询

package com.springmvc.dao;

import com.springmvc.domain.User;

public interface IUserDao {
	int deleteByPrimaryKey(Integer id);

	int insert(User record);

	int insertSelective(User record);

	User selectByPrimaryKey(Integer id);

	int updateByPrimaryKeySelective(User record);

	int updateByPrimaryKey(User record);
}

UserMapper.xml

  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="com.springmvc.domain.User" >

    select 

    <include refid="Base_Column_List" />

    from user_t

    where id = #{id,jdbcType=INTEGER}

  </select>

  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >

    delete from user_t

    where id = #{id,jdbcType=INTEGER}

  </delete>

  <insert id="insert" parameterType="com.springmvc.domain.User" >

    insert into user_t (id, user_name, password, 

      age)

    values (#{id,jdbcType=INTEGER}, #{userName,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, 

      #{age,jdbcType=INTEGER})

  </insert>

  <insert id="insertSelective" parameterType="com.springmvc.domain.User" >

    insert into user_t

    <trim prefix="(" suffix=")" suffixOverrides="," >

      <if test="id != null" >

        id,

      </if>

      <if test="userName != null" >

        user_name,

      </if>

      <if test="password != null" >

        password,

      </if>

      <if test="age != null" >

        age,

      </if>

    </trim>

    <trim prefix="values (" suffix=")" suffixOverrides="," >

      <if test="id != null" >

        #{id,jdbcType=INTEGER},

      </if>

      <if test="userName != null" >

        #{userName,jdbcType=VARCHAR},

      </if>

      <if test="password != null" >

        #{password,jdbcType=VARCHAR},

      </if>

      <if test="age != null" >

        #{age,jdbcType=INTEGER},

      </if>

    </trim>

  </insert>

  <update id="updateByPrimaryKeySelective" parameterType="com.springmvc.domain.User" >

    update user_t

    <set >

      <if test="userName != null" >

        user_name = #{userName,jdbcType=VARCHAR},

      </if>

      <if test="password != null" >

        password = #{password,jdbcType=VARCHAR},

      </if>

      <if test="age != null" >

        age = #{age,jdbcType=INTEGER},

      </if>

    </set>

    where id = #{id,jdbcType=INTEGER}

  </update>

  <update id="updateByPrimaryKey" parameterType="com.springmvc.domain.User" >

    update user_t

    set user_name = #{userName,jdbcType=VARCHAR},

      password = #{password,jdbcType=VARCHAR},

      age = #{age,jdbcType=INTEGER}

    where id = #{id,jdbcType=INTEGER}

  </update>

</mapper>

IUserService.java

package com.springmvc.service;

import com.springmvc.domain.User;

public interface IUserService {
	public User getUserById(int userId);
}

UserServiceImpl.java   service 的继承实现类

package com.springmvc.service.impl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.springmvc.dao.IUserDao;
import com.springmvc.domain.User;
import com.springmvc.service.IUserService;

@Service("userService")
public class UserServiceImpl implements IUserService {
	@Autowired
	private IUserDao userDao; // 注入dao

	@Override
	public User getUserById(int userId) {

		// TODO Auto-generated method stub
		return this.userDao.selectByPrimaryKey(userId);
	}

}

3、最后在view目录下新建showUser.jsp文件，展示结果

相关阅读：spring-mvc框架学习（一）

spring-mvc框架学习（二）

本文来自网易实践者社区，经作者李亚松授权发布。