mybatis 配置和用法

Mybatis 配置 mybatis.xml
mybatis配置文件jdbc-config.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///oa_db
jdbc.username=root
jdbc.password=****

Mybatis 配置 mybatis.xml

<!-- development 开发模式；work：工作模式 -->
<!-- 导入连接数据库的基本信息 -->
<properties resource="jdbc-config.properties"></properties>

<!-- log4j -->
<settings>
	<setting name="mapUnderscoreToCamelCase" value="true" />
	<setting name="logImpl" value="LOG4J" />
</settings>

<!-- javaBean的路径 -->
<typeAliases>
	<package name="com.znsd.mybatis.bean" />
</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>

<!-- 装载Mapper实现文件 -->
<mappers>

	<!-- <mapper resource="com/javaee/mybatis/mapper/BooksMapper.xml" /> <mapper 
		class="com.javaee.mybatis.dao.BooksDao"/> -->
	<mapper resource="com/znsd/oa/bean/xml/Mapper.xml" />
</mappers>

dao 层
查询某个表里面的所有数据

InputStream input = null;
try {
	input = Resources.getResourceAsStream("mybatis的xml配置文件");
	SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(input);
	SqlSession session = sf.openSession();
	List<Leave> list = session.selectList("放入sql语句");
	System.out.println(list);
} catch (IOException e) {
	e.printStackTrace();
}

xml里面的sql语句

<select id="select" resultType="com.znsd.oa.bean.Leave">
        select * from tbl_leave
</select>

这样就完成了