2 Star 1 Fork 0

zhrun8899 / learning-notes

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
mybatis.md 4.14 KB
一键复制 编辑 原始数据 按行查看 历史
zhrun8899 提交于 2019-01-31 14:05 . 20190131

显示sql

application.properties(yml)中配置的两种方式:

1. logging.level.yourdaoclasspackagename=debug

2. mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

这两种方式的效果是一样的,但是上面一种可以指定某个包下的SQL打印出来,下面这个会全部的都会打印出来。

普通mybatis实现: 1.加载配置文件

inputStream = Resources.getResourceAsStream("mybatis-config.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

2.取得session sqlSession sqlSession=sqlSessionFactory().openSession(); 3.取得mapper StudentMapper studentMapper =sqlSession.getMapper(StudentMapper.class); 4.操作数据 studentMapper.findAllStudents();


==========================================
mybatis:
trim:
1.用于select的语句中
<trim prefix="WHERE" prefixOverrides="AND | OR">
<if test="business_no != null ">
	and business_no=#{business_no}
</if>
</trim>
2.用于insertSelective中语句中
<trim prefix="(" suffix=")" suffixOverrides=",">
			<if test="orderNo != null">
				orderNo,
			</if>
			<if test="merchantId != null">
				merchant_id,
			</if>
		</trim>
		<trim prefix="values (" suffix=")" suffixOverrides=",">
			<if test="orderNo != null">
				#{orderNo,jdbcType=VARCHAR},
			</if>
			<if test="merchantId != null">
				#{merchantId,jdbcType=VARCHAR},
			</if>

		</trim>
<set> 用于updateSelective中
update orders_inf
<set>
			<if test="merchantId != null">
				merchant_id = #{merchantId,jdbcType=VARCHAR},
			</if>
			<if test="cardNo != null">
				cardNo = #{cardNo,jdbcType=VARCHAR},
			</if>
		</set>
	where payNo = #{payNo,jdbcType=VARCHAR}

============================================================
=================================================================================
public TypeAliasRegistry() {
    registerAlias("string", String.class);

    registerAlias("byte", Byte.class);
    registerAlias("long", Long.class);
    registerAlias("short", Short.class);
    registerAlias("int", Integer.class);
    registerAlias("integer", Integer.class);
    registerAlias("double", Double.class);
    registerAlias("float", Float.class);
    registerAlias("boolean", Boolean.class);
     
    registerAlias("byte[]", Byte[].class);
    registerAlias("long[]", Long[].class);
    registerAlias("short[]", Short[].class);
    registerAlias("int[]", Integer[].class);
    registerAlias("integer[]", Integer[].class);
    registerAlias("double[]", Double[].class);
    registerAlias("float[]", Float[].class);
    registerAlias("boolean[]", Boolean[].class);
     
    registerAlias("_byte", byte.class);
    registerAlias("_long", long.class);
    registerAlias("_short", short.class);
    registerAlias("_int", int.class);
    registerAlias("_integer", int.class);
    registerAlias("_double", double.class);
    registerAlias("_float", float.class);
    registerAlias("_boolean", boolean.class);
     
    registerAlias("_byte[]", byte[].class);
    registerAlias("_long[]", long[].class);
    registerAlias("_short[]", short[].class);
    registerAlias("_int[]", int[].class);
    registerAlias("_integer[]", int[].class);
    registerAlias("_double[]", double[].class);
    registerAlias("_float[]", float[].class);
    registerAlias("_boolean[]", boolean[].class);
     
    registerAlias("date", Date.class);
    registerAlias("decimal", BigDecimal.class);
    registerAlias("bigdecimal", BigDecimal.class);
    registerAlias("biginteger", BigInteger.class);
    registerAlias("object", Object.class);
     
    registerAlias("date[]", Date[].class);
    registerAlias("decimal[]", BigDecimal[].class);
    registerAlias("bigdecimal[]", BigDecimal[].class);
    registerAlias("biginteger[]", BigInteger[].class);
    registerAlias("object[]", Object[].class);
     
    registerAlias("map", Map.class);
    registerAlias("hashmap", HashMap.class);
    registerAlias("list", List.class);
    registerAlias("arraylist", ArrayList.class);
    registerAlias("collection", Collection.class);
    registerAlias("iterator", Iterator.class);
     
    registerAlias("ResultSet", ResultSet.class);
  }
  =================================================================	
1
https://gitee.com/zhrun8899/learning-notes.git
git@gitee.com:zhrun8899/learning-notes.git
zhrun8899
learning-notes
learning-notes
master

搜索帮助