mybatis-spring

最新推荐文章于 2023-08-18 10:26:58 发布

pzmyg

最新推荐文章于 2023-08-18 10:26:58 发布

阅读量176

点赞数

分类专栏：后端

本文链接：https://blog.csdn.net/pzmyg/article/details/80941042

版权

后端专栏收录该内容

13 篇文章 0 订阅

订阅专栏

1、新建项目工程，导入jar包

jar包主要包含mybatis，spring，mybatis-spring，mysql-connector-java等，mybatis和spring下载时各自带有其他相关jar包，所以一并导入了。

2、创建bean

package com.htp.bean;

public class User {
    private String id;
    private String name;
    private String address;
    public String getId() {
        return id;
    }
    public void setId(String id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }

}

3、创建applicationContext配置文件

<?xml version="1.0" encoding="utf-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="  
            http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd  
            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd  
            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd  
            http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd  
            http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"
    default-autowire="byName" default-lazy-init="false">

    <context:property-placeholder location="classpath:jdbc_property"></context:property-placeholder>
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.user}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--dataSource属性指定要用到的连接池-->
        <property name="dataSource" ref="dataSource" />
        <!--configLocation属性指定mybatis的核心配置文件-->
        <property name="configLocation" value="mybatisconfig.xml" />
    </bean>

    <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean"> 
        <!--sqlSessionFactory属性指定要用到的SqlSessionFactory实例-->
        <property name="sqlSessionFactory" ref="sqlSessionFactory" />
        <!--mapperInterface属性指定映射器接口，用于实现此接口并生成映射器对象-->
        <property name="mapperInterface" value="com.htp.mapper.UserMapper" />
    </bean>
</beans>

4、创建mybatisconfig配置文件

<?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="jdbc_property"></properties>
<mappers>
    <package name="com.htp.mapper"/>
</mappers>
</configuration>

jdbc_property内容如下

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/demo?allowMultiQueries=true&useSSL=true
jdbc.user=root
jdbc.password=root

5、创建mapper映射文件

<?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.htp.mapper.UserMapper">

  <resultMap  id="usersMap" type="java.util.Map">
    <id column="name" property="name" jdbcType="VARCHAR"/>
    <id column="address" property="address" jdbcType="VARCHAR"/>
  </resultMap>

  <select id="getUsers" resultMap="usersMap" >
    select name,address from user
  </select>

  </mapper>

6、创建映射接口

package com.htp.mapper;

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

public interface UserMapper {

    public List<Map<String, String>> getUsers();
}

7、创建测试类，此处贴出测试方法

    @Test //mybatis+spring 
    public void test2(){
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        UserMapper userMapper = (UserMapper) context.getBean("userMapper");
        List<Map<String, String>> rst = new ArrayList<Map<String,String>>();

        rst = userMapper.getUsers();
        for(int i=0;i<rst.size();i++){
            System.out.println("[name]"+ rst.get(i).get("name"));
        }
    }