FetchTestRunner.java 2.6 KB
Newer Older
M
MaxKey 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
/*
 * Copyright [2022] [MaxKey of copyright http://www.maxkey.top]
 * 
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * 
 *     http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
 

package org.dromara.mybatis.jpa.test;

import java.util.List;

import org.dromara.mybatis.jpa.entity.JpaPage;
import org.dromara.mybatis.jpa.entity.JpaPageResults;
import org.dromara.mybatis.jpa.query.Query;
import org.dromara.mybatis.jpa.test.dao.service.StudentsService;
import org.dromara.mybatis.jpa.test.entity.Students;
import org.junit.jupiter.api.BeforeAll;
import org.junit.jupiter.api.Test;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

public class FetchTestRunner {
	private static final Logger _logger = LoggerFactory.getLogger(FetchTestRunner.class);
	public static StudentsService service;

	
	
	@Test
	void fetch() throws Exception{
		_logger.info("fetch...");
		 JpaPage page = new JpaPage();
		 Students student = new Students();
		 student.setStdGender("M");
		 student.setStdAge(40);
		 page.setPageSize(20);
		 page.setPageable(true);
		 
		 JpaPageResults<Students>  results = service.fetch(page,student);
		 List<Students> rowsStudents = results.getRows();
		 _logger.info("records {} , totalPage {} , total {} , page {} ",
				 results.getRecords(),results.getTotalPage(),results.getTotal(),results.getPage());
		 for (Students s : rowsStudents) {
			 _logger.info("Students "+s);
		 }
	}
	
	@Test
	void fetchByCondition() throws Exception{
		_logger.info("fetchByCondition...");
		 JpaPage page = new JpaPage();
		 page.setPageSize(20);
		 page.setPageable(true);
		 
M
readme  
MaxKey 已提交
64 65
		 Query condition = new Query().eq("stdMajor", "政治").and().gt("STDAGE", 30);
		 
M
MaxKey 已提交
66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
		 JpaPageResults<Students>  results = service.fetch(page,condition);
		 List<Students> rowsStudents = results.getRows();
		 _logger.info("records {} , totalPage {} , total {} , page {} ",
				 results.getRecords(),results.getTotalPage(),results.getTotal(),results.getPage());
		 for (Students s : rowsStudents) {
			 _logger.info("Students "+s);
		 }
	}
	
	@BeforeAll
	public static void initSpringContext(){
		if(InitContext.context!=null) return;
		service = new InitContext().init();
	}

}