java when otherwise_Mybatis（九）- choose when otherwise 标签例子

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

SELECT * FROM product_

and name like concat('%',#{name},'%')

and price > #{price}

and id >1

package com.how2java;

import java.io.IOException;

import java.io.InputStream;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.how2java.pojo.Product;

public class TestMybatis {

public static void main(String[] args) throws IOException {

String resource = "mybatis-config.xml";

InputStream inputStream = Resources.getResourceAsStream(resource);

SqlSessionFactory sqlSessionFactory = newSqlSessionFactoryBuilder().build(inputStream);

SqlSession session = sqlSessionFactory.openSession();

Map params = new HashMap<>();

// params.put("name","a");

// params.put("price","10");

List ps = session.selectList("listProduct",params);

for (Product p : ps) {

System.out.println(p);

}

session.commit();

session.close();

}

private static void listAll(SqlSession session) {

}

}

更多内容，点击了解： https://how2j.cn/k/mybatis/mybatis-choose/1113.html