mybatis入门第一个例子

eclipse中的目录，仅供参考：

 

测试类：

package com.wfl.mybatis.test1;

import java.io.IOException;
import java.io.Reader;

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.apache.log4j.lf5.util.Resource;

import com.wfl.mybatis.bean.User;

public class Test {
    public static void main(String[] args) throws IOException{
     String resource="conf.xml";
     //加载mybatis的配置文件（它也加载关联的映射文件）
     Reader reader=Resources.getResourceAsReader(resource);
     //构建sqlsession的工厂
     SqlSessionFactory sessionFactory=new SqlSessionFactoryBuilder().build(reader);
     //创建能执行映射文件中sql的sqlSession
     SqlSession session=sessionFactory.openSession();
     //映射sql的标识字符串  (Mapper中的namespace加上id)
     String statement ="com.wfl.mybatis.bean.userMapper.getUser";
     //执行查询，返回一个唯一user对象的sql
     User user=session.selectOne(statement,1);
     System.out.println(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">
<!-- namespace此处取包名和文件名，起到唯一标识的作用 -->
<mapper namespace="com.wfl.mybatis.bean.userMapper">
<!-- id 名是       传入的参数类型是INT，  返回的结果类型是user类 -->
  <select id="getUser" parameterType="int"
           resultType="com.wfl.mybatis.bean.User">
           select * from users where id=#{id};
  </select>
  <!-- <insert id="insertUser"  parameterType="int" >
    insert into users(name,age) values(#{name},#{age});
  </insert>
 
   <delete id="deleteUser"  parameterType="int" >
    delete  from users where id=#{id}
  </delete>
 
  <update id="updateUser"  parameterType="com.wfl.mybatis.bean.User" >
    update users set name=#{name},age=#{age} where id=#{id}
  </update>
 
   <select id="selectAllUser"  resultType="com.wfl.mybatis.bean.User">
           select * from users
  </select> -->
</mapper>

 

配置文件

<?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="com/wfl/mybatis/bean/userMapper.xml"/>
   </mappers>
 </configuration>
 
 
实体类

package com.wfl.mybatis.bean;

public class User {

 private int id;
 private String name;
 private int age;
 @Override
 public String toString() {
  return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
 }
 public User(int id, String name, int age) {
  super();
  this.id = id;
  this.name = name;
  this.age = age;
 }
 public User(){}
 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;
 }
}

 

建立数据库

以上有些地方容易出错，请看我另外一篇文章：

https://blog.csdn.net/fulong0406/article/details/90670274