• Home
• cn.craccd
• jpaHelper
• 0.3.6
• source code
• JpaHelper.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.

cn.cucc.utils.JpaHelper Maven / Gradle / Ivy

package cn.cucc.utils;

import java.lang.reflect.Field;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Collection;
import java.util.HashSet;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import java.util.Set;

import javax.persistence.Id;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

import cn.cucc.bean.CreateTime;
import cn.cucc.bean.InitValue;
import cn.cucc.bean.Page;
import cn.cucc.bean.Page;
import cn.cucc.bean.Sort;
import cn.cucc.bean.Update;
import cn.cucc.bean.UpdateTime;
import cn.cucc.reflection.ReflectionUtil;
import cn.cucc.reflection.SerializableFunction;
import cn.hutool.core.util.ReflectUtil;
import cn.hutool.core.util.StrUtil;

/**
 * sql操作器
 *
 */
@Service
public class JpaHelper {
	Logger logger = LoggerFactory.getLogger(this.getClass());

	@Autowired
	JdbcTemplate jdbcTemplate;

	@Value("${spring.datasource.url:}")
	String url;
	@Autowired
	SqlUtils sqlUtils;

	/**
	 * 获取主键
	 * 
	 * @param clazz
	 * @return
	 */
	private String getPrimalKey(Class clazz) {

		Field[] fields = ReflectUtil.getFields(clazz);

		for (Field field : fields) {
			if (field.isAnnotationPresent(Id.class)) {
				return field.getName();
			}
		}

		return null;
	}

	/**
	 * 获取主键值
	 * 
	 * @param clazz
	 * @return
	 */
	private String getPrimalValue(Object object) {
		String key = getPrimalKey(object.getClass());

		if (StrUtil.isNotEmpty(key)) {
			Object obj = ReflectUtil.getFieldValue(object, key);
			return obj != null ? obj.toString() : null;
		}
		return null;
	}

	/**
	 * 累加某一个字段的数量,原子操作
	 * 
	 * @param object
	 */

	public  void addCountById(String id, SerializableFunction property, Long count, Class clazz) {
		addCountById(id, ReflectionUtil.getFieldName(property), count, clazz);
	}

	/**
	 * 累加某一个字段的数量,原子操作
	 * 
	 * @param object
	 */

	public void addCountById(String id, String property, Long count, Class clazz) {
		String sql = "UPDATE `" + StrUtil.toUnderlineCase(clazz.getSimpleName()) + "` SET `" + StrUtil.toUnderlineCase(property) + "` = `" + StrUtil.toUnderlineCase(property)
				+ "` + ? WHERE `id` =  ?";
		Object[] params = new Object[] { count, id };
		sqlUtils.logQuery(sql, params);
		jdbcTemplate.update(buildSql(sql), params);
	}

	/**
	 * 累加某一个字段的数量,原子操作
	 * 
	 * @param object
	 */

	public  void addCountById(String id, SerializableFunction property, Double count, Class clazz) {
		addCountById(id, ReflectionUtil.getFieldName(property), count, clazz);
	}

	/**
	 * 累加某一个字段的数量,原子操作
	 * 
	 * @param object
	 */

	public void addCountById(String id, String property, Double count, Class clazz) {
		String sql = "UPDATE `" + StrUtil.toUnderlineCase(clazz.getSimpleName()) + "` SET `" + StrUtil.toUnderlineCase(property) + "` = `" + StrUtil.toUnderlineCase(property)
				+ "` + ? WHERE `id` =  ?";
		Object[] params = new Object[] { count, id };
		sqlUtils.logQuery(sql, params);
		jdbcTemplate.update(buildSql(sql), params);
	}

	/**
	 * 插入或更新
	 * 
	 * @param object 对象 @throws
	 */

	public String insertOrUpdate(Object object) {
		Long time = System.currentTimeMillis();
		String id = getPrimalValue(object);
		if (StrUtil.isEmpty(id)) {
			// 插入
			// 设置插入时间
			setCreateTime(object, time);
			// 设置更新时间
			setUpdateTime(object, time);
			// 设置默认值
			setDefaultVaule(object);
			// 设置id
			ReflectUtil.setFieldValue(object, getPrimalKey(object.getClass()), SnowFlakeUtils.nextId());

			List fieldsPart = new ArrayList();
			List placeHolder = new ArrayList();
			List