我的mybatis第一个简单实例

我的mybatis第一个简单实例

1、新手菜鸟上路，第一个mybatis简单实例，完成一个数据库的简单查询。
2、采用maven项目导入依赖。
3、通过测试类测试数据库的查询。

下面开始步骤，首先配置好pom文件的依赖

<dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
    
    <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
    </dependency>
    
    <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
    </dependency>
    
    
	<dependency>
	  <groupId>org.slf4j</groupId>
	  <artifactId>slf4j-api</artifactId>
	  <version>1.7.4</version>
	</dependency>
	
	
	<dependency>
	  <groupId>org.slf4j</groupId>
	  <artifactId>slf4j-log4j12</artifactId>
	  <version>1.7.5</version>
	  <scope>test</scope>
	</dependency>
    
    <dependency>
		<groupId>log4j</groupId>
		<artifactId>log4j</artifactId>
		<version>1.2.16</version>
	</dependency>

然后编写mybatis的配置，在resource目录下创建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="LOG4J" />
	</settings>
 
	<!-- 和spring整合后 environments配置将废除 -->
	<environments default="development">
		<environment id="development">
			<!-- 使用jdbc事务管理 -->
			<transactionManager type="JDBC" />
			<!-- 数据库连接池 -->
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver" />
				<property name="url"
					value="jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8" />
				<property name="username" value="root" />
				<property name="password" value="root" />
			</dataSource>
		</environment>
	</environments>
 
	<mappers>
		<mapper resource="cn\tecsun\Entity\Student.xml" />
	</mappers>
 
</configuration>

mybatis整合log4j。需要创建一个log4j.properties配置文件，在resource目录下创建，并把以下内容添加进去。

log4j.rootLogger=DEBUG,Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.org.apache=INFO

下一步就是编写实体了，例如编写一个学生Student的实体类

public class Student {
	private int id;
	private int studentID;
	private String name;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public int getStudentID() {
		return studentID;
	}
	public void setStudentID(int studentID) {
		this.studentID = studentID;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	@Override
	public String toString() {
		return "Student [id=" + id + ", studentID=" + studentID + ", name=" + name + "]";
	}


}

再编写一个Mapper的接口，StudentMapper。

public interface StudentMapper {
	public Student listStudent(String name);
}

再一个就是创建一个Student的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="cn.tecsun.Entity.StudentMapper">//namespace对应的就是上面创建的StudentMapper的路径
    <select id="listStudent" resultType="cn.tecsun.Entity.Student">//resultType则是设置查询返回的类型为Student，是上面所创建的实体学生的类。
        select * from  student
        where name = #{name}
    </select>
</mapper>

最后一个就是测试类。

public class TestMybatis {
	
	@Test
	public void findUserById(){
		SqlSession sqlSession = getSessionFactory().openSession();  
		StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);  
		Student student = studentMapper.listStudent("jack2");
		System.out.println(student);
	}
	
	
	// Mybatis 通过SqlSessionFactory获取SqlSession, 然后才能通过SqlSession与数据库进行交互
	private static SqlSessionFactory getSessionFactory() {
		SqlSessionFactory sessionFactory = null;
		String resource = "mybatis-config.xml";
		try {
			sessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader(resource));
		} catch (IOException e) {
			e.printStackTrace();
		}
		return sessionFactory;
	}

}

下面再看一下结果，如下图：

数据库简单设计