class DataBaseDao extends BaseDao {

    public List<DataBaseInfo> getDatabaseListByLikeName(String dbname) throws SQLException {
        StringBuffer sql = new StringBuffer();
        sql.append("SELECT id, db_name, comment,dal_group_id, db_address, db_port, db_user, db_password, db_catalog, db_type FROM alldbs ");
        if (StringUtils.isNotBlank(dbname)) {
            sql.append("WHERE db_name like '" + dbname + "%' limit 10");
        } else {
            sql.append("limit 10");
        }
        return this.queryBySql(sql.toString(), DataBaseInfo.class);
    }

}