@Test public void findSelectEntityPageList() throws Exception { List<TaskSqlView> list = selectEntityDao.findSelectEntityPageList(paging); System.out.println("findSelectEntityPageList :-------> " + list); Assert.assertTrue(list.size() > 0); }
public List<TaskSqlView> findSelectEntityPageList(Paging<TaskSql> paging) throws SQLException { String sql = "select t1.id, t1.project_id, t1.class_name, t1.pojo_name, t1.method_name,t1.sql_content,t1.update_user_no,t1.update_time,t1.dbset_id,t2.user_real_name, t1.comment, t1.field_type, t3.name as dbset_name from task_sql t1 " + " join login_users t2 on t1.update_user_no = t2.user_no " + " join databaseset t3 on t1.dbset_id = t3.id" + appenCondition(paging); return this.queryBySql(sql, TaskSqlView.class); }
SelectEntityDao extends BaseDao { public List<TaskSqlView> findSelectEntityPageList(Paging<TaskSql> paging) throws SQLException { String sql = "select t1.id, t1.project_id, t1.class_name, t1.pojo_name, t1.method_name,t1.sql_content,t1.update_user_no,t1.update_time,t1.dbset_id,t2.user_real_name, t1.comment, t1.field_type, t3.name as dbset_name from task_sql t1 " + " join login_users t2 on t1.update_user_no = t2.user_no " + " join databaseset t3 on t1.dbset_id = t3.id" + appenCondition(paging); return this.queryBySql(sql, TaskSqlView.class); } }
SelectEntityDao extends BaseDao { public List<TaskSqlView> findSelectEntityPageList(Paging<TaskSql> paging) throws SQLException { String sql = "select t1.id, t1.project_id, t1.class_name, t1.pojo_name, t1.method_name,t1.sql_content,t1.update_user_no,t1.update_time,t1.dbset_id,t2.user_real_name, t1.comment, t1.field_type, t3.name as dbset_name from task_sql t1 " + " join login_users t2 on t1.update_user_no = t2.user_no " + " join databaseset t3 on t1.dbset_id = t3.id" + appenCondition(paging); return this.queryBySql(sql, TaskSqlView.class); }  }
SelectEntityDao extends BaseDao { public List<TaskSqlView> findSelectEntityPageList(Paging<TaskSql> paging) throws SQLException { String sql = "select t1.id, t1.project_id, t1.class_name, t1.pojo_name, t1.method_name,t1.sql_content,t1.update_user_no,t1.update_time,t1.dbset_id,t2.user_real_name, t1.comment, t1.field_type, t3.name as dbset_name from task_sql t1 " + " join login_users t2 on t1.update_user_no = t2.user_no " + " join databaseset t3 on t1.dbset_id = t3.id" + appenCondition(paging); return this.queryBySql(sql, TaskSqlView.class); }  Long insertTask(TaskSql task); int updateTask(TaskSql task); int deleteTask(TaskSql task); int deleteByProjectId(Long projectId); TaskSql getTasksByTaskId(Long id); Long getSelectEntityTotalCount(Paging<TaskSql> paging); List<TaskSqlView> findSelectEntityPageList(Paging<TaskSql> paging); }
SelectEntityDao extends BaseDao { public List<TaskSqlView> findSelectEntityPageList(Paging<TaskSql> paging) throws SQLException { String sql = "select t1.id, t1.project_id, t1.class_name, t1.pojo_name, t1.method_name,t1.sql_content,t1.update_user_no,t1.update_time,t1.dbset_id,t2.user_real_name, t1.comment, t1.field_type, t3.name as dbset_name from task_sql t1 " + " join login_users t2 on t1.update_user_no = t2.user_no " + " join databaseset t3 on t1.dbset_id = t3.id" + appenCondition(paging); return this.queryBySql(sql, TaskSqlView.class); }  Long insertTask(TaskSql task); int updateTask(TaskSql task); int deleteTask(TaskSql task); int deleteByProjectId(Long projectId); TaskSql getTasksByTaskId(Long id); Long getSelectEntityTotalCount(Paging<TaskSql> paging); List<TaskSqlView> findSelectEntityPageList(Paging<TaskSql> paging);  }