com.eu.evaluation.server.dao.DefaultDAO.java Source code

Introduction

Here is the source code for com.eu.evaluation.server.dao.DefaultDAO.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package com.eu.evaluation.server.dao;

import com.eu.evaluation.model.EntityEnum;
import com.eu.evaluation.model.sys.AccessSystem;
import java.text.MessageFormat;
import java.util.List;
import javax.persistence.Query;
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
import org.springframework.stereotype.Repository;

/**
 *
 * @author dell
 */
@Repository
public class DefaultDAO extends AbstractDAO {
    /**
     * JPQL?
     * @param <T>
     * @param jpql
     * @param params
     * @return 
     */
    public <T> List<T> find(String jpql, MapSqlParameterSource params) {
        return this.query(jpql, params);
    }

    /**
     * ?
     * @param <T>
     * @param className ???
     * @param id ?ID
     * @param evaluateVersionID ?
     * @return 
     */
    public <T> T findEvaluateData(String className, String id, String evaluateVersionID,
            AccessSystem accessSystem) {
        String jpql = "select t from {0} t where t.id = :id and t.evaluateVersion.id = :evID and t.position = :position";
        jpql = MessageFormat.format(jpql, new Object[] { className });
        MapSqlParameterSource params = new MapSqlParameterSource("id", id);
        params.addValue("evID", evaluateVersionID);
        params.addValue("position", accessSystem.getCode());
        List<T> result = find(jpql, params);
        if (result.isEmpty()) {
            String msg = "??{0}  ?ID {1}  ? {2} , ? {3}";
            throw new RuntimeException(MessageFormat.format(msg,
                    new Object[] { className, id, evaluateVersionID, accessSystem.getName() }));
        } else if (result.size() == 1) {
            return result.get(0);
        } else {
            String msg = "????{0}  ?ID {1}  ? {2} , ? {3}";
            throw new RuntimeException(MessageFormat.format(msg,
                    new Object[] { className, id, evaluateVersionID, accessSystem.getName() }));
        }
    }

    /**
     * Insert?
     * @param sql
     * @param params 
     */
    public void executeNativeInsert(String sql, MapSqlParameterSource params) {
        this.updateNative(sql, params);
    }

    /**
     * count?
     * @param jpql
     * @param params
     * @return 
     */
    public Long executeCount(String jpql, MapSqlParameterSource params) {
        //        List rr = this.query(jpql , params);
        //        return Long.valueOf(rr.size());

        Long count = (Long) this.createQuery(jpql, params).getSingleResult();
        return count;
    }

    /**
     * ??
     * @param jpql
     * @param params
     * @return 
     */
    public <T> T findOnylFirst(String jpql, MapSqlParameterSource params) {
        Query query = this.createQuery(jpql, params);
        query.setFirstResult(0);
        query.setMaxResults(1);
        List<T> result = query.getResultList();
        if (result.isEmpty()) {
            return null;
        } else {
            return result.get(0);
        }
    }

    /**
     * ???position
     * @param entityEnum
     * @param position
     * @return 
     */
    public int deleteData(Class<?> orgDataClass, String position) {
        String jpql = "delete from {0} t where t.position = :position";
        jpql = MessageFormat.format(jpql, orgDataClass.getName());
        MapSqlParameterSource params = new MapSqlParameterSource("position", position);
        return this.createQuery(jpql, params).executeUpdate();
    }
}