com.github.drinkjava2.jdbpro.handler.PrintSqlHandler Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of jsqlbox Show documentation

jSqlBox is a full function DAO tool

There is a newer version: 5.0.15.jre8

/*
 * Copyright 2016 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not
 * use this file except in compliance with the License. You may obtain a copy of
 * the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by
 * applicable law or agreed to in writing, software distributed under the
 * License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS
 * OF ANY KIND, either express or implied. See the License for the specific
 * language governing permissions and limitations under the License.
 */
package com.github.drinkjava2.jdbpro.handler;

import java.util.Arrays;

import com.github.drinkjava2.jdbpro.DefaultOrderSqlHandler;
import com.github.drinkjava2.jdbpro.ImprovedQueryRunner;
import com.github.drinkjava2.jdbpro.PreparedSQL; 

/**
 * PaginHandler is the AroundSqlHandler used to translate SQL to paginated SQL
 * 
 * @author Yong Zhu
 * @since 1.7.0.2
 */
@SuppressWarnings("all")
public class PrintSqlHandler extends DefaultOrderSqlHandler {

	@Override
	public Object handle(ImprovedQueryRunner runner, PreparedSQL ps) {
		StringBuffer sb = new StringBuffer();

		sb.append("======PrintSqlHandler=========\n");
		sb.append("| SQL:       " + ps.getSql()).append("\n");
		sb.append("| Param:     " + Arrays.deepToString(ps.getParams())).append("\n");
		long start = System.currentTimeMillis();
		Object obj = runner.runPreparedSQL(ps);
		long end = System.currentTimeMillis();
		StackTraceElement[] steArray = Thread.currentThread().getStackTrace();
		for (StackTraceElement st : steArray) {
			if (st.getClassName().contains("lang.Thread"))
				continue;
			if (st.getClassName().contains(".drinkjava2.jdbpro"))
				continue;
			if (st.getClassName().contains(".drinkjava2.jsqlbox"))
				continue;
			sb.append("| Location:  " + st.getClassName() + "." + st.getMethodName() + "(" + st.getFileName() + ":"
					+ st.getLineNumber() + ")").append("\n");
			break;
		}

		sb.append("| Time use:  " + (end - start) + "ms\n");
		if (runner.getName()!=null && runner.getName().length()>0) 
			 sb.append("| DB:        "+runner.getName()).append("\n");
		sb.append("==============================");
		System.out.println(sb.toString());
		return obj;
	}

}