//mapper中我們要為這個(gè)方法傳遞的是一個(gè)容器,將容器中的元素一個(gè)一個(gè)的
//拼接到xml的方法中就要使用這個(gè)forEach這個(gè)標(biāo)簽了
public List queryById(List userids);

//對(duì)應(yīng)的xml中如下

select * FROM entity
where id in

#{userid}

//比如說(shuō)我們想要進(jìn)行條件查詢,但是幾個(gè)條件不是每次都要使用,那么我們就可以
//通過(guò)判斷是否拼接到sql中

SELECT * from entity


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

SELECT *
FROM User u



u.username LIKE CONCAT(CONCAT('%', #{username, jdbcType=VARCHAR}),'%')


AND u.sex = #{sex, jdbcType=INTEGER}


AND u.birthday = #{birthday, jdbcType=DATE}

select nextval('student')

INSERT INTO STUDENT_TBL(STUDENT_ID,
STUDENT_NAME,
STUDENT_SEX,
STUDENT_BIRTHDAY,
STUDENT_PHOTO,
CLASS_ID,
PLACE_ID)
VALUES (#{studentId},
#{studentName},
#{studentSex},
#{studentBirthday},
#{studentPhoto, javaType=byte[], jdbcType=BLOB, typeHandler=org.apache.ibatis.type.BlobTypeHandler},
#{classId},
#{placeId})

StudentEntity entity = new StudentEntity();
entity.setStudentName("黎明你好");
entity.setStudentSex(1);
entity.setStudentBirthday(DateUtil.parse("1985-05-28"));
entity.setClassId("20000001");
entity.setPlaceId("70000001");
this.dynamicSqlMapper.createStudentAutoKey(entity);
System.out.println("新增學(xué)生ID: " + entity.getStudentId());

SELECT * from STUDENT_TBL ST
WHERE ST.STUDENT_NAME LIKE CONCAT(CONCAT('%', #{studentName}),'%')

SELECT ST.STUDENT_ID,
ST.STUDENT_NAME,
ST.STUDENT_SEX,
ST.STUDENT_BIRTHDAY,
ST.STUDENT_PHOTO,
ST.CLASS_ID,
ST.PLACE_ID
FROM STUDENT_TBL ST
WHERE

ST.STUDENT_NAME LIKE CONCAT(CONCAT('%', #{studentName, jdbcType=VARCHAR}),'%')


AND ST.STUDENT_SEX = #{studentSex, jdbcType=INTEGER}


AND ST.STUDENT_BIRTHDAY = #{studentBirthday, jdbcType=DATE}


AND ST.CLASS_ID = #{classId, jdbcType=VARCHAR}


AND ST.CLASS_ID = #{classEntity.classId, jdbcType=VARCHAR}


AND ST.PLACE_ID = #{placeId, jdbcType=VARCHAR}


AND ST.PLACE_ID = #{placeEntity.placeId, jdbcType=VARCHAR}


AND ST.STUDENT_ID = #{studentId, jdbcType=VARCHAR}

public void select_test_2_1() {
StudentEntity entity = new StudentEntity();
entity.setStudentName("");
entity.setStudentSex(1);
entity.setStudentBirthday(DateUtil.parse("1985-05-28"));
entity.setClassId("20000001");
//entity.setPlaceId("70000001");
List list = this.dynamicSqlMapper.getStudentList_if(entity);
for (StudentEntity e : list) {
System.out.println(e.toString());
}
}

@Test
public void select_test_2_1() {
StudentEntity entity = new StudentEntity();
entity.setStudentName(null);
entity.setStudentSex(1);
List list = this.dynamicSqlMapper.getStudentList_if(entity);
for (StudentEntity e : list) {
System.out.println(e.toString());
}
}

SELECT ST.STUDENT_ID,
ST.STUDENT_NAME,
ST.STUDENT_SEX,
ST.STUDENT_BIRTHDAY,
ST.STUDENT_PHOTO,
ST.CLASS_ID,
ST.PLACE_ID
FROM STUDENT_TBL ST


ST.STUDENT_NAME LIKE CONCAT(CONCAT('%', #{studentName, jdbcType=VARCHAR}),'%')


AND ST.STUDENT_SEX = #{studentSex, jdbcType=INTEGER}


AND ST.STUDENT_BIRTHDAY = #{studentBirthday, jdbcType=DATE}


AND ST.CLASS_ID = #{classId, jdbcType=VARCHAR}


AND ST.CLASS_ID = #{classEntity.classId, jdbcType=VARCHAR}


AND ST.PLACE_ID = #{placeId, jdbcType=VARCHAR}


AND ST.PLACE_ID = #{placeEntity.placeId, jdbcType=VARCHAR}


AND ST.STUDENT_ID = #{studentId, jdbcType=VARCHAR}

UPDATE STUDENT_TBL


STUDENT_TBL.STUDENT_NAME = #{studentName},


STUDENT_TBL.STUDENT_SEX = #{studentSex},


STUDENT_TBL.STUDENT_BIRTHDAY = #{studentBirthday},


STUDENT_TBL.STUDENT_PHOTO = #{studentPhoto, javaType=byte[], jdbcType=BLOB, typeHandler=org.apache.ibatis.type.BlobTypeHandler},


STUDENT_TBL.CLASS_ID = #{classId}


STUDENT_TBL.PLACE_ID = #{placeId}


WHERE STUDENT_TBL.STUDENT_ID = #{studentId};

SELECT ST.STUDENT_ID,
ST.STUDENT_NAME,
ST.STUDENT_SEX,
ST.STUDENT_BIRTHDAY,
ST.STUDENT_PHOTO,
ST.CLASS_ID,
ST.PLACE_ID
FROM STUDENT_TBL ST


ST.STUDENT_NAME LIKE CONCAT(CONCAT('%', #{studentName, jdbcType=VARCHAR}),'%')


AND ST.STUDENT_SEX = #{studentSex, jdbcType=INTEGER}


AND ST.STUDENT_BIRTHDAY = #{studentBirthday, jdbcType=DATE}


AND ST.CLASS_ID = #{classId, jdbcType=VARCHAR}


AND ST.CLASS_ID = #{classEntity.classId, jdbcType=VARCHAR}


AND ST.PLACE_ID = #{placeId, jdbcType=VARCHAR}


AND ST.PLACE_ID = #{placeEntity.placeId, jdbcType=VARCHAR}


AND ST.STUDENT_ID = #{studentId, jdbcType=VARCHAR}

UPDATE STUDENT_TBL


STUDENT_TBL.STUDENT_NAME = #{studentName},


STUDENT_TBL.STUDENT_SEX = #{studentSex},


STUDENT_TBL.STUDENT_BIRTHDAY = #{studentBirthday},


STUDENT_TBL.STUDENT_PHOTO = #{studentPhoto, javaType=byte[], jdbcType=BLOB, typeHandler=org.apache.ibatis.type.BlobTypeHandler},


STUDENT_TBL.CLASS_ID = #{classId},


STUDENT_TBL.PLACE_ID = #{placeId}


WHERE STUDENT_TBL.STUDENT_ID = #{studentId}

public List getStudentListByClassIds_foreach_array(String[] classIds); 

SELECT ST.STUDENT_ID,
ST.STUDENT_NAME,
ST.STUDENT_SEX,
ST.STUDENT_BIRTHDAY,
ST.STUDENT_PHOTO,
ST.CLASS_ID,
ST.PLACE_ID
FROM STUDENT_TBL ST
WHERE ST.CLASS_ID IN

#{classIds}

@Test
public void test7_foreach() {
String[] classIds = { "20000001", "20000002" };
List list = this.dynamicSqlMapper.getStudentListByClassIds_foreach_array(classIds);
for (StudentEntity e : list) {
System.out.println(e.toString());
}
}

public List getStudentListByClassIds_foreach_list(List classIdList); 

SELECT ST.STUDENT_ID,
ST.STUDENT_NAME,
ST.STUDENT_SEX,
ST.STUDENT_BIRTHDAY,
ST.STUDENT_PHOTO,
ST.CLASS_ID,
ST.PLACE_ID
FROM STUDENT_TBL ST
WHERE ST.CLASS_ID IN

#{classIdList}

@Test
public void test7_2_foreach() {
ArrayList classIdList = new ArrayList();
classIdList.add("20000001");
classIdList.add("20000002");
List list = this.dynamicSqlMapper.getStudentListByClassIds_foreach_list(classIdList);
for (StudentEntity e : list) {
System.out.println(e.toString());
}

o.order_id,o.cid,o.address,o.create_date,o.orderitem_id,i.orderitem_id,i.product_id,i.count



select


from ordertable o
join orderitem i on o.orderitem_id = i.orderitem_id
where o.order_id = #{orderId}