Mybatis的SqlSession下的四大对象:Executor、StatementHandler、ParameterHandler、ResultHandler
下面是StatementHandler接口的定义:
public interface StatementHandler {
//预编译SQL
Statement prepare(Connection connection, Integer transactionTimeout)
throws SQLException;
//设置参数
void parameterize(Statement statement)
throws SQLException;
//批量操作
void batch(Statement statement)
throws SQLException;
//更新
int update(Statement statement)
throws SQLException;
//进行查询
<E> List<E> query(Statement statement, ResultHandler resultHandler)
throws SQLException;
//进行查询--使用游标
<E> Cursor<E> queryCursor(Statement statement)
throws SQLException;
BoundSql getBoundSql();
ParameterHandler getParameterHandler();
}
该接口目前有四个实现类:
- RoutingStatementHandler:这是一个封装类,它不提供具体的实现,只是根据Executor的类型,创建不同的类型StatementHandler。
public class RoutingStatementHandler implements StatementHandler {
private final StatementHandler delegate;
public RoutingStatementHandler(Executor executor, MappedStatement ms, Object parameter, RowBounds rowBounds, ResultHandler resultHandler, BoundSql boundSql) {
switch (ms.getStatementType()) {
case STATEMENT:
delegate = new SimpleStatementHandler(executor, ms, parameter, rowBounds, resultHandler, boundSql);
break;
case PREPARED:
delegate = new PreparedStatementHandler(executor, ms, parameter, rowBounds, resultHandler, boundSql);
break;
case CALLABLE:
delegate = new CallableStatementHandler(executor, ms, parameter, rowBounds, resultHandler, boundSql);
break;
default:
throw new ExecutorException("Unknown statement type: " + ms.getStatementType());
}
}
@Override
public Statement prepare(Connection connection, Integer transactionTimeout) throws SQLException {
return delegate.prepare(connection, transactionTimeout);
}
...
...
...
}
SimpleStatementHandler:这个类对应于JDBC的Statement对象,用于没有预编译参数的SQL的运行。
PreparedStatementHandler:这个用于预编译参数SQL的运行
CallableStatementHandler:用于存储过程的调度
Configuration对象会采用new RoutingStatementHandler()来生成StatementHandler对象,即Mybatis真正使用的是RoutingStatementHandler对象,然后它会根据Executor的类型去创建对应具体的StatementHandler对象(SimpleStatementHandler,PreparedStatementHandler和CallableStatementHandler)。
如果需要编写插件:
想改变sql的时候,可以拦截预编译SQL(prepare方法前加入修改的逻辑)。
想修改参数的时候,可以拦截parameterize方法。或者拦截ParameterHandler来改造设置参数。
想要控制组装结果集的时候,也可以在query方法前后加入逻辑,或者使用ResultHandler来改造组装结果。