直接上代码
1. SqlMapConfig.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>
<!-- 加载属性文件 -->
<properties resource="db.properties" />
<typeAliases>
<!-- <typeAlias type="com.jx.pojo.Order" alias="order"/>
<typeAlias type="com.jx.pojo.User" alias="user"/> -->
<!-- <package name="com.jx.pojo"/> -->
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper class="com.jx.annocation.OrderMapper"/>
<mapper class="com.jx.annocation.UserMapper"/>
</mappers>
</configuration>
2. db.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/zhjsdb?characterEncoding=UTF-8
jdbc.username=root
jdbc.password=root
3. 新建一个包存放接口
@Select、@Delete ...
package com.jx.annocation;
import org.apache.ibatis.annotations.Select;
import com.jx.pojo.Order;
public interface OrderMapper {
@Select("Select * from tbl_order where id = #{id}")
public Order getOrderById(int id);
}
编写测试类
package com.jx.sx;
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;
import org.junit.Test;
import com.jx.annocation.OrderMapper;
import com.jx.pojo.Order;
public class TestOrder {
public SqlSessionFactory getSqlSessionFactory() throws IOException{
//myBatis 配置文件
String source = "SqlMapConfig.xml";
//得到配置文件流
InputStream inputStream = Resources.getResourceAsStream(source);
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
inputStream.close();
return factory;
}
@Test
public void findUserByIdTest() throws IOException {
SqlSession session = this.getSqlSessionFactory().openSession();
OrderMapper mapper = session.getMapper(OrderMapper.class);
Order order = mapper.getOrderById(1);
System.out.println(order);
session.close();
}
}