Spring框架中集成myBatis框架

文章目录

使用步骤
- 1.新建maven项目
- 2.加入maven的依赖
- 3.创建实体类
- 4.创建dao接口和mapper文件
- 5.创建mybatis主配置文件
- 6.创建Service接口和实现类，属性是dao。
- 7.创建spring的配置文件：声明mybatis的对象交给spring创建
- 8.创建测试类，获取Service对象，通过service调用dao完成数据库的访问

使用步骤

1.新建maven项目

在这里插入图片描述

2.加入maven的依赖

1）spring依赖
2）mybatis依赖
3）mysql驱动
4）spring的事务的依赖
5）mybatis和spring集成的依赖： mybatis官方体用的，用来在spring项目中创建mybatis 的SqlSesissonFactory，dao对象的

  <dependencies>
    
    <dependency>
      <groupId>junitgroupId>
      <artifactId>junitartifactId>
      <version>4.11version>
      <scope>testscope>
    dependency>
    
    <dependency>
      <groupId>org.springframeworkgroupId>
      <artifactId>spring-contextartifactId>
      <version>5.2.5.RELEASEversion>
    dependency>
    
    <dependency>
      <groupId>org.springframeworkgroupId>
      <artifactId>spring-txartifactId>
      <version>5.2.5.RELEASEversion>
    dependency>
    <dependency>
      <groupId>org.springframeworkgroupId>
      <artifactId>spring-jdbcartifactId>
      <version>5.2.5.RELEASEversion>
    dependency>
    
    <dependency>
      <groupId>org.mybatisgroupId>
      <artifactId>mybatisartifactId>
      <version>3.5.1version>
    dependency>
    
    <dependency>
      <groupId>org.mybatisgroupId>
      <artifactId>mybatis-springartifactId>
      <version>1.3.1version>
    dependency>
    
    <dependency>
      <groupId>mysqlgroupId>
      <artifactId>mysql-connector-javaartifactId>
      <version>5.1.9version>
    dependency>
    
    <dependency>
      <groupId>com.alibabagroupId>
      <artifactId>druidartifactId>
      <version>1.1.12version>
    dependency>
  dependencies>

加入插件

  <build>
    
    <resources>
      <resource>
        <directory>src/main/javadirectory>
        <includes>
          <include>**/*.propertiesinclude>
          <include>**/*.xmlinclude>
        includes>
        <filtering>falsefiltering>
      resource>
    resources>
    
    <plugins>
      <plugin>
        <artifactId>maven-compiler-pluginartifactId>
        <version>3.1version>
        <configuration>
          <source>1.8source>
          <target>1.8target>
        configuration>
      plugin>
    plugins>
  build>

完整的maven配置文件：

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0modelVersion>

  <groupId>com.bjpowernodegroupId>
  <artifactId>ch07-spring-mybatisartifactId>
  <version>1.0-SNAPSHOTversion>


  <properties>
    <project.build.sourceEncoding>UTF-8project.build.sourceEncoding>
    <maven.compiler.source>1.8maven.compiler.source>
    <maven.compiler.target>1.8maven.compiler.target>
  properties>

  <dependencies>
    
    <dependency>
      <groupId>junitgroupId>
      <artifactId>junitartifactId>
      <version>4.11version>
      <scope>testscope>
    dependency>
    
    <dependency>
      <groupId>org.springframeworkgroupId>
      <artifactId>spring-contextartifactId>
      <version>5.2.5.RELEASEversion>
    dependency>
    
    <dependency>
      <groupId>org.springframeworkgroupId>
      <artifactId>spring-txartifactId>
      <version>5.2.5.RELEASEversion>
    dependency>
    <dependency>
      <groupId>org.springframeworkgroupId>
      <artifactId>spring-jdbcartifactId>
      <version>5.2.5.RELEASEversion>
    dependency>
    
    <dependency>
      <groupId>org.mybatisgroupId>
      <artifactId>mybatisartifactId>
      <version>3.5.1version>
    dependency>
    
    <dependency>
      <groupId>org.mybatisgroupId>
      <artifactId>mybatis-springartifactId>
      <version>1.3.1version>
    dependency>
    
    <dependency>
      <groupId>mysqlgroupId>
      <artifactId>mysql-connector-javaartifactId>
      <version>5.1.9version>
    dependency>
    
    <dependency>
      <groupId>com.alibabagroupId>
      <artifactId>druidartifactId>
      <version>1.1.12version>
    dependency>
  dependencies>

  <build>
    
    <resources>
      <resource>
        <directory>src/main/javadirectory>
        <includes>
          <include>**/*.propertiesinclude>
          <include>**/*.xmlinclude>
        includes>
        <filtering>falsefiltering>
      resource>
    resources>
    
    <plugins>
      <plugin>
        <artifactId>maven-compiler-pluginartifactId>
        <version>3.1version>
        <configuration>
          <source>1.8source>
          <target>1.8target>
        configuration>
      plugin>
    plugins>
  build>
project>

3.创建实体类

用来存储数据库表中一行的数据

package com.changsha.domain;

