mybatis【完整案例】

结构

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>sxt.com</groupId>
	<artifactId>mybatis-05-interface</artifactId>
	<version>0.0.1-SNAPSHOT</version>

	<dependencies>
		<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.27</version>
		</dependency>
	</dependencies>

</project>

全局配置文件

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/1227?characterEncoding=utf-8"/>
        <property name="username" value="root"/>
        <property name="password" value="1999"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
	<mapper resource="com/sxt/dao/UserMapper.xml"/>
  </mappers>
</configuration>

创建映射文件

UserMapper.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.sxt.dao.IUserDao">
  	<select id="query" resultType="com.sxt.pojo.User">
  		select * from t_user
  	</select>
  	<insert id="insert" parameterType="com.sxt.pojo.User">
  		insert into t_user(username,password,age,address)
  		 values(#{username},#{password},#{age},#{address})
  	</insert>
  	<update id="update" parameterType="com.sxt.pojo.User">
  		update t_user set 
  		username=#{username},password=#{password},age=#{age},address=#{address} 
  		where id=#{id}
  	</update>
  	<delete id="delete">
  		delete from t_user where id=#{id}
  	</delete>
  </mapper>

放在dao层，名字和接口一致，可以省略dao层接口的实现类

User对象

package com.sxt.pojo;

public class User {

	private Integer id;
	private String username;
	private String password;
	private Integer age;
	private String address;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public Integer getAge() {
		return age;
	}
	public void setAge(Integer age) {
		this.age = age;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + ", password=" + password + ", age=" + age + ", address="
				+ address + "]";
	}
	
}

dao层接口

package com.sxt.dao;

import java.util.List;

import com.sxt.pojo.User;

public interface IUserDao {

	public List<User> query();
	
	public int insert(User user);
	
	public int update(User user);
	
	public int delete(Integer id);
}

代理类

package com.sxt.utils;

import java.io.IOException;
import java.io.InputStream;

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 Dbutils {

	public static SqlSession getSession(){
		InputStream in;
		try {
			in = Resources.getResourceAsStream("mybatis-config.xml");
			SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
			return factory.openSession();
		} catch (IOException e) {
			e.printStackTrace();
		}
		return null;
	}
}

测试

package com.sxt.test;

import java.util.List;

import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import com.sxt.dao.IUserDao;
import com.sxt.pojo.User;
import com.sxt.utils.Dbutils;

public class TestCrud {

	@Test
	public void test() {
		SqlSession session = Dbutils.getSession();
		IUserDao userDao = session.getMapper(IUserDao.class);
		List<User> list = userDao.query();
		for (User user : list) {
			System.out.println(user);
		}
	}

}