net.sourceforge.springframework.SqlSessionFactoryBean Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of jweb-common Show documentation

本项目主要弥补在使用mybatis3+springmvc+jquery easyui快速搭建web应用系统是遇到的框架不足. 主要工作包括： 1，扩展了ApplicationContextAware，通过单例注入spring容器，提供spring容器外的bean获取方法 2，扩展了apache shiro框架，统一了安全结构 3，扩展了mybatis3拦截器，在两个拦截器中自动完成分页注入，实现内存分页。 4，分页设计数据库方言 5，提供了一个easyuigrid的模型 6，提供了java泛型的jstl 7， xml工具包等一些小工具

The newest version!

package net.sourceforge.springframework;

import java.lang.reflect.InvocationHandler;
import java.lang.reflect.Method;
import java.lang.reflect.Proxy;
import java.sql.Connection;
import java.util.List;

import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.session.ExecutorType;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.TransactionIsolationLevel;
import org.apache.log4j.Logger;

/**
 * override getObject get sql session with safe selectOne
 * 
 * @author alex
 *
 */
public class SqlSessionFactoryBean extends org.mybatis.spring.SqlSessionFactoryBean {
	private final static Logger LOGGER = Logger.getLogger(SqlSessionFactoryBean.class);

	@Override
	public SqlSessionFactory getObject() throws Exception {
		SqlSessionFactory factory = super.getObject();
		return new ProxySqlSessionFactory(factory);
	}

	class ProxySqlSessionFactory implements SqlSessionFactory {
		private final SqlSessionFactory factory;

		ProxySqlSessionFactory(SqlSessionFactory factory) {
			this.factory = factory;
		}

		public Configuration getConfiguration() {
			return factory.getConfiguration();
		}

		public SqlSession openSession() {
			return dynamicalProxy(factory.openSession());
		}

		public SqlSession openSession(boolean arg0) {
			return dynamicalProxy(factory.openSession(arg0));
		}

		public SqlSession openSession(Connection arg0) {
			return dynamicalProxy(factory.openSession(arg0));
		}

		public SqlSession openSession(TransactionIsolationLevel arg0) {
			return dynamicalProxy(factory.openSession(arg0));
		}

		public SqlSession openSession(ExecutorType arg0) {
			return dynamicalProxy(factory.openSession(arg0));
		}

		public SqlSession openSession(ExecutorType arg0, boolean arg1) {
			return dynamicalProxy(factory.openSession(arg0, arg1));
		}

		public SqlSession openSession(ExecutorType arg0, TransactionIsolationLevel arg1) {
			return dynamicalProxy(factory.openSession(arg0, arg1));
		}

		public SqlSession openSession(ExecutorType arg0, Connection arg1) {
			return dynamicalProxy(factory.openSession(arg0, arg1));
		}
	}

	// proxy selectOne method, not throw exception, just send warnning
	private SqlSession dynamicalProxy(final SqlSession session) {
		return (SqlSession) Proxy.newProxyInstance(session.getClass().getClassLoader(),
				new Class[] { SqlSession.class }, new InvocationHandler() {
					public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {
						String methodName = method.getName();
						if ("selectOne".equals(methodName) && args != null && args.length == 2) {
							// Popular vote was to return null on 0 results and throw exception on too many.
							List list = session.selectList(args[0].toString(), args[1]);
							if (list.size() == 1) {
								return list.get(0);
							} else if (list.size() > 1) {
								LOGGER.warn(args[0] + " returned more than one result, it is unsafe selectOne");
								return list.get(0);
							} else {
								return null;
							}
						}
						return method.invoke(session, args);
					}
				});
	}
}