class DataBaseDao extends BaseDao {

    public List<DataBaseView> findDbPageList(Paging<DataBaseInfo> paging) throws SQLException {
        String sql = "SELECT a.id,a.db_name,a.dal_group_id,a.db_address,a.db_port,a.db_user,a.db_password,a.db_catalog,a.db_type,a.comment,b.group_name,a.insert_time, c.user_real_name,a.update_time " +
                "FROM alldbs a LEFT JOIN dal_group b ON b.id = a.dal_group_id " +
                "left join login_users c on a.update_user_no = c.user_no " + appenCondition(paging);
        return this.queryBySql(sql, DataBaseView.class);
    }

}