com.zhuang.data.jdbc.util.PreparedStatementUtils Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of my-data Show documentation

my-data

There is a newer version: 1.1.2

package com.zhuang.data.jdbc.util;

import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Map;

import com.zhuang.data.util.DataTypeUtils;
import com.zhuang.data.util.EntityUtils;

public class PreparedStatementUtils {

    public static void setParameter(PreparedStatement preparedStatement, Object parameter, Map parametersIndex) throws SQLException {

        if (DataTypeUtils.isPrimitiveType(parameter)) {
            preparedStatement.setObject(1, parameter);
        } else {
            Map mapParameter = EntityUtils.convertToMap(parameter);
            for (String key : parametersIndex.keySet()) {
                if (mapParameter.containsKey(key)) {
                    Integer parameterIndex = parametersIndex.get(key);
                    Object parameterValue = mapParameter.get(key);
                    preparedStatement.setObject(parameterIndex, parameterValue);
                }
            }
        }
    }

}