springMvc入门教程2(集成mybatis和参数绑定)

源码地址：http://files.cnblogs.com/files/suzixuan/springMvcGuide.zip

数据库使用：mysql5.6

mybatis版本：mybatis-3.4.4

根据上次的项目，做了文件夹修改，整体目录如下：

1，修改spring-servlet.xml的文件目录，放在了Java Resources/resources下

web.xml文件内容修改，修改了spring-servlet.xml的加载目录

2，新添加jar包

mybatis-3.4.4.jar

mysql-connector-java-5.1.42-bin.jar

3，新增如上图的文件夹若干

4，增加web.xml中servlet拦截器，用于做静态文件解析。

5，增加mybatis的配置文件

6，添加控制器HomeController下的方法（public String Demo(Model model,@PathVariable("id") int id) ）

7，建表脚本：

DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `account` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

下面主要讲解myBatis的配置

myBatis需要jar包：mybatis-3.4.4.jar,mysql-connector-java-5.1.42-bin.jar

配置文件：mysql.properties，mybatis.cfg.xml

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test
jdbc.username=root
jdbc.password=

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
    <properties resource="mysql.properties"></properties>

    <typeAliases>
        <package name="model" />
    </typeAliases>

    <environments default="cybatis">
        <environment id="cybatis">
            <transactionManager type="JDBC" />
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}" />
                <property name="url" value="${jdbc.url}" />
                <property name="username" value="${jdbc.username}" />
                <property name="password" value="${jdbc.password}" />
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <package name="mapper" />
    </mappers>
</configuration>

建立Model类

package model;

import java.io.Serializable;

public class UserBean implements Serializable{

    private static final long serialVersionUID = 1L;
    private Integer id;
    private String username;
    private String password;
    private Double account;
    private String name;
    
    public String getName() {
        return name;
    }

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

    public UserBean() {
        super();
    }
    
    public UserBean(String username, String password, Double account) {
        super();
        this.username = username;
        this.password = password;
        this.account = account;
    }

    public UserBean(Integer id, String username, String password, Double account) {
        super();
        this.id = id;
        this.username = username;
        this.password = password;
        this.account = account;
    }

    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;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public Double getAccount() {
        return account;
    }

    public void setAccount(Double account) {
        this.account = account;
    }

    @Override
    public String toString() {
        return "UserBean [id=" + id + ", username=" + username + ", password="
                + password + ", account=" + account + "]";
    }
    
    
    

}

