MyBatis学习01-环境搭建

一、MyBatis环境搭建

        1.引入jar包

          

       2.创建全局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="default">
  		<environment id="default">
  			<transactionManager type="JDBC"></transactionManager>
  			<dataSource type="POOLED">
  				<property name="driver" value="com.mysql.jdbc.Driver"/>
  				<property name="url" value="jdbc:mysql://localhost:3306/数据库名"/>
  				<property name="username" value=" "/> //用户名
  				<property name="password" value=" "/> //密码
  			</dataSource>
  		</environment>
  	</environments>
  	<mappers>
  		<mapper resource="此处填写创建mapper.xml文件的位置"/>
  	</mappers>
  
  </configuration>

       3.创建Mapper.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.yyl.mapper">
  	<select id="方法名" resultType="查询返回结果的类型" >
             此处直接填写sql语句
    </select>
  </mapper>