@Test public void getMasterCologByDatabaseSetId() throws Exception { DataBaseInfo dataBaseInfo = dataBaseDao.getMasterCologByDatabaseSetId(54L); System.out.println("getMasterCologByDatabaseSetId :-------> " + dataBaseInfo); Assert.assertTrue(dataBaseInfo != null); }
public DataBaseInfo getMasterCologByDatabaseSetId(Long dbset_id) throws SQLException { String sql = "SELECT db.id, db.db_name, db.dal_group_id, db.db_address, db.db_port, db.db_user, db.db_catalog, db.db_password, db.db_type, db.insert_time, db.update_time, db.comment " + "FROM alldbs as db " + "inner join databasesetentry as en on en.db_Id = db.id " + "WHERE en.database_type = 1 and en.dbset_id = " + dbset_id + " order by en.id asc limit 1 "; List<DataBaseInfo> list = this.queryBySql(sql, DataBaseInfo.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }
DataBaseDao extends BaseDao { public DataBaseInfo getMasterCologByDatabaseSetId(Long dbset_id) throws SQLException { String sql = "SELECT db.id, db.db_name, db.dal_group_id, db.db_address, db.db_port, db.db_user, db.db_catalog, db.db_password, db.db_type, db.insert_time, db.update_time, db.comment " + "FROM alldbs as db " + "inner join databasesetentry as en on en.db_Id = db.id " + "WHERE en.database_type = 1 and en.dbset_id = " + dbset_id + " order by en.id asc limit 1 "; List<DataBaseInfo> list = this.queryBySql(sql, DataBaseInfo.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; } }
DataBaseDao extends BaseDao { public DataBaseInfo getMasterCologByDatabaseSetId(Long dbset_id) throws SQLException { String sql = "SELECT db.id, db.db_name, db.dal_group_id, db.db_address, db.db_port, db.db_user, db.db_catalog, db.db_password, db.db_type, db.insert_time, db.update_time, db.comment " + "FROM alldbs as db " + "inner join databasesetentry as en on en.db_Id = db.id " + "WHERE en.database_type = 1 and en.dbset_id = " + dbset_id + " order by en.id asc limit 1 "; List<DataBaseInfo> list = this.queryBySql(sql, DataBaseInfo.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }  }
DataBaseDao extends BaseDao { public DataBaseInfo getMasterCologByDatabaseSetId(Long dbset_id) throws SQLException { String sql = "SELECT db.id, db.db_name, db.dal_group_id, db.db_address, db.db_port, db.db_user, db.db_catalog, db.db_password, db.db_type, db.insert_time, db.update_time, db.comment " + "FROM alldbs as db " + "inner join databasesetentry as en on en.db_Id = db.id " + "WHERE en.database_type = 1 and en.dbset_id = " + dbset_id + " order by en.id asc limit 1 "; List<DataBaseInfo> list = this.queryBySql(sql, DataBaseInfo.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }  Long insertDataBaseInfo(DataBaseInfo dataBaseInfo); int[] insertDatabaselist(List<DataBaseInfo> dataBaseInfoList); int updateDataBaseInfo(DataBaseInfo dataBaseInfo); int updateDataBaseInfo(Long id, String dbname, String db_address, String db_port, String db_user,
                                  String db_password, String db_catalog, Integer db_type, String comment, String updateUserNo); int updateDataBaseInfo(Long id, Long groupId, String comment); int updateDataBaseInfo(Long id, String comment); int updateDataBaseInfo(Long id, Long groupId); int deleteDataBaseInfo(Long id); DataBaseInfo getDataBaseInfoByDbId(Long id); DataBaseInfo getDatabaseByName(String name); List<DataBaseInfo> getAllDbByProjectId(long projectId); List<DataBaseInfo> getAllDbByAppId(String appid); List<String> getAllDbAllinOneNames(); List<DataBaseInfo> getGroupDBsByGroup(Long groupId); Long getCountByName(String dbname); Long getCountByIdAndName(Long id, String dbname); List<DataBaseInfo> getAllDbsByDbNames(List<String> dbNames); List<DataBaseInfo> getAllDbsByIdss(List<Long> ids); DataBaseInfo getMasterCologByDatabaseSetId(Long dbset_id); Long getTotalCount(Paging<DataBaseInfo> paging); List<DataBaseView> findDbPageList(Paging<DataBaseInfo> paging); Long getTotalCountByUserId(Paging<DataBaseInfo> paging, Long userId); List<DataBaseView> findDbPageListByUserId(Paging<DataBaseInfo> paging, Long userId); List<DataBaseInfo> getDatabaseListByLikeName(String dbname); }
DataBaseDao extends BaseDao { public DataBaseInfo getMasterCologByDatabaseSetId(Long dbset_id) throws SQLException { String sql = "SELECT db.id, db.db_name, db.dal_group_id, db.db_address, db.db_port, db.db_user, db.db_catalog, db.db_password, db.db_type, db.insert_time, db.update_time, db.comment " + "FROM alldbs as db " + "inner join databasesetentry as en on en.db_Id = db.id " + "WHERE en.database_type = 1 and en.dbset_id = " + dbset_id + " order by en.id asc limit 1 "; List<DataBaseInfo> list = this.queryBySql(sql, DataBaseInfo.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }  Long insertDataBaseInfo(DataBaseInfo dataBaseInfo); int[] insertDatabaselist(List<DataBaseInfo> dataBaseInfoList); int updateDataBaseInfo(DataBaseInfo dataBaseInfo); int updateDataBaseInfo(Long id, String dbname, String db_address, String db_port, String db_user,
                                  String db_password, String db_catalog, Integer db_type, String comment, String updateUserNo); int updateDataBaseInfo(Long id, Long groupId, String comment); int updateDataBaseInfo(Long id, String comment); int updateDataBaseInfo(Long id, Long groupId); int deleteDataBaseInfo(Long id); DataBaseInfo getDataBaseInfoByDbId(Long id); DataBaseInfo getDatabaseByName(String name); List<DataBaseInfo> getAllDbByProjectId(long projectId); List<DataBaseInfo> getAllDbByAppId(String appid); List<String> getAllDbAllinOneNames(); List<DataBaseInfo> getGroupDBsByGroup(Long groupId); Long getCountByName(String dbname); Long getCountByIdAndName(Long id, String dbname); List<DataBaseInfo> getAllDbsByDbNames(List<String> dbNames); List<DataBaseInfo> getAllDbsByIdss(List<Long> ids); DataBaseInfo getMasterCologByDatabaseSetId(Long dbset_id); Long getTotalCount(Paging<DataBaseInfo> paging); List<DataBaseView> findDbPageList(Paging<DataBaseInfo> paging); Long getTotalCountByUserId(Paging<DataBaseInfo> paging, Long userId); List<DataBaseView> findDbPageListByUserId(Paging<DataBaseInfo> paging, Long userId); List<DataBaseInfo> getDatabaseListByLikeName(String dbname);  }