Eclipse利用Maven快速上手搭建MyBatis

　　2.1、直接下载(需jdk1.7或更高)

地址：直接下载

　　2.2、官网下载：http://maven.apache.org/download.cgi

　　2.3、Maven与Eclipse关联

     <dependencies>
         <!-- 添加MyBatis框架3.4.6版本 -->
         <dependency>
             <groupId>org.mybatis</groupId>
             <artifactId>mybatis</artifactId>
             <version>3.4.6</version> <!-- 版本号视情况修改 -->
         </dependency>
         <!-- 添加MySql驱动包 -->
         <dependency>
             <groupId>mysql</groupId>
             <artifactId>mysql-connector-java</artifactId>
             <version>5.1.25</version>
         </dependency>
     </dependencies>

 <?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/sam" /> <!-- 连接字符串 -->
                 <property name="username" value="root" /> <!-- 用户名 -->
                 <property name="password" value="root" /> <!-- 密码 -->
             </dataSource>
         </environment>
     </environments>
     <mappers>
         <mapper resource="DeptMapper.xml" /> <!-- 映射SQL语句的XML文件 -->
     </mappers>
 </configuration>

 <?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="Dept">
     <!-- 插入单个部门信息 -->
     <insert id="InsertDept">
 INSERT INTO DEPT (DNAME,LOC)
 VALUES (#{DName},#{Loc})
     </insert>
 </mapper>

 <insert id="insertAuthor">
 insert into Author (id,username,password,email,bio)
 values (#{id},#{username},#{password},#{email},#{bio})
 </insert>
 
 <update id="updateAuthor">
   update Author set
     username =#{username},
     password =#{password},
     email =#{email},
     bio =#{bio}
   where id =#{id}
 </update>
 
 <delete id="deleteAuthor">
   delete from Author where id =#{id}
 </delete>

 package com.chenyanbin;
 
 public classDept {
     //部门名称
     privateString DName;
     //部门位置
     privateString Loc;
     publicString getDName() {
         returnDName;
 }
     public voidsetDName(String dName) {
         DName =dName;
 }
     publicString getLoc() {
         returnLoc;
 }
     public voidsetLoc(String loc) {
         Loc =loc;
 }
 }

 package com.chenyanbin;
 
 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 classTestMain {
     public static voidmain(String[] args) throws IOException {
         //创建实体类
         Dept dept = newDept();
         dept.setDName("上海事业部");
         dept.setLoc("上海");
         //加载XML文件
         InputStream is = Resources.getResourceAsStream("myBatis-config.xml"); //加载MyBatis的配置文件
         //初始化SqlSessionFactory
         SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
         SqlSession session =factory.openSession();
         session.insert("InsertDept", dept);
 session.commit();
 session.close();
 }
 }