public class Student {
    private Integer id;
    private String name;
    private Integer age;
    private String email;

    public Student() {
    }

    public Student(Integer id, String name, Integer age, String email) {
        this.id = id;
        this.name = name;
        this.age = age;
        this.email = email;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

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

    public Integer getAge() {
        return age;
    }

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

    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                ", email='" + email + '\'' +
                '}';
    }
}

4.创建dao接口和mapper文件

dao接口，定义对数据库的操作

package com.changsha.dao;

import com.changsha.domain.Student;

import java.util.List;

public interface StudentDao {
    int insertStudent(Student student);
    List<Student> selectStudents();

}

mapper配置文件(需要和dao接口同名且在同一目录之下)

<?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.changsha.dao.StudentDao">

    <insert id="insertStudent">
        insert into student value (#{id}, #{name}, #{age})
    insert>


    <select id="selectStudents" resultType="com.changsha.domain.Student">
        select * from student order by id desc
    select>

mapper>

5.创建mybatis主配置文件

因为使用别的连接池，所以数据库信息不用指定在这个文件中

<?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>

    
    <settings>
        
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    settings>

    
    <typeAliases>
        
        <package name="com.changsha.domain"/>
    typeAliases>


    
    <mappers>
        
        <package name="com.changsha.dao"/>
    mappers>
configuration>

6.创建Service接口和实现类，属性是dao。

一般不会直接调用dao对象，而是创建服务类来调用dao对象的方法

接口

package com.changsha.service;

import com.changsha.domain.Student;

import java.util.List;

public interface StudentService {
    int addStudent(Student student);
    List<Student> queryStudents();

}

对应实现类

package com.changsha.service.Impl;

import com.changsha.dao.StudentDao;
import com.changsha.domain.Student;
import com.changsha.service.StudentService;

import java.util.List;

public class StudentServiceImpl implements StudentService {

    private StudentDao studentDao;

    public void setStudentDao(StudentDao studentDao) {
        this.studentDao = studentDao;
    }

    @Override
    public int addStudent(Student student) {
        int nums = studentDao.insertStudent(student);
        return nums;
    }

    @Override
    public List<Student> queryStudents() {
        return studentDao.selectStudents();
    }
}

7.创建spring的配置文件：声明mybatis的对象交给spring创建

1）数据源DataSource
2）SqlSessionFactory
3) Dao对象
4）声明自定义的service

创建数据库信息properties文件

jdbc.url =  jdbc:mysql://localhost:3306/study
jdbc.password = 123456
jdbc.username = root
jdbc.maxActive =  20

创建spring配置文件

<?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:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">


    
    <context:property-placeholder location="classpath:jdbc.properties" />

    
    <bean id="myDataSource" class="com.alibaba.druid.pool.DruidDataSource"
          init-method="init" destroy-method="close">
        
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="maxActive" value="${jdbc.maxActive}"/>
    bean>



    
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        
        <property name="dataSource" ref="myDataSource"/>
        
        <property name="configLocation" value="classpath:SpringAndMybatis.xml"/>

    bean>



    
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        
        <property name="basePackage" value="com.changsha.dao"/>
    bean>



    
    <bean id="studentService" class="com.changsha.service.Impl.StudentServiceImpl">
        <property name="studentDao" ref="studentDao"/>
    bean>

beans>

8.创建测试类，获取Service对象，通过service调用dao完成数据库的访问

package com.changsha;

import com.changsha.domain.Student;
import com.changsha.service.StudentService;
import org.apache.ibatis.annotations.Param;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.util.List;

public class MyTest {
    @Test
    public void test(){
        String config = "ApplicationContext.xml";
        ApplicationContext applicationContext = new ClassPathXmlApplicationContext(config);
        StudentService studentService = (StudentService)applicationContext.getBean("studentService");
        //插入信息
        studentService.addStudent(new Student(2,"zhao","zhao@",22));
        //显示信息
        List<Student> students = studentService.queryStudents();
        students.forEach(stu -> System.out.println(stu));
    }
}

Java框架

Spring框架中集成myBatis框架

文章目录

使用步骤

1.新建maven项目

2.加入maven的依赖

3.创建实体类

4.创建dao接口和mapper文件

5.创建mybatis主配置文件

6.创建Service接口和实现类，属性是dao。

7.创建spring的配置文件：声明mybatis的对象交给spring创建

8.创建测试类，获取Service对象，通过service调用dao完成数据库的访问

相关

java集合框架容器 java框架层级继承图结构集合框架的抽象类集合框架主要实现类

标签

Spring框架中集成myBatis框架

文章目录

使用步骤

1.新建maven项目

2.加入maven的依赖

3.创建实体类

4.创建dao接口和mapper文件

5.创建mybatis主配置文件

6.创建Service接口和实现类，属性是dao。

7.创建spring的配置文件：声明mybatis的对象交给spring创建

8.创建测试类，获取Service对象，通过service调用dao完成数据库的访问

相关

java集合框架容器 java框架层级 继承图结构 集合框架的抽象类 集合框架主要实现类

标签

java集合框架容器 java框架层级继承图结构集合框架的抽象类集合框架主要实现类