@Test public void getDataBaseSetEntryById() throws Exception { DatabaseSetEntry databaseSetEntryView = dataBaseSetEntryDao.getDataBaseSetEntryById(601L); System.out.println("getDataBaseSetEntryById :-------> " + databaseSetEntryView); Assert.assertTrue(databaseSetEntryView != null); }
public DatabaseSetEntry getDataBaseSetEntryById(Long id) throws SQLException { String sql = "SELECT t1.id, name, t1.database_type, t1.sharding, t1.db_Id, t1.dbset_id, t1.update_user_no, t1.update_time , t2.db_catalog FROM databasesetentry t1 " + "left join alldbs t2 on t2.id = t1.db_Id where t1.id = " + id; List<DatabaseSetEntry> list = this.queryBySql(sql, DatabaseSetEntry.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }
DataBaseSetEntryDao extends BaseDao { public DatabaseSetEntry getDataBaseSetEntryById(Long id) throws SQLException { String sql = "SELECT t1.id, name, t1.database_type, t1.sharding, t1.db_Id, t1.dbset_id, t1.update_user_no, t1.update_time , t2.db_catalog FROM databasesetentry t1 " + "left join alldbs t2 on t2.id = t1.db_Id where t1.id = " + id; List<DatabaseSetEntry> list = this.queryBySql(sql, DatabaseSetEntry.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; } }
DataBaseSetEntryDao extends BaseDao { public DatabaseSetEntry getDataBaseSetEntryById(Long id) throws SQLException { String sql = "SELECT t1.id, name, t1.database_type, t1.sharding, t1.db_Id, t1.dbset_id, t1.update_user_no, t1.update_time , t2.db_catalog FROM databasesetentry t1 " + "left join alldbs t2 on t2.id = t1.db_Id where t1.id = " + id; List<DatabaseSetEntry> list = this.queryBySql(sql, DatabaseSetEntry.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }  }
DataBaseSetEntryDao extends BaseDao { public DatabaseSetEntry getDataBaseSetEntryById(Long id) throws SQLException { String sql = "SELECT t1.id, name, t1.database_type, t1.sharding, t1.db_Id, t1.dbset_id, t1.update_user_no, t1.update_time , t2.db_catalog FROM databasesetentry t1 " + "left join alldbs t2 on t2.id = t1.db_Id where t1.id = " + id; List<DatabaseSetEntry> list = this.queryBySql(sql, DatabaseSetEntry.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }  Long insertDatabaseSetEntry(DatabaseSetEntry dbsetEntry); int[] insertDatabaseSetEntrylist(List<DatabaseSetEntry> dbsetEntryList); int updateDatabaseSetEntry(DatabaseSetEntry dbsetEntry); int deleteDatabaseSetEntryById(Long id); Long getCountByName(String name); Long getCountByIdAndName(Long id, String name); List<DatabaseSetEntry> getAllDbSetEntryByDbSetId(Long dbset_id); DatabaseSetEntry getDataBaseSetEntryById(Long id); DatabaseSetEntryView getDataBaseSetEntryByDbId(Long dataBaseId); List<DatabaseSetEntryView> getDataBaseSetEntryListByDbSetId(Long dbsetId); List<DatabaseSetEntry> getAllDbSetEntryByDbSetIds(List<Integer> dbset_ids); List<DatabaseSetEntry> getDatabaseSetEntrysByDbNames(List<String> names); Long getDbSetEntryTotalCount(Paging<DatabaseSetEntry> paging); List<DatabaseSetEntryView> findDbSetEntryPageList(Paging<DatabaseSetEntry> paging); }
DataBaseSetEntryDao extends BaseDao { public DatabaseSetEntry getDataBaseSetEntryById(Long id) throws SQLException { String sql = "SELECT t1.id, name, t1.database_type, t1.sharding, t1.db_Id, t1.dbset_id, t1.update_user_no, t1.update_time , t2.db_catalog FROM databasesetentry t1 " + "left join alldbs t2 on t2.id = t1.db_Id where t1.id = " + id; List<DatabaseSetEntry> list = this.queryBySql(sql, DatabaseSetEntry.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }  Long insertDatabaseSetEntry(DatabaseSetEntry dbsetEntry); int[] insertDatabaseSetEntrylist(List<DatabaseSetEntry> dbsetEntryList); int updateDatabaseSetEntry(DatabaseSetEntry dbsetEntry); int deleteDatabaseSetEntryById(Long id); Long getCountByName(String name); Long getCountByIdAndName(Long id, String name); List<DatabaseSetEntry> getAllDbSetEntryByDbSetId(Long dbset_id); DatabaseSetEntry getDataBaseSetEntryById(Long id); DatabaseSetEntryView getDataBaseSetEntryByDbId(Long dataBaseId); List<DatabaseSetEntryView> getDataBaseSetEntryListByDbSetId(Long dbsetId); List<DatabaseSetEntry> getAllDbSetEntryByDbSetIds(List<Integer> dbset_ids); List<DatabaseSetEntry> getDatabaseSetEntrysByDbNames(List<String> names); Long getDbSetEntryTotalCount(Paging<DatabaseSetEntry> paging); List<DatabaseSetEntryView> findDbSetEntryPageList(Paging<DatabaseSetEntry> paging);  }