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

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

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

package cn.pzhu.pserson.dao.provider;


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

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

public class UserDynaSqlProvider {
			// 动态插入
			public String insert_UserInfo(User user){
				
				return new SQL(){
					{
						INSERT_INTO(USERTABLE);
						if(user.getLoginname() != null ){
							VALUES("loginname", "#{loginname}");
						}
						if(user.getPassword()!=null){
							VALUES("password","#{password}");
						}
						if(user.getLevel()!=null){
							VALUES("level","#{level}");
						}
						if(user.getCreatedate()!=null){
							VALUES("createdate","#{createdate}");
						}
						if(user.getUsername()!=null){
							VALUES("username","#{username}");
						}
						if(user.getStatus()!=null){
							VALUES("status","#{status}");
						}
						if(user.getCardId()!=null){
							VALUES("card_id","#{cardId}");
						}
						if(user.getSex()!=null){
							VALUES("sex","#{sex}");
						}
						if(user.getEducation()!=null){
							VALUES("education","#{education}");
						}
						if(user.getSchool()!=null){
							VALUES("school","#{school}");
						}
						if(user.getMajor()!=null){
							VALUES("major","#{major}");
						}
						if(user.getEmail()!=null){
							VALUES("email","#{email}");
						}
						if(user.getPhone()!=null){
							VALUES("phone","#{phone}");
						}
						if(user.getAddress()!=null){
							VALUES("address","#{address}");
						}
						if(user.getJobId()!=null){
							VALUES("job_id","#{jobId}");
						}