/** * Copyright (c) 2011-2014, hubin (jobob@qq.com). * <p> * 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 * <p> * http://www.apache.org/licenses/LICENSE-2.0 * <p> * 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 com.baomidou.mybatisplus.test.mysql; import java.io.InputStream; import java.util.HashMap; import java.util.List; import java.util.Map; import org.apache.ibatis.session.RowBounds; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import com.baomidou.mybatisplus.MybatisSessionFactoryBuilder; import com.baomidou.mybatisplus.plugins.Page; import com.baomidou.mybatisplus.test.mysql.entity.Test; import com.baomidou.mybatisplus.test.mysql.mapper.TestMapper; import com.baomidou.mybatisplus.toolkit.IdWorker; /** * <p> * 测试没有XML同样注入CRUD SQL * </p> * * @author Caratacus * @date 2016-09-26 */ public class NoXMLTest { public static void main(String[] args) { /* * 加载配置文件 */ InputStream in = NoXMLTest.class.getClassLoader().getResourceAsStream("mysql-config.xml"); MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder(); SqlSessionFactory sessionFactory = mf.build(in); SqlSession sqlSession = sessionFactory.openSession(); /** * 查询是否有结果 */ TestMapper testMapper = sqlSession.getMapper(TestMapper.class); testMapper.insert(new Test(IdWorker.getId(), "Caratacus")); List<Map<String, Object>> list = testMapper.selectMaps(null); List<Map<String, Object>> list1 = testMapper.selectMapsPage(RowBounds.DEFAULT, null); List<Map<String, Object>> list2 = testMapper.selectMapsPage(new Page<>(1, 5), null); System.out.println(list); System.out.println(list1); System.out.println(list2); Map<String, Object> map = new HashMap<>(); map.put("type", null); map.put("id", null); List<Test> tests = testMapper.selectByMap(map); if (null != tests) { for (Test test : tests) { System.out.println("id:" + test.getId() + " , type:" + test.getType()); } } else { System.err.println(" tests is null. "); } testMapper.delete(null); } }