com.centit.support.database.jsonmaptable.JsonObjectDao Maven / Gradle / Ivy

Go to download
package com.centit.support.database.jsonmaptable;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.centit.support.database.metadata.TableInfo;

import java.io.IOException;
import java.sql.SQLException;
import java.util.Collection;
import java.util.List;
import java.util.Map;

public interface JsonObjectDao {

    TableInfo getTableInfo();

    /**
     * 单主键表
     *
     * @param keyValue keyValue
     * @return JSONObject
     * @throws SQLException SQLException
     * @throws IOException  IOException
     */
    JSONObject getObjectById(final Object keyValue) throws SQLException, IOException;

    /**
     * 根据属性查询对象
     *
     * @param properties properties
     * @return JSONObject
     * @throws SQLException SQLException
     * @throws IOException  IOException
     */
    JSONObject getObjectByProperties(final Map properties) throws SQLException, IOException;

    /**
     * @param properties properties
     * @return JSONArray
     * @throws SQLException SQLException
     * @throws IOException  IOException
     */
    JSONArray listObjectsByProperties(final Map properties) throws SQLException, IOException;

    /**
     * 根据属性进行查询
     *
     * @param properties properties
     * @param startPos   startPos
     * @param maxSize    maxSize
     * @return JSONArray
     * @throws SQLException SQLException
     * @throws IOException  IOException
     */
    JSONArray listObjectsByProperties(final Map properties,
                                      final int startPos, final int maxSize) throws SQLException, IOException;

    /**
     * 根据属性进行并获取总数
     *
     * @param properties properties
     * @return Long fetchObjectsCount
     * @throws SQLException SQLException
     * @throws IOException  IOException
     */
    Long fetchObjectsCount(final Map properties)
        throws SQLException, IOException;

    /**
     * 获取Sequence的值，不支持的Sequence数据库可以用一个表或者存储过程来模拟
     *
     * @param sequenceName sequenceName
     * @return Long
     * @throws SQLException SQLException
     * @throws IOException  IOException
     */
    Long getSequenceNextValue(final String sequenceName) throws SQLException, IOException;

    /*
     * 保存
     * @param object object
     */
    int saveNewObject(final Map object) throws SQLException;


    Map saveNewObjectAndFetchGeneratedKeys(final Map object)
        throws SQLException, IOException;

    /**
     * 更改部分属性
     *
     * @param fields 更改部分属性 属性名 集合，应为有的Map 不允许 值为null，这样这些属性 用map就无法修改为 null
     * @param object object
     * @return Long
     * @throws SQLException SQLException
     */
    int updateObject(final Collection fields, final Map object) throws SQLException;

    /**
     * 更改部分属性
     *
     * @param object object
     * @return Long
     * @throws SQLException SQLException
     */
    int updateObject(final Map object) throws SQLException;

    /**
     * 更改部分属性
     *
     * @param fields 更改部分属性 属性名 集合，应为有的Map 不允许 值为null，这样这些属性 用map就无法修改为 null
     * @param object object
     * @return Long
     * @throws SQLException SQLException
     * @throws IOException  IOException
     */
    int mergeObject(final Collection fields,
                    final Map object) throws SQLException, IOException;

    /**
     * 合并
     *
     * @param object object
     * @return Long
     * @throws SQLException SQLException
     * @throws IOException  IOException
     */
    int mergeObject(final Map object) throws SQLException, IOException;

    /**
     * 根据条件批量更新 对象
     *
     * @param fieldValues properties
     * @param properties  properties
     * @return Long
     * @throws SQLException SQLException
     */
    int updateObjectsByProperties(final Map fieldValues,
                                  final Map properties) throws SQLException;

    /**
     * 根据条件批量更新 对象
     *
     * @param fields      更改部分属性 属性名 集合，应为有的Map 不允许 值为null，这样这些属性 用map就无法修改为 null
     * @param fieldValues fieldValues
     * @param properties  properties
     * @return Long
     * @throws SQLException SQLException
     */
    int updateObjectsByProperties(final Collection fields,
                                  final Map fieldValues,
                                  final Map properties) throws SQLException;

    /**
     * 删除，单主键
     *
     * @param keyValue keyValue
     * @return Long
     * @throws SQLException SQLException
     */
    int deleteObjectById(final Object keyValue) throws SQLException;

    /*
     * 删除，联合主键
     * @param keyValue keyValue
     * @return Long
     * @throws SQLException SQLException
     int deleteObjectById(final Map keyValue) throws SQLException;
     */

    /**
     * 根据属性 批量删除
     *
     * @param properties properties
     * @return Long
     * @throws SQLException SQLException
     */
    int deleteObjectsByProperties(final Map properties)
        throws SQLException;
    //--- 作为子表批量操作

    /**
     * 批量添加多条记录
     *
     * @param objects JSONArray
     * @return int
     * @throws SQLException SQLException
     */
    int insertObjectsAsTabulation(final List> objects) throws SQLException;

    /**
     * 批量删除
     *
     * @param objects JSONArray
     * @return int
     * @throws SQLException SQLException
     */
    int deleteObjects(final List