com.zhuang.data.DbAccessor Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of my-data Show documentation
my-data
There is a newer version: 1.1.2
package com.zhuang.data;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.zhuang.data.enums.DbDialect;
import com.zhuang.data.exception.ExecuteSqlException;
import com.zhuang.data.jdbc.util.PreparedStatementUtils;
import com.zhuang.data.jdbc.util.ResultSetUtils;
import com.zhuang.data.model.PageInfo;
import com.zhuang.data.orm.enums.PlaceHolderType;
import com.zhuang.data.orm.mapping.TableMapping;
import com.zhuang.data.orm.sql.BuildResult;
import com.zhuang.data.orm.sql.SqlBuilder;
import com.zhuang.data.orm.sql.SqlBuilderFactory;

public abstract class DbAccessor {

    //region attributes
    protected DbDialect dbDialect;
    protected String configFile;
    protected boolean autoCommit;
    //endregion

    //region get attributes
    abstract public DbDialect getDbDialect();

    abstract public Connection getConnection();

    abstract public String getConfigFile();

    abstract public boolean getAutoCommit();
    //endregion

    //region common action
    abstract public  T queryEntity(String sql, Object parameter, Class entityType);

    abstract public  List queryEntities(String sql, Object parameter, Class entityType);

    abstract public  List pageQueryEntities(String sql, PageInfo pageInfo, Object parameter, Class entityType);

    abstract public int executeNonQuery(String sql, Object parameter);
    //endregion

    //region transaction
    abstract public void commit();

    abstract public void rollback();

    abstract public void close();
    //endregion

    //region entity
    abstract public  T select(Object objKey, Class entityType);

    abstract public  List selectList(Object objParams, Class entityType);

    abstract public  T selectOne(Object objParams, Class entityType);

    abstract public int selectCount(Object objParams, Class entityType);

    abstract public int insert(Object entity);

    abstract public int update(Object entity);

    abstract public int update(Object entity, boolean excludeNullFields);

    abstract public int insertOrUpdate(Object entity);

    abstract public int delete(Object objKey, Class entityType);
    //endregion

    //region public static
    public static DbAccessor get() {
        return DbAccessorFactory.getMyBatisDbAccessor();
    }

    public static DbAccessor create() {
        return DbAccessorFactory.createMyBatisDbAccessor();
    }
    //endregion
}