src/main/resources/mapper/KebiaoxinxiDao.xml

微信扫码关注公众号，代码整理好后第一时间通知你。

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.dao.KebiaoxinxiDao">

	<!-- 可根据自己的需求，是否要使用 -->
    <resultMap type="com.entity.KebiaoxinxiEntity" id="kebiaoxinxiMap">
        <result property="banji" column="banji"/>
        <result property="xingqi" column="xingqi"/>
        <result property="kechengtu" column="kechengtu"/>
        <result property="kechengyi" column="kechengyi"/>
        <result property="kechenger" column="kechenger"/>
        <result property="kechengsan" column="kechengsan"/>
        <result property="kechengsi" column="kechengsi"/>
        <result property="kechengwu" column="kechengwu"/>
        <result property="kechengliu" column="kechengliu"/>
        <result property="kechengqi" column="kechengqi"/>
        <result property="jiaoshigonghao" column="jiaoshigonghao"/>
        <result property="jiaoshixingming" column="jiaoshixingming"/>
    </resultMap>

	<select id="selectListVO"
		resultType="com.entity.vo.KebiaoxinxiVO" >
		SELECT * FROM kebiaoxinxi  kebiaoxinxi         
        <where> 1=1 ${ew.sqlSegment}</where>
	</select>
	
	<select id="selectVO"
		resultType="com.entity.vo.KebiaoxinxiVO" >
		SELECT  kebiaoxinxi.* FROM kebiaoxinxi  kebiaoxinxi
 		<where> 1=1 ${ew.sqlSegment}</where>
	</select>

    <select id="selectListView"
		resultType="com.entity.view.KebiaoxinxiView" >

		SELECT  kebiaoxinxi.* FROM kebiaoxinxi  kebiaoxinxi 	        
        <where> 1=1 ${ew.sqlSegment}</where>
	</select>
	
	<select id="selectView"
		resultType="com.entity.view.KebiaoxinxiView" >
		SELECT * FROM kebiaoxinxi  kebiaoxinxi <where> 1=1 ${ew.sqlSegment}</where>
	</select>
	
	
</mapper>