Eclipse搭建Mybatis框架

一、搭建环境及工具准备

1.java 开发环境:JDK1.8 及以上
2.java 开发工具:eclipse
3.数据库服务器:MySQL
4数据库管理工具:navcat

二、搭建详细步骤

1.创建工程并添加Jar包(mybatis jar包下载地址:https://github.com/mybatis/mybatis-3/release,数据库jar包MySQL :: Download Connector/J

 

2.添加MyBatis核心配置文件

新建一个和src类型的resource文件用于存放MyBatis核心配置文件

 

 

 需修改成自己的数据库信息 url、username、password

<?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.cj.jdbc.Driver" />
			<property name="url" value="jdbc:mysql://localhost:3306/mybatis" />
			<property name="username" value="root" />
			<property name="password" value="123456" />
		</dataSource>
	</environment>
</environments> 
<mappers>
   <mapper resource="UserMapper.xml" />
</mappers>
</configuration>

3.创建实体类

这里数据库表的属性需要与实体类的属性一致!!!
package user;

public class User {
private int age;
private String name;
private String passwordString;
public int getAge() {
	return age;
}
public void setAge(int age) {
	this.age = age;
}
public String getName() {
	return name;
}
public void setName(String name) {
	this.name = name;
}
public String getPasswordString() {
	return passwordString;
}
public void setPasswordString(String passwordString) {
	this.passwordString = passwordString;
}
}

4创建SQL映射文件

id属性:表示该SQL语句的唯一标识符
resultType属性:填写全类名,表示SQL语句返回值类型,此处通过SQL语句查询数据,将数据直接映射到User实体类上
<?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="/">
        <!-- SQL映射写在这里 -->
        <select id="findAllUser" resultType="domain.User">
		select * from user
</select>

</mapper>

5.创建Junit,代码测试,输出结果

 创建TestUser类

package test;

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 org.junit.*;
import domain.User;
public class UserTest {
@Test
public void findUser() throws IOException {
	//1.加载mybatis核心配置文件
	InputStream inputStream = Resources.getResourceAsStream("mybatis_config.xml");
	//2.获取SqlSessionFactory对象
	SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
	//3.得到执行sql的对象SqlSession 
	SqlSession sqlSession = sqlSessionFactory.openSession();
	//4.执行sql语句
	List<User> list = sqlSession.selectList("findAllUser");
	//5.处理结果
	for (User user: list) {
	System.out.println("用户名:"+user.getName()+",密码:"+user.getPassword()+"年纪:"+user.getAge());
	}
	//6.关闭数据库会话
	sqlSession.close();
}
	

}

 


版权声明:本文为qq_57166811原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。