mapper文件：UserMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="mapper.UserMapper">
    <resultMap id="userMap" type="userbean">
        <id column="id" javaType="java.lang.Integer" property="id" />
        <result column="username" javaType="java.lang.String" property="username" />
        <result column="password" javaType="java.lang.String" property="password" />
        <result column="account" javaType="java.lang.Double" property="account" />
    </resultMap>

    <insert id="insertUser" keyProperty="id" useGeneratedKeys="true">
        insert into t_user (username,password,account) values
        (#{username},#{password},#{account})
    </insert>

    <update id="updateUser">
        update t_user set
        username=#{username},password=#{password},account=#{account} where
        id=#{id}
    </update>

    <delete id="deleteUser" parameterType="int">
        delete from t_user where
        id=#{id}
    </delete>

    <select id="selectUserById" parameterType="int" resultMap="userMap">
        select * from t_user where id=#{id}
    </select>

    <select id="selectAllUser" resultMap="userMap">
        select * from t_user
    </select>

    <select id="selectUserByNameAccount" resultType="model.UserBean">
        select * from t_user
        <where>
            <if test="name!=null  and name!=''">
                and username like '%' #{name} '%'
            </if>
            <if test="account!=null">
                and account&gt;#{account}
            </if>
        </where>
    </select>

</mapper>

建立UserMapper接口：

package mapper;

import java.util.List;
import java.util.Map;

import model.UserBean;

/**
 * @author huidong
 *
 */
public interface UserMapper {
    /**
     * 新增用戶
     * @param user
     * @return
     * @throws Exception
     */
    public int insertUser(UserBean user) throws Exception;
    /**
     * 修改用戶
     * @param user
     * @param id
     * @return
     * @throws Exception
     */
    public int updateUser (UserBean user,int id) throws Exception;
     /**
      * 刪除用戶
      * @param id
      * @return
      * @throws Exception
      */
    public int deleteUser(int id) throws Exception;
    /**
     * 根据id查询用户信息
     * @param id
     * @return
     * @throws Exception
     */
    public UserBean selectUserById(int id) throws Exception;
     /**
      * 查询所有的用户信息
      * @return
      * @throws Exception
      */
    public List<UserBean> selectAllUser() throws Exception;
    
    /**
     * 根据姓名和密码查询用户信息
     * @return
     * @throws Exception
     */
    public List<UserBean> selectUserByNameAccount(Map<String,Object> map) throws Exception;
}

 

建立DBTools：

package tools;

import java.io.Reader;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class DBTools {
    public static SqlSessionFactory sessionFactory;
    
    static{
        try {
            //使用MyBatis提供的Resources类加载mybatis的配置文件
            Reader reader = Resources.getResourceAsReader("mybatis.cfg.xml");
            //构建sqlSession的工厂
            sessionFactory = new SqlSessionFactoryBuilder().build(reader);
        } catch (Exception e) {
            e.printStackTrace();
        }
        
    }
    //创建能执行映射文件中sql的sqlSession
    public static SqlSession getSession(){
        return sessionFactory.openSession();
    }
    
}

建立Servic类，做测试

package service;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.jdbc.SQL;
import org.apache.ibatis.session.SqlSession;

import model.UserBean;
import tools.DBTools;
import mapper.UserMapper;

public class UserService {

    /**
     * 新增用户
     */
    private static void insertUser() {

        try (SqlSession session = DBTools.getSession()) {
            UserBean user = new UserBean("苏子2", "123", 500.0);
            session.insert("insertUser", user);
            session.commit();
        }

    }

    /**
     * 删除用户
     */
    private static void deleteUser() {
        SqlSession session = DBTools.getSession();
        UserMapper mapper = session.getMapper(UserMapper.class);
        try {
            mapper.deleteUser(1);
            session.commit();
        } catch (Exception e) {
            e.printStackTrace();
            session.rollback();
        }
    }

    /**
     * 根据id查询用户
     */
    public static UserBean selectUserById(int id) {
    
        SqlSession session = DBTools.getSession();

        UserBean user = session.selectOne("selectUserById", id);
        if (user == null) {
            System.out.println("user不存在");
        } else {
            System.out.println(user.toString());
        }
        session.close();
        return user;
    }

    /**
     * 查询所有的用户
     */
    private static void selectAllUser() {
        SqlSession session = DBTools.getSession();
        List<UserBean> list = session.selectList("selectAllUser");
        
        for (UserBean user : list) {
            System.out.println(user.toString());
        }
        session.close();
    }

    private static void selectUserByQuery() {
        SqlSession session = DBTools.getSession();
        Map<String, Object> map = new HashMap<String, Object>();
        map.put("name", "2");
        map.put("account", 400);
        UserMapper mapper = session.getMapper(UserMapper.class);
        try {
            List<UserBean> list = mapper.selectUserByNameAccount(map);
            for (UserBean user : list) {
                System.out.println(user.toString());
            }
            if (list == null || list.size() <= 0) {
                System.out.println("数据集为空");
            }
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }

}

讲解三个注解：

@RequestMapping，用来映射请求的url地址

@RequestParam，绑定单个请求数据，可以是URL中的数据，表单提交的数据或上传的文件； 

@PathVariable，绑定URL模板变量值；  

感谢网友们的分享，能让我一步步学习mvc和mybatis。

http://www.cnblogs.com/liukemng/p/3729071.html