x7.repository.dao.SqlUtil Maven / Gradle / Ivy

Go to download
/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements.  See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You 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 x7.repository.dao;

import x7.core.bean.*;
import x7.core.bean.condition.RefreshCondition;
import x7.core.util.BeanUtil;
import x7.core.util.BeanUtilX;
import x7.core.util.ExceptionUtil;
import x7.core.util.StringUtil;
import x7.repository.CriteriaParser;
import x7.repository.util.SqlParserUtil;

import java.lang.reflect.Field;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.*;


public class SqlUtil {

    protected static void adpterSqlKey(PreparedStatement pstmt, String keyOne, Object obj, int i)
            throws SQLException, NoSuchMethodException, SecurityException, IllegalAccessException,
            IllegalArgumentException, InvocationTargetException {
        /*
         * 处理KEY
         */
        Method method = null;
        try {
            method = obj.getClass().getDeclaredMethod(BeanUtil.getGetter(keyOne));
        } catch (NoSuchMethodException e) {
            method = obj.getClass().getSuperclass().getDeclaredMethod(BeanUtil.getGetter(keyOne));
        }
        Object value = method.invoke(obj);
        pstmt.setObject(i++, value);

    }

    protected static void adpterSqlKey(PreparedStatement pstmt, Field keyOneF, Object obj, int i)
            throws SQLException, SecurityException, IllegalAccessException,
            IllegalArgumentException {
        /*
         * 处理KEY
         */
        Object value = keyOneF.get(obj);

        pstmt.setObject(i++, value);

    }

    /**
     * 拼接SQL
     */
    protected static String concat(Parsed parsed, String sql, Map queryMap) {

        StringBuilder sb = new StringBuilder();

        boolean flag = (sql.contains(SqlScript.WHERE) || sql.contains(SqlScript.WHERE.toLowerCase()));

        for (String key : queryMap.keySet()) {

            String mapper = parsed.getMapper(key);
            if (flag) {
                sb.append(Conjunction.AND.sql()).append(mapper).append(SqlScript.EQ_PLACE_HOLDER);
            } else {
                sb.append(SqlScript.WHERE).append(mapper).append(SqlScript.EQ_PLACE_HOLDER);
                flag = true;
            }

        }

        sql += sb.toString();

        return sql;
    }

    /**
     * 拼接SQL
     *
     */
//	protected static String concatRefresh(StringBuilder sb, Parsed parsed, Map refreshMap) {
//
//		String keyOne = parsed.getKey(X.KEY_ONE);
//		refreshMap.remove(keyOne);
//
//		sb.append(SqlScript.SET);
//		int size = refreshMap.size();
//		int i = 0;
//		for (String key : refreshMap.keySet()) {
//
//			BeanElement element = parsed.getElement(key);
//			if (element.isJson && DbType.ORACLE.equals(DbType.value)){
//				Object obj = refreshMap.get(key);
//				Reader reader = new StringReader(obj.toString());
//				refreshMap.put(key,reader);
//			}
//
//			String mapper = parsed.getMapper(key);
//			sb.append(mapper);
//			sb.append(SqlScript.EQ_PLACE_HOLDER);
//			if (i < size - 1) {
//				sb.append(SqlScript.COMMA);
//			}
//			i++;
//		}
//
//
//		sb.append(SqlScript.WHERE);
//		String mapper = parsed.getMapper(keyOne);
//		sb.append(mapper).append(SqlScript.EQ_PLACE_HOLDER);
//
//		return sb.toString();
//	}

    /**
     * 拼接SQL
     */
    protected static String concatRefresh(StringBuilder sb, Parsed parsed,
                                          RefreshCondition refreshCondition, CriteriaParser criteriaParser) {

        sb.append(SqlScript.SET);

        List refreshList = refreshCondition.getRefreshList();

        List