mybatis学习（一）——快速搭建基于maven的项目

最新推荐文章于 2024-09-20 17:08:50 发布

sadoshi

最新推荐文章于 2024-09-20 17:08:50 发布

阅读量118

点赞数

分类专栏： mybatis

本文链接：https://blog.csdn.net/sadoshi/article/details/118721037

版权

mybatis 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

前言

本次系列文章不打算把mybatis的各项配置解释得清清楚楚。配置细节不单繁琐，而且官网上篇幅也挺多，觉得没必要把官网的东西搬下来，也没必要每个配置项都各种尝试，否则写一百篇文章也讲不清。更想记录的是做项目中一些比较基础的搬砖式代码的，尤其是mybatis查询中的各种例子，省去每次遇到问题还要自己试验半天。

快速开始

新建数据库

首先在mysql数据库中新建一个名为test的schema，然后新建数据表student

CREATE TABLE `student` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `name` varchar(20) NOT NULL,
   `age` int(11) NOT NULL,
   PRIMARY KEY (`id`)
 )

然后我们插入几条测试用的数据

INSERT INTO student(`name`, `age`) VALUE("张三",9);
INSERT INTO student(`name`, `age`) VALUE("李四",10);
INSERT INTO student(`name`, `age`) VALUE("王五",11);

新建java项目

通过集成开发环境新建maven项目。然后在pom.xml添加mybatis依赖：

<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>com.sadoshi.test</groupId>
	<artifactId>mybatisTest</artifactId>
	<version>0.0.1-SNAPSHOT</version>

	<dependencies>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.5.7</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>8.0.25</version>
		</dependency>
	</dependencies>
</project>

在resource目录下添加mybatis的配置文件mybatis-config.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>
	<settings>
		<setting name="logImpl" value="STDOUT_LOGGING" />
	</settings>
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.cj.jdbc.Driver" />
				<property name="url" value="jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=UTF-8" />
				<property name="username" value="root" />
				<property name="password" value="" />
			</dataSource>
		</environment>
	</environments>
	<mappers>
		<mapper class="com.sadoshi.test.mybatisTest.mapper.StudentMapper" />
	</mappers>

</configuration>

接着创建与数据库表对应的实体类Student.class

package com.sadoshi.test.mybatisTest.entity;

public class Student {

	private Integer id;
	private String name;
	private Integer age;
	
	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 + "]";
	}
}

创建操作数据库的Mapper接口StudentMapper：

package com.sadoshi.test.mybatisTest.mapper;

import java.util.List;

import com.sadoshi.test.mybatisTest.entity.Student;

public interface StudentMapper {

	public List<Student> selectAll();
}

创建接口对应的XML文件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 namespace="com.sadoshi.test.mybatisTest.mapper.StudentMapper">
	<select id="selectAll" resultType="com.sadoshi.test.mybatisTest.entity.Student">
		select * from student
	</select>
</mapper>

最后编写主类，然后调用selectAll方法：

package com.sadoshi.test.mybatisTest;

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

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 com.sadoshi.test.mybatisTest.entity.Student;
import com.sadoshi.test.mybatisTest.mapper.StudentMapper;

public class Application {

	public static void main(String[] args) {
		String resource = "mybatis-config.xml";
		InputStream inputStream;
		try {
			inputStream = Resources.getResourceAsStream(resource);
			SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
			try (SqlSession session = sqlSessionFactory.openSession()) {
				StudentMapper studentMapper = (StudentMapper) session.getMapper(StudentMapper.class);
				List<Student> list =studentMapper.selectAll();
				System.out.println(list);
			}
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
}

查看控制台输出：