All Downloads are FREE. Search and download functionalities are using the official Maven repository.
Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
com.ursful.framework.orm.ISQLService Maven / Gradle / Ivy
/*
* Copyright 2017 @ursful.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.ursful.framework.orm;
import com.ursful.framework.orm.exception.ORMException;
import com.ursful.framework.orm.handler.ResultSetFunction;
import com.ursful.framework.orm.support.*;
import javax.sql.DataSource;
import java.sql.Connection;
import java.util.Date;
import java.util.List;
import java.util.Map;
public interface ISQLService {
Options getOptions();
String currentDatabaseName();
String currentDatabaseType();
DataSource getDataSource();
DataSourceManager getDataSourceManager();
void changeDataSource(String alias);
void setDataSourceManager(DataSourceManager dataSourceManager);
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 batchSaves(List ts, int batchCount);
//无回滚
List batchSaves(List ts, int batchCount, boolean autoCommit);
/**
* 批量保存
* @param ts
* @param batchCount
* @param autoCommit auto commit
* @param rollback 当autoCommit=false 有效， rollback = false 不回滚， 为true 回滚
* @return List
*/
List batchSaves(List ts, int batchCount, boolean autoCommit, boolean rollback);
//默认非自动提交 回滚
List batchSaves(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;
}
