All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.objectsql.SQLService Maven / Gradle / Ivy

Go to download

Lightweight Object SQL Relational Mapping (OSRM)

The newest version!
/*
 * Copyright 2017 @objectsql.com
 *
 * Licensed 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 com.objectsql;

import com.objectsql.exception.ORMException;
import com.objectsql.handler.ResultSetFunction;
import com.objectsql.support.*;

import javax.sql.DataSource;
import java.sql.Connection;
import java.util.Date;
import java.util.List;
import java.util.Map;

public interface SQLService {

    Options getOptions();

    String currentDatabaseName();

    String currentDatabaseType();

    DataSource getDataSource();

    ObjectSQLManager getObjectSQLManager();

    void changeDataSource(String alias);

    void setObjectSQLManager(ObjectSQLManager objectSQLManager);

    boolean execute(String sql, Object ... params);

    boolean executeBatch(String sql, Object [] ... params);

    void query(String sql, Object [] params, ResultSetFunction function);

    boolean executeBatch(String sql, boolean autoCommit,boolean rollback, Object [] ... params);

     T queryObject(Class clazz, String sql, Object ... params);

     List queryObjectList(Class clazz, String sql, Object ... params);

    Map queryMap(String sql, Object ... params);

    List> queryMapList(String sql, Object ... params);

    int queryCount(String sql, Object ... params);

    Object queryResult(String sql, Object ... params);

    Connection getConnection();

    Date getDatabaseDateTime();

    Double getDatabaseNanoTime();

    //自动提交，无回滚
     List batchInserts(List ts, int batchCount);

    //无回滚
     List batchInserts(List ts, int batchCount, boolean autoCommit);

    /**
     * 批量保存
     * @param ts
     * @param batchCount
     * @param autoCommit auto commit
     * @param rollback 当autoCommit=false 有效， rollback = false 不回滚， 为true 回滚
     * @return List
     */
     List batchInserts(List ts, int batchCount, boolean autoCommit, boolean rollback);

    //默认非自动提交 回滚
     List batchInserts(List ts, boolean rollback);


    boolean batchUpdates(List ts, String [] columns, int batchCount);
    boolean batchUpdates(List ts, String [] columns, int batchCount, boolean autoCommit);
    /**
     * 批量更新，根据sql更新，若更新列为null，则将被更新
     * @param ts
     * @param columns 指定更新列，未指定则更新全部
     * @param batchCount
     * @param autoCommit auto commit
     * @param rollback 当autoCommit=false 有效， rollback = false 不回滚， 为true 回滚
     * @return boolean
     */
    boolean batchUpdates(List ts, String [] columns, int batchCount, boolean autoCommit, boolean rollback);
    boolean batchUpdates(List ts, String [] columns, boolean rollback);

    //无columns默认更新全表
    boolean batchUpdates(List ts, int batchCount);
    boolean batchUpdates(List ts, int batchCount, boolean autoCommit);
    boolean batchUpdates(List ts, int batchCount, boolean autoCommit, boolean rollback);
    boolean batchUpdates(List ts, boolean rollback);

    void createOrUpdate(Class table) throws ORMException;

    boolean tableExists(String table);
    Table table(Class clazz)  throws ORMException;
    Table table(String table);
    String getTableName(Class clazz) throws ORMException;
    List columns(Class clazz) throws ORMException;

    List tables();
    List
 tables(String keyword);
    List tableColumns(String tableName);
    List tableColumns(Connection temp, String tableName);
    List tableColumnsClass(String tableName);
    List tableColumnsClass(Connection temp, String tableName);

    void createOrUpdate(Table table, List tableColumns) throws ORMException;
    void drop(Table table) throws ORMException;

    String getSchema();
    void setSchema(String schema);

    void txCommit(Runnable runnable);
    void txCommit(int propagation, Runnable runnable);
    void txCommit(int propagation, int isolationLevel, Runnable runnable);

    void txCommit(Runnable runnable, CommitHandler commitHandler);
    void txCommit(int propagation, Runnable runnable, CommitHandler commitHandler);
    void txCommit(int propagation, int isolationLevel, Runnable runnable, CommitHandler commitHandler);

}
    

    

    

            

    

            



    
    






    
© 2015 - 2024 Weber Informatics LLC | Privacy Policy