• Home
• com.github.ltsopensource
• lts
• 1.7.0
• source code
• SqlTemplate.java

×

Project download

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.github.ltsopensource.store.jdbc.SqlTemplate Maven / Gradle / Ivy

package com.github.ltsopensource.store.jdbc;

import com.github.ltsopensource.store.jdbc.dbutils.ResultSetHandler;

import java.sql.SQLException;

/**
 * @author Robert HG ([email protected]) on 3/8/16.
 */
public interface SqlTemplate {

    void createTable(final String sql) throws SQLException;

    int[] batchInsert(final String sql, final Object[][] params) throws SQLException;

    int[] batchUpdate(final String sql, final Object[][] params) throws SQLException;

    int insert(final String sql, final Object... params) throws SQLException;

    int update(final String sql, final Object... params) throws SQLException;

    int delete(final String sql, final Object... params) throws SQLException;

     T query(final String sql, final ResultSetHandler rsh, final Object... params) throws SQLException;

     T queryForValue(final String sql, final Object... params) throws SQLException;

     T executeInTransaction(SqlExecutor executor);

    void executeInTransaction(SqlExecutorVoid executor);
}