src/main/java/cn/pzhu/pserson/dao/provider/HealthyDynaSqlProvider.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

package cn.pzhu.pserson.dao.provider;


import cn.pzhu.pserson.domain.Healthy;
import org.apache.ibatis.jdbc.SQL;

import static cn.pzhu.pserson.util.Constants.HEALTHYTABLE;

public class HealthyDynaSqlProvider {
			// 动态插入
			public String insert_HealthyInfo(Healthy healthy){
				
				return new SQL(){
					{
						INSERT_INTO(HEALTHYTABLE);
						if(healthy.getCity()!=null){
							VALUES("city","#{city}");
						}
						if(healthy.getIsHighCity()!=null){
							VALUES("is_high_city","#{isHighCity}");
						}
						if(healthy.getIsContactPeople()!=null){
							VALUES("is_contact_people","#{isContactPeople}");
						}
						if(healthy.getTemperature()!=null){
							VALUES("temperature","#{temperature}");
						}
						if(healthy.getCreatedate()!=null){
							VALUES("createdate","#{createdate}");
						}
						if(healthy.getUserId()!=null){
							VALUES("user_id","#{userId}");
						}
					}
				}.toString();
			}	
			// 动态更新
			public String update_HealthyInfo(Healthy healthy){
				
				return new SQL(){
					{
						UPDATE(HEALTHYTABLE);
						if(healthy.getCity() != null ){
							SET("city = #{city}");
						}
						if(healthy.getIsHighCity()!=null){
							SET("is_high_city = #{isHighCity}");
						}
						if(healthy.getIsContactPeople()!=null){
							SET("is_contact_people = #{isContactPeople}");
						}
						if(healthy.getTemperature()!=null){
							SET("temperature = #{temperature}");
						}
						if(healthy.getCreatedate()!=null){
							SET("createdate = #{createdate}");
						}
						if(healthy.getUserId()!=null){
							SET("user_id = #{userId}");
						}