mybatis入门项目

最新推荐文章于 2024-07-22 14:15:06 发布

孤我.

最新推荐文章于 2024-07-22 14:15:06 发布

阅读量46

点赞数

分类专栏： Java学习文章标签： mybatis java mysql

本文链接：https://blog.csdn.net/qq_45054047/article/details/129151633

版权

Java学习专栏收录该内容

23 篇文章 0 订阅

订阅专栏

mybatis增删改查入门项目

1、目录

在这里插入图片描述

2、pom.xml

<?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.0</modelVersion>

    <groupId>org.example</groupId>
    <artifactId>mybatis20230217</artifactId>
    <version>1.0-SNAPSHOT</version>

    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory><!--所在的目录-->
                <includes><!--包括目录下的.properties,.xml 文件都会扫描到-->
                    <include>**/*.properties</include>
                    <include>daoMapper/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>


    <dependencies>

        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>

        <!--引入数据库驱动依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.10</version>
        </dependency>

        <!-- 引入mybatis依赖 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>
        

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.12</version>
            <scope>provided</scope>
        </dependency>
        

    </dependencies>

    
</project>

3、mybatisConfig.xml

<?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="db.properties"></properties>

    <!-- 打印查询语句 -->
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING" />
    </settings>

    <!-- 取别名 -->
    <typeAliases>
        <typeAlias type="model.Student" alias="Student" />
    </typeAliases>


    <!--配置mybatis环境-->
        <!--配置连接使用的相关参数
            default为默认使用的环境：development 测试环境
                                  product     生产环境
        -->

    <environments default="development">  <!--测试环境-->
        <environment id="development">
            <transactionManager type="JDBC"/>  <!--事务管理类型：指定事务管理的方式 JDBC-->
            <dataSource type="POOLED">
                <!--数据源类型：POOLED 表示支持JDBC数据源连接池
              UNPOOLED 表示不支持数据源连接池
              JNDI 表示支持外部数据源连接池-->

                <!-- 从配置文件中加载属性 -->
                <property name="driver" value="${db.driver}"/>
                <property name="url" value="${db.url}"/>
                <property name="username" value="${db.user}"/>
                <property name="password" value="${db.password}"/>
            </dataSource>
        </environment>
    </environments>


    <!--注册mapper配置文件（mapper文件路径配置）
        注意：映射配置文件位置要和映射器位置一样，如：映射器在com.mycode.dao里，
             那么配置文件就应该在resources的com/mycode/dao目录下，否则会报
             Could not find resource com.mycode.dao.UserMapper.xml类似错误
     -->

    <mappers>
        <mapper resource="StudentMapper.xml"/>
    </mappers>

</configuration>

4、db.properties

db.url=jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf8
db.user=root
db.password=123456
db.driver=com.mysql.jdbc.Driver

5、Student

package model;

/**
 * @Package : model
 * @Author : YYH
 * @Date : 2023-02-19 15:32
 * @Desc :
 */
public class Student {

    private int id;

    private String name;

    private int age;

    private int gender;


    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public int getAge() {
        return age;
    }

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

    public int getGender() {
        return gender;
    }

    public void setGender(int gender) {
        this.gender = gender;
    }

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

6、StudentMapper.java

package dao;

import model.Student;

import java.util.List;

/**
 * @Package : dao
 * @Author : YYH
 * @Date : 2023-02-19 16:01
 * @Desc :
 */
public interface StudentMapper {

    int addStudent(Student student);//增加
    int deleteStudent(Student student);//删除
    int updateStudent(Student student);//修改
    Student selectStudent(Student student);//id查询
    List<Student> allStudent();//查全部

}

7、StudentMapper.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为映射的根节点，用来管理DAO接口
      namespace指定DAO接口的完整类名，表示mapper配置文件管理哪个DAO接口(包.接口名)
      mybatis会依据这个接口动态创建一个实现类去实现这个接口，而这个实现类是一个Mapper对象
   -->

<mapper namespace="dao.StudentMapper">

    <!--
      id = "接口中的方法名"
      parameterType = "接口中传入方法的参数类型"
      resultType = 接口返回值为类使用
      studentMap = 接口返回值为集合使用（类也可以使用）
        <resultMap type="model.Student" id="studentMap">
            <id property="id" column="ID"/>
            <result property="name" column="NAME"/>
            <result property="age" column="AGE"/>
            <result property="gender" column="GENDER"/>
        </resultMap>

      注意:sql语句后不要出现";"号
          查询：select标签
          增加：insert标签
          修改：update标签
          删除：delete标签
  -->

