a.id AS "id", a.yiji AS "yiji", a.erji AS "erji", a.sanji AS "sanji", a.sanjiid AS "sanjiid", a.type AS "type", a.sijiId as "sijiId", a.siji as "siji" SELECT FROM finance_subject a WHERE a.id = #{id} SELECT FROM finance_subject a AND a.yiji = #{yiji} AND a.erji = #{erji} AND a.sanji = #{sanji} AND a.sanjiid = #{sanjiid} AND a.type = #{type} order by #{orderType} desc select * from finance_subject group by erji,yiji order by yiji select * from finance_subject where erji=#{erji} group by sanji,erji order by yiji,erji select * from finance_subject where sanji=#{sanji} group by siji,sanji order by yiji,erji,sanji SELECT FROM finance_subject a ORDER BY ${page.orderBy} INSERT INTO finance_subject( id, yiji, erji, sanji, sanjiid, type ) VALUES ( #{id}, #{yiji}, #{erji}, #{sanji}, #{sanjiid}, #{type} ) UPDATE finance_subject SET yiji = #{yiji}, erji = #{erji}, sanji = #{sanji}, sanjiid = #{sanjiid}, type = #{type} WHERE id = #{id} DELETE FROM finance_subject WHERE id = #{id}