public boolean insertFY(final FamilyMemberBean bean){
String sql = "merge into d302 a "+
"using (select 1 from dual ) b "+
"on (a.d302_00=? and a.D302_01=?) "+
"when matched then "+
"update set D601_09= ?,D302_03=?,D302_04=decode(helpAmount,null,0,helpAmount), "+
"D302_05=null,D302_06=0,D302_16=?,D302_17=?,D302_18=? "+
"when not matched then "+
"insert ( "+
"D302_00,D302_01,D601_09,D302_03,D302_04, "+
"D601_20,D302_22,D302_24 ) values "+
"( "+
"?, ?, ?, ?, decode(helpAmount,null,0,helpAmount)," +
" ?,?,? "+
" ) ";
return this.jdbcTemplate.update(sql,new Object[]{参数})>0?true:false;
}
