MyBatis框架使用（一）

首先声明下：下面大部分代码取自传智播客视频。

以下代码尽供参考，学习之用。若有问题请联系本人。qq362601125

首先整个工程的结构图如下所示：

Mybatis一共有两个配置文件：myBatis-config.xml和实体类对应的XXXMapper.xml文件（这里以StudentMapper.xml为例）

Mybatis文件存放在src目录下

StudentMapper.xml和实体类Student在同一个目录下

整体的结构就是这个样子。

首先创建实体类Student:

package com.robert.Bean;public class Student {private int id;private String name;private int age;private String birthday;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 String getBirthday() {return birthday;}public void setBirthday(String birthday) {this.birthday = birthday;}public String toString() {return "id="+id+"\tname="+name+"\tage="+age+"\tbirthday="+birthday;}}

Student对应的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.robert.Bean.Student">    <select id="selectStudents" resultType="com.robert.Bean.Student">    select * from Student;  </select></mapper>

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>  <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/test"/>        <property name="username" value="root"/>        <property name="password" value="root"/>      </dataSource>    </environment>  </environments>  <mappers>    <mapper resource="com/robert/Bean/StudentMapper.xml"/>  </mappers></configuration>

测试程序如下：

package com.robert.test.Student;import java.io.IOException;import java.io.Reader;import java.util.List;import org.apache.ibatis.io.*;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import com.robert.Bean.*;public class StudentTest {public static void main(String[] args){String resource = "myBatis-config.xml";Reader reader = null;try {reader = Resources.getResourceAsReader(resource);SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);SqlSession session = sessionFactory.openSession();List<Student> students = session.selectList("selectStudents"); for(Student stu:students){System.out.println(stu);}reader.close();session.close();} catch (IOException e) {e.printStackTrace();}finally{try {reader.close();} catch (IOException e) {e.printStackTrace();}}}}

！！！

注意：在工程中要加入mysql驱动和mybatis.jar

建表的语句如下：

应该没什么问题了。

javaQQ交流群3728967，欢迎加入。