MyBatis 消除了几乎所有的JDBC代码和参数的手工设置以及结果集的检索。MyBatis 使用简单的 XML或注解用于配置和原始映射，将接口和 Java 的POJOs（Plain Old Java Objects，普通的 Java对象）映射成数据库中的记录。
SQL
（sessionfactory
在java对象和数据库之间有做mapping
各种技术在MVC中的位置如下图：
下面贴出源代码：
MyBatisConfig.xml
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN"""><configuration> <environments default="development"><environment id="development"><transactionManager type="JDBC"></transactionManager><dataSource type="POOLED"><property name="driver" value="com.mysql.jdbc.Driver"/><property name="url" value="jdbc:mysql://localhost:3306/jikebook"/><property name="username" value="root"/><property name="password" value="root"/></dataSource></environment> </environments> <mappers><mapper resource="jike/book/map/jikeUser.xml"/> </mappers></configuration>
Student.xml
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"""><mapper namespace="/"> <select id="findById" parameterType="int" resultType="com.hanchun.pojo.Student">select * from management where id=#{id} </select></mapper>Student.java
package com.hanchun.pojo;/** *Student注意和数据库对应的表写成一一对应，，否则会返回null值 */public class Student {private int id;private String stu_name;private String stu_age;public int getId() {return id;}public void setId(int id) {this.id = id;}public String getStu_name() {return stu_name;}public void setStu_name(String stu_name) {this.stu_name = stu_name;}public String getStu_age() {return stu_age;}public void setStu_age(String stu_age) {this.stu_age = stu_age;}}
Test.java
package com.hanchun.test;import java.io.IOException;import java.io.Reader;import com.hanchun.pojo.Student;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;public class Test{public static void main(String[] args) {// 注意写成路径的形式String resource = "com/hanchun/map/MyBatisConfig.xml";Reader reader = null;SqlSession session;try {reader = Resources.getResourceAsReader(resource);} catch (IOException e) {e.printStackTrace();}SqlSessionFactory sqlMapper = new SqlSessionFactoryBuilder().build(reader);session = sqlMapper.openSession();Student temp = session.selectOne("findById", 3);System.out.println(temp.getStu_name());session.close();}}
最后程序运行结果：
欢迎讨论：
版权声明：本文为博主原创文章，未经博主允许不得转载。
木已成舟便要顺其自然
