• Home
• io.github.jinghui70
• rainbow-dbaccess
• 5.2.11
• source code
• Sql.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.

io.github.jinghui70.rainbow.dbaccess.Sql Maven / Gradle / Ivy

package io.github.jinghui70.rainbow.dbaccess;

import io.github.jinghui70.rainbow.dbaccess.mapper.MapRowMapper;
import io.github.jinghui70.rainbow.dbaccess.object.ObjectSql;
import org.springframework.dao.DataAccessException;

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

/**
 * 封装了一个Sql的内容对象
 *
 * @author lijinghui
 */
public class Sql extends GeneralSql {

    public Sql() {
        super();
    }

    public Sql(String str) {
        super(str);
    }

    public Sql(Dba dba) {
        super(dba);
    }

    public  ObjectSql from(Class queryClass) {
        return new ObjectSql<>(dba, queryClass).append(getSql()).from(DbaUtil.tableName(queryClass));
    }

    public List> queryForList() throws DataAccessException {
        return queryForList(MapRowMapper.INSTANCE);
    }

    public PageData> pageQuery(int pageNo, int pageSize) {
        return pageQuery(MapRowMapper.INSTANCE, pageNo, pageSize);
    }

    public List> queryForTree() {
        return queryForTree(MapRowMapper.INSTANCE);
    }

    public  Map> queryToMap(ResultSetFunction keyFunc) {
        return queryToMap(keyFunc, MapRowMapper.INSTANCE);
    }

    public  Map>> queryToGroup(ResultSetFunction keyFunc) {
        return queryToGroup(keyFunc, MapRowMapper.INSTANCE);
    }

}