    <!--创建一个存储结果的结果集对象放老师对象 -->
    <resultMap type="Student" id="studentMap">
        <id property="id" column="ID"/>
        <result property="name" column="NAME"/>
        <result property="age" column="AGE"/>
        <result property="gender" column="GENDER"/>
    </resultMap>

    <insert id="addStudent" parameterType="Student">
        INSERT INTO student(id,name,age,gender) VALUES(#{id},#{name},#{age},#{gender})
    </insert>

    <delete id="deleteStudent" parameterType="Student">
        DELETE FROM student WHERE id=#{id}
    </delete>

    <update id="updateStudent" parameterType="Student">
        UPDATE student SET `name`=#{name} WHERE id=#{id}
    </update>

    <select id="selectStudent" parameterType="Student" resultType="Student">
        SELECT * FROM student WHERE id=#{id}
    </select>

    <select id="allStudent" resultMap="studentMap">
        SELECT * FROM student
    </select>




</mapper>

8、t1测试类

import java.io.IOException;
import java.io.InputStream;



import dao.StudentMapper;
import model.Student;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

/**
 * @Package : PACKAGE_NAME
 * @Author : YYH
 * @Date : 2023-02-19 17:28
 * @Desc :
 */
public class t1 {

    @Test
    public void test1() throws IOException {//测试增加
        Student student = new Student();
        student.setId(1022);
        student.setName("vv33");

        //1.读取主配置文件
        String resource = "mybatis.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);

        //2.构建Sqlsession工厂
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        //3.从工厂中生成SqlSession对象,此对象封闭了所有JDBC对象
        SqlSession sqlSession = sqlSessionFactory.openSession();

        //4.用些对象实现CRUD
        StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);//相当于实例化
        studentMapper.addStudent(student);

        //5.默认是提交到内存里面的，不会持久化（提交到数据库），所以要手动提交事务
        sqlSession.commit();

        //关闭事务
        sqlSession.close();

    }


    @Test
    public void test2() throws IOException {//测试删除
        Student student = new Student();
        student.setId(1022);


        //1.读取主配置文件
        String resource = "mybatis.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);

        //2.构建Sqlsession工厂
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        //3.从工厂中生成SqlSession对象,此对象封闭了所有JDBC对象
        SqlSession sqlSession = sqlSessionFactory.openSession();

        //4.用些对象实现CRUD
        StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);//相当于实例化
        studentMapper.deleteStudent(student);

        //5.默认是提交到内存里面的，不会持久化（提交到数据库），所以要手动提交事务
        sqlSession.commit();

        //关闭事务
        sqlSession.close();

    }




    @Test
    public void test3() throws IOException {//修改测试
        Student student = new Student();
        student.setId(2);
        student.setName("aa");


        //1.读取主配置文件
        String resource = "mybatis.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);

        //2.构建Sqlsession工厂
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        //3.从工厂中生成SqlSession对象,此对象封闭了所有JDBC对象
        SqlSession sqlSession = sqlSessionFactory.openSession();

        //4.用些对象实现CRUD
        StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);//相当于实例化
        studentMapper.updateStudent(student);

        //5.默认是提交到内存里面的，不会持久化（提交到数据库），所以要手动提交事务
        sqlSession.commit();

        //关闭事务
        sqlSession.close();

    }


    @Test
    public void test4() throws IOException {//查询id测试
        Student student = new Student();
        student.setId(2);



        //1.读取主配置文件
        String resource = "mybatis.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);

        //2.构建Sqlsession工厂
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        //3.从工厂中生成SqlSession对象,此对象封闭了所有JDBC对象
        SqlSession sqlSession = sqlSessionFactory.openSession();

        //4.用些对象实现CRUD
        StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);//相当于实例化
        Student student1 = studentMapper.selectStudent(student);
        System.out.println(student1.toString());

        //5.默认是提交到内存里面的，不会持久化（提交到数据库），所以要手动提交事务
        sqlSession.commit();

        //关闭事务
        sqlSession.close();

    }




    @Test
    public void test5() throws IOException {//查询全部测试


        //1.读取主配置文件
        String resource = "mybatis.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);

        //2.构建Sqlsession工厂
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        //3.从工厂中生成SqlSession对象,此对象封闭了所有JDBC对象
        SqlSession sqlSession = sqlSessionFactory.openSession();

        //4.用些对象实现CRUD
        StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);//相当于实例化
        List<Student> students = studentMapper.allStudent();
        for (Student student11:students) {
            System.out.println(student11.toString());
        }


        //5.默认是提交到内存里面的，不会持久化（提交到数据库），所以要手动提交事务
        sqlSession.commit();

        //关闭事务
        sqlSession.close();

    }
    

}