自定义 typeHandler
对于自定义 typeHandler 来说, 需要在配置文件中注册 typeHandlers 然后需要实现 TypeHandler 接口, 一个例子首先编写调度的处理类
package com.ming.MyBatis;
import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.TypeHandler;
import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class StringTypeHandler implements TypeHandler<String> {
private static Logger logger = LogManager.getLogger();
/**
* 对预编译的 Sql 语句进行设置的时候,
* @param ps
* @param i
* @param parameter
* @param jdbcType
* @throws SQLException
*/
@Override
public void setParameter(PreparedStatement ps, int i, String parameter, JdbcType jdbcType) throws SQLException {
logger.info(“ 使用 TypeHandler”);
// 设置预编译的 sql 对象, 的 string
ps.setString(i, parameter);
}
/**
* 获得结果的时候, 获取到列名的时候, 调度此方法
* @param rs
* @param columnName
* @return
* @throws SQLException
*/
@Override
public String getResult(ResultSet rs, String columnName) throws SQLException {
logger.info(“ 使用自定义类型, 结果获取列名字符串 ”);
return rs.getString(columnName);
}
/**
* 获取结果集中的 index
* @param rs
* @param columnIndex
* @return
* @throws SQLException
*/
@Override
public String getResult(ResultSet rs, int columnIndex) throws SQLException {
logger.info(“ 在结果集中获取 columnIndex”);
return rs.getString(columnIndex);
}
/**
* 获取结果集中的下标对应的字符串
* @param cs
* @param columnIndex
* @return
* @throws SQLException
*/
@Override
public String getResult(CallableStatement cs, int columnIndex) throws SQLException {
logger.info(“ 结果集中, 下标获取到字符串 ”);
return cs.getString(columnIndex);
}
}
再次编写配置文件
<typeHandlers>
<typeHandler jdbcType=”VARCHAR” javaType=”string” handler=”com.ming.MyBatis.StringTypeHandler”>
</typeHandlers>
传入数据库的为的 VARCHAR 类型,javaType 类型为 string 类型, 调度的类为 com.ming.MyBatis.StringTypeHandler 修改映射文件, 说明那些需要对结果进行修改
<?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=”com.ming.MyBatis.POJO.RoleMapper”>
<!– id 表示标签标识 type 标识结果的返回类型, 其中 role 为在配置文件中使用的别名 Role 类 –>
<resultMap type=”role” id=”roleMap”>
<!– id 为主键映射关系 其中数据库中的 id 为主键 –>
<id column=”id” property=”id” javaType=”int” jdbcType=”INTEGER”/>
<!– result 为其他基本数据类型和实体类之间的映射 映射关系为 role_name 到 roleName 之间的映射 数据类型为 string 到 VARCHAR 之间的映射关系 –>
<result column=”role_name” property=”roleName” javaType=”string” jdbcType=”VARCHAR”/>
<!– 这里使用 typeHandler 表示遇到此处理集的时候, 将会执行 com.ming.MyBatis.StringTypeHandler –>
<result column=”note” property=”note” typeHandler=”com.ming.MyBatis.StringTypeHandler”/>
</resultMap>
<!– 书写 SQL 语句 定义使用 resultMap 为 roleMap–>
<select id=”getRole” parameterType=”int” resultMap=”roleMap”>
SELECT id, role_name, note FROM t_role4 WHERE id = #{id}
</select>
</mapper>
其中传入的参数为 int 类型, 由于结果中 mybatis 没有 int 类型, 对应的是 INTEGER 类型, 在 mysql 中两者类型相同, 所以修改如上所示, 表类型
书写 index.jsp
<%@ page import=”org.apache.ibatis.session.SqlSession” %>
<%@ page import=”com.ming.Util.SqlSessionFactoryUtil” %>
<%@ page import=”com.ming.MyBatis.POJO.RoleMapper” %>
<%@ page import=”com.ming.MyBatis.POJO.Role” %>
<html>
<body>
<h2>Hello World!</h2>
<%
long startTime = System.currentTimeMillis(); // 获取开始时间
SqlSession sqlSession = null;
Role role = null;
for(int i = 0; i < 10; i++) {
try {
sqlSession = SqlSessionFactoryUtil.openSqlSesion();
RoleMapper roleMapper = sqlSession.getMapper(RoleMapper.class);
role = roleMapper.getRole(100);
sqlSession.commit();
} catch (Exception e) {
e.printStackTrace();
sqlSession.rollback();
} finally {
if (sqlSession != null) {
sqlSession.close();
}
}
}
long endTime = System.currentTimeMillis(); // 获取结束时间
%>
<%=role.getNote()%>
</body>
</html>
已经查询成功
查看日志文件, 日志文件已经输出相关信息
2019-04-13 05:03:33.181 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:136) – Opening JDBC Connection
2019-04-13 05:03:33.181 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:397) – Checked out connection 197673257 from pool.
2019-04-13 05:03:33.182 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:100) – Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.235 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Preparing: SELECT id, role_name, note FROM t_role4 WHERE id = ?
2019-04-13 05:03:33.236 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Parameters: 100(Integer)
2019-04-13 05:03:33.275 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:33.276 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:33.277 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – <== Total: 1
2019-04-13 05:03:33.277 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.resetAutoCommit(JdbcTransaction.java:122) – Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.312 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.close(JdbcTransaction.java:90) – Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.312 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.pushConnection(PooledDataSource.java:362) – Returned connection 197673257 to pool.
2019-04-13 05:03:33.313 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:136) – Opening JDBC Connection
2019-04-13 05:03:33.314 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:397) – Checked out connection 197673257 from pool.
2019-04-13 05:03:33.314 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:100) – Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.346 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Preparing: SELECT id, role_name, note FROM t_role4 WHERE id = ?
2019-04-13 05:03:33.348 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Parameters: 100(Integer)
2019-04-13 05:03:33.386 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:33.390 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:33.391 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – <== Total: 1
2019-04-13 05:03:33.395 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.resetAutoCommit(JdbcTransaction.java:122) – Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.442 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.close(JdbcTransaction.java:90) – Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.443 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.pushConnection(PooledDataSource.java:362) – Returned connection 197673257 to pool.
2019-04-13 05:03:33.443 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:136) – Opening JDBC Connection
2019-04-13 05:03:33.444 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:397) – Checked out connection 197673257 from pool.
2019-04-13 05:03:33.444 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:100) – Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.479 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Preparing: SELECT id, role_name, note FROM t_role4 WHERE id = ?
2019-04-13 05:03:33.480 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Parameters: 100(Integer)
2019-04-13 05:03:33.518 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:33.519 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:33.520 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – <== Total: 1
2019-04-13 05:03:33.520 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.resetAutoCommit(JdbcTransaction.java:122) – Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.556 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.close(JdbcTransaction.java:90) – Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.557 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.pushConnection(PooledDataSource.java:362) – Returned connection 197673257 to pool.
2019-04-13 05:03:33.558 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:136) – Opening JDBC Connection
2019-04-13 05:03:33.558 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:397) – Checked out connection 197673257 from pool.
2019-04-13 05:03:33.558 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:100) – Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.591 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Preparing: SELECT id, role_name, note FROM t_role4 WHERE id = ?
2019-04-13 05:03:33.592 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Parameters: 100(Integer)
2019-04-13 05:03:33.638 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:33.639 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:33.640 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – <== Total: 1
2019-04-13 05:03:33.640 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.resetAutoCommit(JdbcTransaction.java:122) – Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.676 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.close(JdbcTransaction.java:90) – Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.677 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.pushConnection(PooledDataSource.java:362) – Returned connection 197673257 to pool.
2019-04-13 05:03:33.677 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:136) – Opening JDBC Connection
2019-04-13 05:03:33.677 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:397) – Checked out connection 197673257 from pool.
2019-04-13 05:03:33.677 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:100) – Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.711 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Preparing: SELECT id, role_name, note FROM t_role4 WHERE id = ?
2019-04-13 05:03:33.712 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Parameters: 100(Integer)
2019-04-13 05:03:33.747 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:33.748 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:33.748 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – <== Total: 1
2019-04-13 05:03:33.749 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.resetAutoCommit(JdbcTransaction.java:122) – Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.780 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.close(JdbcTransaction.java:90) – Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.780 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.pushConnection(PooledDataSource.java:362) – Returned connection 197673257 to pool.
2019-04-13 05:03:33.781 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:136) – Opening JDBC Connection
2019-04-13 05:03:33.781 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:397) – Checked out connection 197673257 from pool.
2019-04-13 05:03:33.781 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:100) – Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.830 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Preparing: SELECT id, role_name, note FROM t_role4 WHERE id = ?
2019-04-13 05:03:33.831 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Parameters: 100(Integer)
2019-04-13 05:03:33.868 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:33.870 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:33.870 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – <== Total: 1
2019-04-13 05:03:33.872 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.resetAutoCommit(JdbcTransaction.java:122) – Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.913 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.close(JdbcTransaction.java:90) – Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.914 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.pushConnection(PooledDataSource.java:362) – Returned connection 197673257 to pool.
2019-04-13 05:03:33.914 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:136) – Opening JDBC Connection
2019-04-13 05:03:33.915 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:397) – Checked out connection 197673257 from pool.
2019-04-13 05:03:33.915 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:100) – Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:33.956 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Preparing: SELECT id, role_name, note FROM t_role4 WHERE id = ?
2019-04-13 05:03:33.957 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Parameters: 100(Integer)
2019-04-13 05:03:33.994 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:33.994 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:33.995 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – <== Total: 1
2019-04-13 05:03:33.995 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.resetAutoCommit(JdbcTransaction.java:122) – Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:34.029 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.close(JdbcTransaction.java:90) – Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:34.029 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.pushConnection(PooledDataSource.java:362) – Returned connection 197673257 to pool.
2019-04-13 05:03:34.030 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:136) – Opening JDBC Connection
2019-04-13 05:03:34.030 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:397) – Checked out connection 197673257 from pool.
2019-04-13 05:03:34.030 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:100) – Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:34.095 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Preparing: SELECT id, role_name, note FROM t_role4 WHERE id = ?
2019-04-13 05:03:34.097 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Parameters: 100(Integer)
2019-04-13 05:03:34.133 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:34.133 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:34.134 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – <== Total: 1
2019-04-13 05:03:34.134 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.resetAutoCommit(JdbcTransaction.java:122) – Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:34.168 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.close(JdbcTransaction.java:90) – Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:34.169 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.pushConnection(PooledDataSource.java:362) – Returned connection 197673257 to pool.
2019-04-13 05:03:34.170 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:136) – Opening JDBC Connection
2019-04-13 05:03:34.170 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:397) – Checked out connection 197673257 from pool.
2019-04-13 05:03:34.171 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:100) – Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:34.214 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Preparing: SELECT id, role_name, note FROM t_role4 WHERE id = ?
2019-04-13 05:03:34.215 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Parameters: 100(Integer)
2019-04-13 05:03:34.252 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:34.252 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:34.253 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – <== Total: 1
2019-04-13 05:03:34.254 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.resetAutoCommit(JdbcTransaction.java:122) – Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:34.291 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.close(JdbcTransaction.java:90) – Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:34.291 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.pushConnection(PooledDataSource.java:362) – Returned connection 197673257 to pool.
2019-04-13 05:03:34.292 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:136) – Opening JDBC Connection
2019-04-13 05:03:34.292 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:397) – Checked out connection 197673257 from pool.
2019-04-13 05:03:34.292 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:100) – Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:34.336 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Preparing: SELECT id, role_name, note FROM t_role4 WHERE id = ?
2019-04-13 05:03:34.337 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – ==> Parameters: 100(Integer)
2019-04-13 05:03:34.379 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:34.380 [INFO] com.ming.MyBatis.StringTypeHandler.getResult(StringTypeHandler.java:48) – 使用自定义类型, 结果获取列名字符串
2019-04-13 05:03:34.380 [DEBUG] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) – <== Total: 1
2019-04-13 05:03:34.381 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.resetAutoCommit(JdbcTransaction.java:122) – Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:34.415 [DEBUG] org.apache.ibatis.transaction.jdbc.JdbcTransaction.close(JdbcTransaction.java:90) – Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@bc84129]
2019-04-13 05:03:34.415 [DEBUG] org.apache.ibatis.datasource.pooled.PooledDataSource.pushConnection(PooledDataSource.java:362) – Returned connection 197673257 to pool.
ps 类型转换的问题