src/com/rain/dao/provider/EmployeeDynaSqlProvider.java

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

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

package com.rain.dao.provider;

import static com.rain.util.common.Constants.EMPLOYEETABLE;

import org.apache.ibatis.jdbc.SQL;

import com.rain.domain.Employee;

public class EmployeeDynaSqlProvider {
			// 动态插入
			public String insert_Employee(Employee job){
				
				return new SQL(){
					{
						INSERT_INTO(EMPLOYEETABLE);
						if(job.getName() != null ){
							VALUES("name", "#{name}");
						}
						if(job.getCard_id()!=null){
							VALUES("card_id","#{card_id}");
						}
						if(job.getPassword()!=null){
							VALUES("password","#{password}");
						}
						if(job.getAddress()!=null){
							VALUES("address","#{address}");
						}
						if(job.getPost_code()!=null){
							VALUES("post_code","#{post_code}");
						}
						if(job.getTel()!=null){
							VALUES("tel","#{tel}");
						}
						if(job.getPhone()!=null){
							VALUES("phone","#{phone}");
						}
						if(job.getQq_num()!=null){
							VALUES("qq_nul","#{qq_num}");
						}
						if(job.getEmail()!=null){
							VALUES("email","#{email}");
						}
						if(job.getSex()!=null){
							VALUES("sex","#{sex}");
						}
						if(job.getParty()!=null){
							VALUES("party","#{party}");
						}
						if(job.getBirthday()!=null){
							VALUES("birthday","#{birthday}");
						}
						if(job.getRace()!=null){
							VALUES("race","#{race}");
						}
						if(job.getEducation()!=null){
							VALUES("education","#{education}");
						}
						if(job.getSpeciality()!=null){
							VALUES("speciality","#{speciality}");
						}