• Home
• com.github.jingshouyan
• j-jdbc-test
• 1.3.0
• source code
• ColumnDaoImpl.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.jingshouyan.dao.impl.ColumnDaoImpl Maven / Gradle / Ivy

package com.jingshouyan.dao.impl;

import com.github.jingshouyan.jdbc.core.dao.impl.BaseDaoImpl;
import com.google.common.collect.Maps;
import com.jingshouyan.bean.ColumnDO;
import com.jingshouyan.dao.ColumnDao;
import org.springframework.stereotype.Repository;

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

/**
 * @author jingshouyan
 * 11/29/18 5:27 PM
 */
@Repository
public class ColumnDaoImpl extends BaseDaoImpl implements ColumnDao {


    @Override
    public List listBySchema(String schema) {
        String sql = "SELECT\n" +
                "\ttable_schema,\n" +
                "\tTABLE_NAME,\n" +
                "\tCOLUMN_NAME,\n" +
                "\tCOLUMN_TYPE,\n" +
                "\tCOLUMN_COMMENT \n" +
                "FROM\n" +
                "\tINFORMATION_SCHEMA.COLUMNS \n" +
                "WHERE\n" +
                "\ttable_schema = :schema \n" +
                "\tAND ( TABLE_NAME LIKE '%\\_0' OR TABLE_NAME NOT REGEXP '[0-9]$' ) ";
        Map params = Maps.newHashMap();
        params.put("schema", schema);
        return template.query(sql, params, rowMapper);
    }
}