@Test public void findTableEntityPageList() throws Exception { List<TaskTableView> list = tableEntityDao.findTableEntityPageList(paging); System.out.println("findTableEntityPageList :-------> " + list); Assert.assertTrue(list.size() > 0); }
public List<TaskTableView> findTableEntityPageList(Paging<TaskTable> paging) throws SQLException { String sql = "select t1.id, t1.project_id,t1.dbset_id, t1.table_names,t1.custom_table_name,t1.view_names,t1.prefix,suffix, t1.cud_by_sp,t1.pagination,t1.generated,t1.version,t1.update_user_no,t1.update_time,t1.comment,t1.sql_style,t1.api_list,t1.approved,t1.approveMsg,t1.field_type, t2.name as dbset_name, t3.user_real_name from task_table t1 " + " left join databaseset t2 on t1.dbset_id = t2.id " + " left join login_users t3 on t1.update_user_no = t3.user_no " + appenCondition(paging); return this.queryBySql(sql, TaskTableView.class); }
TableEntityDao extends BaseDao { public List<TaskTableView> findTableEntityPageList(Paging<TaskTable> paging) throws SQLException { String sql = "select t1.id, t1.project_id,t1.dbset_id, t1.table_names,t1.custom_table_name,t1.view_names,t1.prefix,suffix, t1.cud_by_sp,t1.pagination,t1.generated,t1.version,t1.update_user_no,t1.update_time,t1.comment,t1.sql_style,t1.api_list,t1.approved,t1.approveMsg,t1.field_type, t2.name as dbset_name, t3.user_real_name from task_table t1 " + " left join databaseset t2 on t1.dbset_id = t2.id " + " left join login_users t3 on t1.update_user_no = t3.user_no " + appenCondition(paging); return this.queryBySql(sql, TaskTableView.class); } }
TableEntityDao extends BaseDao { public List<TaskTableView> findTableEntityPageList(Paging<TaskTable> paging) throws SQLException { String sql = "select t1.id, t1.project_id,t1.dbset_id, t1.table_names,t1.custom_table_name,t1.view_names,t1.prefix,suffix, t1.cud_by_sp,t1.pagination,t1.generated,t1.version,t1.update_user_no,t1.update_time,t1.comment,t1.sql_style,t1.api_list,t1.approved,t1.approveMsg,t1.field_type, t2.name as dbset_name, t3.user_real_name from task_table t1 " + " left join databaseset t2 on t1.dbset_id = t2.id " + " left join login_users t3 on t1.update_user_no = t3.user_no " + appenCondition(paging); return this.queryBySql(sql, TaskTableView.class); }  }
TableEntityDao extends BaseDao { public List<TaskTableView> findTableEntityPageList(Paging<TaskTable> paging) throws SQLException { String sql = "select t1.id, t1.project_id,t1.dbset_id, t1.table_names,t1.custom_table_name,t1.view_names,t1.prefix,suffix, t1.cud_by_sp,t1.pagination,t1.generated,t1.version,t1.update_user_no,t1.update_time,t1.comment,t1.sql_style,t1.api_list,t1.approved,t1.approveMsg,t1.field_type, t2.name as dbset_name, t3.user_real_name from task_table t1 " + " left join databaseset t2 on t1.dbset_id = t2.id " + " left join login_users t3 on t1.update_user_no = t3.user_no " + appenCondition(paging); return this.queryBySql(sql, TaskTableView.class); }  Long insertTask(TaskTable task); int[] insertTaskTablelist(List<TaskTable> list); int updateTask(TaskTable taskTable); int deleteTask(TaskTable taskTable); int deleteByProjectId(int id); TaskTable getTasksByTaskId(Long id); List<TaskTable> getTaskTableByCustomTableNames(Long project_id, List<String> names); List<TaskTable> getTaskTablesByTableNames(Long project_id, List<String> names); List<TaskTableView> getTasksByProjectId(Long projectId); Long getTableEntityTotalCount(Paging<TaskTable> paging); List<TaskTableView> findTableEntityPageList(Paging<TaskTable> paging); List<TaskTableView> findTableEntitysByDbId(Long paging); }
TableEntityDao extends BaseDao { public List<TaskTableView> findTableEntityPageList(Paging<TaskTable> paging) throws SQLException { String sql = "select t1.id, t1.project_id,t1.dbset_id, t1.table_names,t1.custom_table_name,t1.view_names,t1.prefix,suffix, t1.cud_by_sp,t1.pagination,t1.generated,t1.version,t1.update_user_no,t1.update_time,t1.comment,t1.sql_style,t1.api_list,t1.approved,t1.approveMsg,t1.field_type, t2.name as dbset_name, t3.user_real_name from task_table t1 " + " left join databaseset t2 on t1.dbset_id = t2.id " + " left join login_users t3 on t1.update_user_no = t3.user_no " + appenCondition(paging); return this.queryBySql(sql, TaskTableView.class); }  Long insertTask(TaskTable task); int[] insertTaskTablelist(List<TaskTable> list); int updateTask(TaskTable taskTable); int deleteTask(TaskTable taskTable); int deleteByProjectId(int id); TaskTable getTasksByTaskId(Long id); List<TaskTable> getTaskTableByCustomTableNames(Long project_id, List<String> names); List<TaskTable> getTaskTablesByTableNames(Long project_id, List<String> names); List<TaskTableView> getTasksByProjectId(Long projectId); Long getTableEntityTotalCount(Paging<TaskTable> paging); List<TaskTableView> findTableEntityPageList(Paging<TaskTable> paging); List<TaskTableView> findTableEntitysByDbId(Long paging);  }