<?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.thinkgem.jeesite.modules.jy.dao.fw.JyFwDao">
    
	<sql id="jyFwColumns">
		a.id AS "id",
		a.a AS "a",
		a.b AS "b",
		a.c AS "c",
		a.d AS "d",
		a.e AS "e",
		a.f AS "f",
		a.g AS "g",
		a.h AS "h",
		a.i AS "i",
		a.j AS "j",
		a.k AS "k",
		a.l AS "l",
		a.m AS "m",
		a.n AS "n",
		a.o AS "o",
		a.p AS "p",
		a.q AS "q",
		a.r AS "r",
		a.s AS "s",
		a.bdcdyh AS "bdcdyh"
	</sql>
	
	<sql id="jyFwJoins">
	</sql>
    
	<select id="get" resultType="JyFw">
		SELECT 
			<include refid="jyFwColumns"/>
		FROM jy_fw a
		<include refid="jyFwJoins"/>
		WHERE a.id = #{id}
	</select>
	
	<select id="findList" resultType="JyFw">
		SELECT 
			<include refid="jyFwColumns"/>
		FROM jy_fw a
		<include refid="jyFwJoins"/>
		<where>
			
		</where>
		<choose>
			<when test="page !=null and page.orderBy != null and page.orderBy != ''">
				ORDER BY ${page.orderBy}
			</when>
			<otherwise>
			</otherwise>
		</choose>
	</select>
	
	<select id="findAllList" resultType="JyFw">
		SELECT 
			<include refid="jyFwColumns"/>
		FROM jy_fw a
		<include refid="jyFwJoins"/>
		<where>
			
		</where>		
		<choose>
			<when test="page !=null and page.orderBy != null and page.orderBy != ''">
				ORDER BY ${page.orderBy}
			</when>
			<otherwise>
			</otherwise>
		</choose>
	</select>
	
	<insert id="insert">
		INSERT INTO jy_fw(
			id,
			a,
			b,
			c,
			d,
			e,
			f,
			g,
			h,
			i,
			j,
			k,
			l,
			m,
			n,
			o,
			p,
			q,
			r,
			s,
			bdcdyh
		) VALUES (
			#{id},
			#{a},
			#{b},
			#{c},
			#{d},
			#{e},
			#{f},
			#{g},
			#{h},
			#{i},
			#{j},
			#{k},
			#{l},
			#{m},
			#{n},
			#{o},
			#{p},
			#{q},
			#{r},
			#{s},
			#{bdcdyh}
		)
	</insert>
	
	<update id="update">
		UPDATE jy_fw SET 	
			a = #{a},
			b = #{b},
			c = #{c},
			d = #{d},
			e = #{e},
			f = #{f},
			g = #{g},
			h = #{h},
			i = #{i},
			j = #{j},
			k = #{k},
			l = #{l},
			m = #{m},
			n = #{n},
			o = #{o},
			p = #{p},
			q = #{q},
			r = #{r},
			s = #{s},
			bdcdyh = #{bdcdyh}
		WHERE id = #{id}
	</update>
	
	<update id="delete">
		DELETE FROM jy_fw
		WHERE id = #{id}
	</update>
	
</mapper>