Mybatis环境搭建和使用实例代码

<dependency>
 <groupId>org.mybatis</groupId>
 <artifactId>mybatis</artifactId>
 <version>3.4.5</version>
</dependency>　

<?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="${driver}"/>
 <property name="url" value="${url}"/>
 <property name="username" value="${username}"/>
 <property name="password" value="${password}"/>
 </dataSource>
 </environment>
 </environments>
 <mappers>
 <mapper resource="org/mybatis/example/BlogMapper.xml"/>
 </mappers>
</configuration>

sqlDriver:com.mysql.jbdc.Driver
sqlUrl:mysql:jbdc://172.20.60.2/spectergk?useUnicode=true&characterEncoding=UTF8
sqlUserName:test
sqlUserPwd:111111

public void functionTest(){
 //System.out.println("开始做mybatis");
 InputStream inputStream = null;
 try {<br data-filtered="filtered">　　　　　　　　inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");
 } catch (IOException e) {
 // TODO Auto-generated catch block
 e.printStackTrace();
 }
 /*
 * 创建工厂
 */
 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
 /*
 * 打开ssion
 */
 SqlSession sqlSession = sqlSessionFactory.openSession();
 System.out.println(sqlSession);
 sqlSession.close();
 try {
 inputStream.close();
 } catch (IOException e) {
 // TODO Auto-generated catch block
 e.printStackTrace();
 } 
 }

<!--下面是对com.spectergk.mybatis.pojo.User的包名起别名--!>
<typeAliases>
<typeAlias type="com.spectergk.mybatis.pojo.User" alias="User"/>
</typeAliases>
<!--加载映射资源--!>
<mappers>
<mapper resource="User.xml"/>
</mappers>

<?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 指向的包为UserMapper接口 这是实现动态代理的条件之一 -->
<mapper namespace="com.spectergk.mybatis.mappers.UserMapper">
<!-- 这里配置的返回值是User 这是因为在sqlMappersConfig.xml 已经配置了其重命名 -->
<!-- 根据用的id来查询用户 返回值是User 传的值为parameterType -->
 <select id="selectUserById" resultType="User" parameterType="String">
 select * from user where uid = #{v}
 </select>
 <!-- 根据用户的用户名进行模糊查询 -->
 <select id="selectUsersbyUserName" resultType="User" parameterType="String">
 select * from user where realname like "%"#{v}"%";
 </select>
 <!-- 向数据库里面插入数据 -->
 <insert id="insertOneUser" parameterType="User">
 INSERT into user(uid,username,realname,mobile,mainpid,sex) values(#{uid},#{username},#{realname},#{mobile},#{mainpid},#{sex});
 </insert>
 <!-- 插入数据并且返回的自动生成的uid -->
 <insert id="insertOneUserGetid" parameterType="User">
 <selectKey keyProperty="uid" keyColumn="uid" resultType="String" order="AFTER">
 SELECT LAST_INSERT_ID()
 </selectKey>
 INSERT into user(username,realname,mobile,mainpid,sex) values(#{username},#{realname},#{mobile},#{mainpid},#{sex});
 </insert>
 <!-- 以list的形式插入 -->
 <insert id="insetUsers" >
 INSERT into user(uid,username,realname,mobile,mainpid,sex) values
 <foreach collection="list" item="item" separator=",">
 (#{item.uid},#{item.username},#{item.realname},#{item.mobile},#{item.mainpid},#{item.sex})
 </foreach>
 </insert>
 <!-- 以数组的形式插入 -->
 <insert id="insetUsersArray" >
 INSERT into user(uid,username,realname,mobile,mainpid,sex) values
 <foreach collection="array" item="item" separator=",">
 (#{item.uid},#{item.username},#{item.realname},#{item.mobile},#{item.mainpid},#{item.sex})
 </foreach>
 </insert>
 <!-- 更新用户 -->
 <update id="updateUser" parameterType="User">
 UPDATE user set username = #{username} where uid = #{uid}
 </update>
 <!-- 删除用户 -->
 <delete id="deleteOneUser" parameterType="String">
 delete from user where uid = #{v}
 </delete>
 <delete id="deleteMoreUsers">
 delete from user where uid in (
 <foreach collection="list" item="item" separator=",">
 #{item}
 </foreach>
 )
 </delete>
</mapper>

package com.spectergk.mybatis.mappers;
import java.util.List;
import com.spectergk.mybatis.pojo.User;
public interface UserMapper {
 /*
 * 根据用户的id查询
 */
 public User selectUserById(String id);
 /*
 * 根据用户的姓名 模糊查询
 */
 public List<User> selectUsersbyUserName(String username);
 /*
 * 插入一个用户
 */
 public void insertOneUser(User user);
 /*
 * 插入一个用户 并且返回插入的user的id
 */
 public void insertOneUserGetid(User user);
 /*
 * 插入多个用户
 */
 public void insetUsers(List<User> users);
 /*
 * 插入多个用户 这里传输array 
 */
 public void insetUsersArray(User[] users);
 /*
 * updateUser 更新
 */
 public void updateUser(User user);
 /*
 * 删除一个
 */
 public void deleteOneUser(String uid);
 /*
 * deleteMoreUsers删除多个
 */
 public void deleteMoreUsers(List<String> uids);
}

//根据用户名 模糊查询查询
 public void fuzzysearch(){
 System.out.println("开始做mybatis");
 InputStream inputStream = null;
 try {
 inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");
 } catch (IOException e) {
 // TODO Auto-generated catch block
 e.printStackTrace();
 }
 /*
 * 创建工厂
 */
 this.sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
 /*
 * 打开ssion
 */
 SqlSession sqlSession = this.sqlSessionFactory.openSession();
 System.out.println(sqlSession);
 UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
 List<User> users = userMapper.selectUsersbyUserName("刘");
 for (User user : users) {
 System.out.println(user);
 }
 sqlSession.close(); 
 }