Mybatis的快速入门（HelloWorld）----------仅供参考,如有不懂请看官方文档

如果看不懂请看官方文档仅供参考

https://mybatis.org/mybatis-3/zh/index.html(官方文档)

下面有源码

能看到这里相信大家的Java已经学习了挺长时间了，肯定不会以为HelloWorld是简单的你好，世界或者是在刚入门的时候最简单的HelloWorld。

带大家重温一下经典

public class HelloWorld{
    public static void main(String args[]){
        System.out.println("HelloWorld");
    }
}

这个的输出肯定就是“HelloWorld”

---

回归正题

1.创建数据库,表,并添加一条数据

create database test1;

use test1;

create table t_user(
	`id` primary key auto_increment,
	`last_name` varchar(20),
	`gender`varchar(10),
	email varchar(50)
)

2.创建一个java工程mybatis

2.1创建对应的javaBean

package mybatis.bean;

public class User {
	private Integer id;
	private String lastName;
	private String gender;
	private String email;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getLastName() {
		return lastName;
	}
	public void setLastName(String lastName) {
		this.lastName = lastName;
	}
	public String getGender() {
		return gender;
	}
	public void setGender(String gender) {
		this.gender = gender;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	@Override
	public String toString() {
		return "user [id=" + id + ", lastName=" + lastName + ", gender=" + gender + ", email=" + email + "]";
	}
	
	
}

 2.2创建lib文件并导包

一共三个包

log4j.jar -->将查询过程打印到控制台

mybatis-3.4.1.jar  --> mybatis框架包

mysql-connector-java-5.1.37-bin.jar -->数据库驱动

2.3在根目录下创建conf文件夹,用来放置xml文件

log4j.xml  -->将查询过程打印到控制台

mybatis-config.xml ==>XML 配置文件中包含了对 MyBatis 系统的核心设置，包括获取数据库连接实例的数据源（DataSource）以及决定事务作用域和控制方式的事务管理器（TransactionManager）。

<?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>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/test1"/>
        <property name="username" value="root"/>
        <property name="password" value="123456"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="MybatisMapper.xml"/>
  </mappers>
</configuration>

里面需要改的

自己数据库的url,username,password

resource:第三个文件的全名称

MybatisMapper.xml==>探究已映射的 SQL 语句

<?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="mybatis.UserMapper">
<!--  namespace:名称空间
	  id:唯一标识
	  resultType:返回值类型
	   #{id}:从传出来的参数中取出id值
 -->
  <select id="selectUser" resultType="mybatis.bean.User">
    select id,last_name lastName,gender,email from t_user where id = #{id}
  </select>
</mapper>

  namespace:名称空间
      id:唯一标识
      resultType:返回值类型
       #{id}:从传出来的参数中取出id值

3.测试

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

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 mybatis.bean.User;

public class mybatisTest {

	public static void main(String[] args) throws IOException {
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
		//获取SQLSession实例,能直接执行已经映射的sql语句
		SqlSession openSession = sqlSessionFactory.openSession();
		//sql语句的唯一标识符:statement Unique identifier matching the statement to use.
		//执行sql语句要用的参数:statement Unique identifier matching the statement to use.
		try {	
			User user = openSession.selectOne("selectUser", 1);
			System.out.println(user);
			}finally {
			openSession.close();
		}
	
		
	}
}

4.运行结果

---

---

源码+jar包(百度网盘)

链接：https://pan.baidu.com/s/1A3AT4gbjBEiaFp2_VglPIg 
提取码：1234 

酒枯推荐

       本周推荐学习: SSM (Spring + SpringMVC+Mybatis)

       推荐学习视频链接: https://www.bilibili.com/video/BV1Bg4y1q7q2