《Spring+Mybatis》Mybatis简单注解配置的用法学习笔记与代码

mybatis-config.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>
<!-- 
  <settings>
    <setting name="useGeneratedKeys" value="false"/>
    <setting name="useColumnLabel" value="true"/>
  </settings>

  <typeAliases>
    <typeAlias alias="UserAlias" type="org.apache.ibatis.submitted.complex_property.User"/>
  </typeAliases> -->
  <!-- 指定mybatis所用日志的具体实现 -->
  <settings>
  	<setting name="logImpl" value="LOG4J"/>
  </settings>
  
  <!-- 环境配置及连接的数据库 -->
  
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC">
        <property name="" value=""/>
      </transactionManager>
      <dataSource type="UNPOOLED">
        <property name="driver" value="com.mysql.jdbc.Driver"/>
        
        <!-- 连接数据多加中文编码连接 -->
        <property name="url" value="jdbc:mysql://127.0.0.1:3306/mybatis?characterEncoding=utf8"/>
        <property name="username" value="root"/>
        <property name="password" value=""/>
      </dataSource>
    </environment>
  </environments>
  <!-- 在哪里找持久化类的配置文件 -->
<mappers>
	<!-- 注解配置时引入java接口 -->
	<mapper class="org.mybatis.mapper.UserAnnotation"/> 
 
   <!--  <mapper resource="org/mybatis/mapper/UserMapper.xml"/> -->
    <!--  <mapper resource="com/imooc/config/sqlxml/Command.xml"/>
    <mapper resource="com/imooc/config/sqlxml/CommandContent.xml"/>-->
  </mappers>  

</configuration>

sql语句在java接口书写基本规范

package org.mybatis.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.mybatis.domain.User;

public interface UserAnnotation {
	
	@Insert("INSERT INTO TB_USER(name,sex,age) VALUES(#{name},#{sex},#{age})")
	@Options(useGeneratedKeys=true,keyProperty="id")
//	@SelectKey(before=false,keyProperty="id",resultType=Integer.class,
//	statement="SELECT LAST_INSERT_ID() AS id")
	int saveUser(User user);
	
	@Delete("DELETE FROM TB_USER WHERE id = #{id}")
	int removeUser(@Param("id") Integer id);
	
	@Update("UPDATE TB_USER SET name = #{name},sex = #{sex},age = #{age} WHERE id = #{id}")
	void modifyUser(User user);
	
	@Select("SELECT * FROM TB_USER WHERE id = #{id}")
	@Results({
		@Result(id=true,column="id",property="id"),
		@Result(column="name",property="name"),
		@Result(column="sex",property="sex"),
		@Result(column="age",property="age")
	})
	User selectUserById(@Param("id") Integer id);
	
	@Select("SELECT * FROM TB_USER ")
	List<User> selectAllUser();

}

测试调用：

package org.mybatis.test;

import java.io.IOException;

import org.apache.ibatis.session.SqlSession;
import org.mybatis.db.MybatisDbutil;
import org.mybatis.domain.User;
import org.mybatis.mapper.UserAnnotation;

public class UserAnnotationTest {
	public static void main(String[] args) throws IOException {
		MybatisDbutil  dbutil=new MybatisDbutil();//如果不是定义的静态方法，就要创建对象
		SqlSession session=dbutil.getSqlSession();//获得session实例
		UserAnnotation um=session.getMapper(UserAnnotation.class);//创建UserAnnotation实例
		User   user=new  User();
		user.setName("test");
		user.setSex("男");
		user.setAge(666);
		//插入数据
		um.save(user);
		System.out.println(user.getAge());
		session.commit();//mybatis的事务需要手动提交
		session.close();
	}

}




控制台输出：
2018-02-07 12:12:55,655 [main] DEBUG [org.mybatis.mapper.UserAnnotation.save] - ==>  Preparing: insert into tb_user(name,sex,age) values(?,?,?) 
2018-02-07 12:12:55,709 [main] DEBUG [org.mybatis.mapper.UserAnnotation.save] - ==> Parameters: test(String), 男(String), 666(Integer)
2018-02-07 12:12:55,731 [main] DEBUG [org.mybatis.mapper.UserAnnotation.save] - <==    Updates: 1
666