• Home
• net.oschina.haopeng
• simple-orm
• v1.0
• source code
• BaseDaoAdapter.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.simple.orm.dao.BaseDaoAdapter Maven / Gradle / Ivy

package com.simple.orm.dao;

import java.io.Serializable;
import java.lang.reflect.Field;
import java.lang.reflect.ParameterizedType;
import java.lang.reflect.Type;
import java.math.BigDecimal;
import java.sql.Blob;
import java.sql.Clob;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.persistence.Column;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.Id;
import javax.persistence.OrderBy;
import javax.persistence.Table;

import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.jdbc.support.KeyHolder;
import org.springframework.util.ReflectionUtils;
import org.springframework.util.StringUtils;


public abstract class BaseDaoAdapter implements BaseDao, ApplicationContextAware {

	private JdbcTemplate jdbcTemplate;
	private final Class entityClass;
	private final String tableName;
	private final List fields=new ArrayList();
	private  String defaultOrderColumnLabel=""; //默认的排序列名
	private  String defaultBy=""; //默认排序方式
	private final Query query;
	@SuppressWarnings("unchecked")
	public BaseDaoAdapter() {
		
		Type paramType = getClass().getGenericSuperclass();
		if (paramType instanceof ParameterizedType) {
			ParameterizedType pty = (ParameterizedType) paramType;
			this.entityClass = (Class) pty.getActualTypeArguments()[0];
			Table table = entityClass.getAnnotation(Table.class);
			tableName = table.name();
			initFields(entityClass);
			query=new QueryImpl();
		} else {
			entityClass = null;
			tableName = null;
			query=null;
		}
	}
	
	/**
	 * 加载类中所有的属相和方法
	 * @param clazz 映射对象的CLASS
	 */
	private void initFields(Class clazz){
		Class searchType = clazz;
		while (!Object.class.equals(searchType) && searchType != null) {
			Field[] temp = searchType.getDeclaredFields();
			for(Field field:temp){
				fields.add(field);
				OrderBy ob=field.getAnnotation(OrderBy.class);
				if(ob!=null){
					Column column = field.getAnnotation(Column.class);
					if (column == null || (defaultOrderColumnLabel = column.name()).equals("")) {
						continue;
					}
					defaultBy=(StringUtils.isEmpty(ob.value())?"ASC":ob.value());
				}
			}
			searchType = searchType.getSuperclass();
		}
	}
	/**
	 * 设置某个属性排序
	 * @param property 属性名称
	 * @param by ASC|DESC
	 * @return 返回查询对象
	 * @throws SQLException 抛出数据库异常
	 */
	public Query setOrderBy(String property,String by) throws SQLException{
		String columnLabel =getColumnLabelByProperty(property);
		return new QueryImpl(columnLabel, by);
	}

	public M find(Serializable id) throws SQLException {
		return query.find(id);
	}

	public M find(String property, Object value) throws SQLException {
		return query.find(property, value);
	}

	public List query(String property, Object value) throws SQLException {
		return query.query(property, value);
	}

	public List query(String property, Object value, Integer start, Integer num) throws SQLException {
		return query.query(property, value, start, num);
	}

	public List query() throws SQLException {
		return query.query();
	}

	public List query(M m, Integer start, Integer num) throws SQLException {
		return query.query(m, start, num);
	}
	
	public List query(Integer start, Integer num) throws SQLException {
		return query.query(start, num);
	}

	public List query(M m) throws SQLException {
		return query.query(m);
	}

	public M insert(M m)throws SQLException {
		try {
			StringBuilder columns=new StringBuilder();
			StringBuilder values=new StringBuilder();
			final List