io.github.shmilyjxs.core.ISqlDao Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of jdb-tool Show documentation

There is a newer version: 1.37

package io.github.shmilyjxs.core;

import io.github.shmilyjxs.utils.PageResult;

import java.util.Collection;
import java.util.List;
import java.util.Map;

public interface ISqlDao {

    int insert(String tableName, Map columnMap);

    int update(String tableName, Map columnMap, String columnName);

    int update(String tableName, Map columnMap, Collection columns);

    int update(String tableName, Map columnMap, Map whereMap);

     int delete(String tableName, String columnName, C columnValue);

    int delete(String tableName, Map columnMap);

     int batchDelete(String tableName, String columnName, Collection columnValues);

     T getBean(String tableName, String columnName, C columnValue, Class mappedClass);

     T getBean(String tableName, Map columnMap, Class mappedClass);

     List getBeans(String tableName, String columnName, Collection columnValues, Class mappedClass, String... orderBy);

     List getBeans(String tableName, Map columnMap, Class mappedClass, String... orderBy);

     PageResult selectPage(String tableName, Map columnMap, long pageNum, long pageSize, Class mappedClass, String... orderBy);

     List downRecursiveSql(String tableName, String startColumn, C columnValue, String joinColumn, Class mappedClass, String... orderBy);

     List upRecursiveSql(String tableName, String startColumn, C columnValue, String joinColumn, Class mappedClass, String... orderBy);

     Map getMap(String tableName, String columnName, C columnValue);

    Map getMap(String tableName, Map columnMap);

     List> getList(String tableName, String columnName, Collection columnValues, String... orderBy);

    List> getList(String tableName, Map columnMap, String... orderBy);

    PageResult> selectPage(String tableName, Map columnMap, long pageNum, long pageSize, String... orderBy);

     List> downRecursiveSql(String tableName, String startColumn, C columnValue, String joinColumn, String... orderBy);

     List> upRecursiveSql(String tableName, String startColumn, C columnValue, String joinColumn, String... orderBy);
}