mybatis配置

1,

<img src="http://img.blog.csdn.net/20161023182226793?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt="" />maven                   <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis</artifactId>            <version>3.2.1</version>        </dependenc>  2, mybatis 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>    <typeAliases>          <typeAlias type="cn.liubingxu.bean.User" alias="User"/>//user的别称    </typeAliases>    <!-- 对事务的管理和连接池的配置 -->     <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/mybatis?serverTimezone=GMT"/>                 <property name="username" value="root" />                 <property name="password" value="admin" />             </dataSource>         </environment>     </environments>                 <mappers>          <mapper resource="cn/liubingxu/bean/User.xml"/>     </mappers> </configuration>3，Mybatis的工具类   用来获取SqlSession import java.io.IOException;import java.io.Reader; import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder; /* * mybatis工具类，来获取session * */public class MybatisUtil {        public static SqlSession getSession() throws IOException{       Reader reader = Resources.getResourceAsReader("cn/liubingxu/mybatis/Config.xml");       SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);       return sessionFactory.openSession();   }  }4,实体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="cn.liubingxu.bean.mapper">    <resultMap type="User" id="result">        <result property="id" jdbcType="INTEGER" column="ID" />        <result property="username" jdbcType="VARCHAR" column="USERNAME" />        <result property="password" jdbcType="VARCHAR" column="PASSWORD" />        <result property="temp" jdbcType="INTEGER" column="TEMP" />     </resultMap>     <sql id='TABLE_NAME'>user</sql>    <insert id="insertUser" useGeneratedKeys="true" keyProperty="id"        parameterType="User">        INSERT INTO        <include refid="TABLE_NAME" />        (USERNAME, PASSWORD, TEMP )        VALUES (#{username}, #{password}, #{temp});    </insert>     <select id="selectUser" resultMap = "result">          select *from user    </select>  </mapper>5，    测试插入数据，取出数据 import java.io.IOException;import java.util.ArrayList;import java.util.Iterator;import java.util.List; import org.apache.ibatis.session.SqlSession; import cn.liubingxu.bean.User;import cn.liubingxu.mybatis.MybatisUtil; public class Test {   public static void main(String args[]) throws IOException {       get();     }       public void insert() throws IOException{      SqlSession sqlsession =  MybatisUtil.getSession();       User user = new User("刘炳旭","123456",1);       System.out.println("user="+user);       sqlsession.insert("cn.liubingxu.bean.mapper.insertUser", user);       if(sqlsession!=null){        System.out.println("ok");        sqlsession.commit();        sqlsession.close();       }   }     public static void get() throws IOException{      SqlSession sqlsession =  MybatisUtil.getSession();      User user = null;      List list = new ArrayList<User>();       list = sqlsession.selectList("cn.liubingxu.bean.mapper.selectUser");       System.out.println("user="+list);      if(sqlsession!=null){        System.out.println("查询结束");        sqlsession.commit();        sqlsession.close();      }   }}推荐学习网站：             http://www.tutorialspoint.com/mybatis/index.htm          http://www.mybatis.org/mybatis-3/getting-started.html

来自：http://www.liubingxu.cn/ckwzby?id=17#0-qzone-1-19443-d020d2d2a4e8d1a374a433f596ad1440