入門案例：
在IDEA中新建了一個普通的java項目徘溢，加入jar包,工程結(jié)構(gòu)如圖。
圖片.png
log4j.properties（在控制臺打印日志团赏，方便查看）
# Global logging configuration
log4j.rootLogger=DEBUG, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
SqlMapConfig.xml（mybatis全局配置文件）
<?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">
<!-- 使用jdbc事務(wù)管理箕般，事務(wù)控制由mybatis-->
<transactionManager type="JDBC"/>
<!-- 數(shù)據(jù)庫連接池,由mybatis管理-->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql:///mybatis001"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
</configuration>
ItemsMapper.xml（映射文件，sql語句）
<?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 命名空間舔清，作用就是對sql進(jìn)行分類化管理,理解為sql隔離
注意：使用mapper代理方法開發(fā)丝里，namespace有特殊重要的作用
-->
<mapper namespace="mapper.ItemsMapper">
<!-- public List<Items> queryItemsById(Integer id);-->
<select id="queryItemsById" parameterType="int" resultType="po.Items">
SELECT * FROM items WHERE id = #{id}
</select>
</mapper>
在sqlMapConfig.xml中加載User.xml
<mappers>
<mapper resource="mapper/ItemsMapper.xml"/>
</mappers>
程序代碼
Items.java
package po;
/**
* Created by admin on 2017/7/1.
*/
public class Items {
private int id;
private String name;
private double price;
private String detail;
@Override
public String toString() {
return "Items{" +
"id=" + id +
", name='" + name + '\'' +
", price=" + price +
", detail='" + detail + '\'' +
'}';
}
//get/set方法省略
}
測試類Test.jav
package test;
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 po.Items;
import java.io.IOException;
import java.io.InputStream;
/**
* Created by admin on 2017/7/1.
*/
public class Test {
@org.junit.Test
public void test01() throws IOException {
String path = "SqlMapConfig.xml";
InputStream inputStream = Resources.getResourceAsStream(path);
//創(chuàng)建會話工廠，傳入mybatis配置文件的信息
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
// 通過工廠得到SqlSession
SqlSession sqlSession = sqlSessionFactory.openSession();
Items list = sqlSession.selectOne("mapper.ItemsMapper.queryItemsById",1);
System.out.println(list);
sqlSession.close();
}
}
查詢結(jié)果
圖片.png
