src/com/inloam/common/Sql.java

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

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

package com.inloam.common;

import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;

import org.apache.commons.lang.StringUtils;

public class Sql {
	private String tableName;

	public Sql(String tableName) {
		this.tableName = tableName;
	}

	public String getInsertSql(String[] colunm) {

		String placeholder = "";
		String field = ""; 
		for (int i = 0; i < colunm.length; i++) {
			if(hasColunm(colunm[i])){
				if(StringUtils.isNotEmpty(colunm[i])){
					field +=  colunm[i] + ",";
					placeholder += "? ,";
				}
			}
		}
		String insertSql = "insert into " +tableName +"("+field+" id) values ("+placeholder+" ?)";

		return insertSql;
	}

	public String[] getColunm(Map bean){
		String colunms[] = new String[bean.size()];
		Iterator it = bean.keySet().iterator();
		int index = 0;
		while(it.hasNext()){
			String key = it.next().toString();
			
			colunms[index] = key; 
			index++;
		}
		return colunms;
	}
	
	public String getUpdateSql(String[] colunm) {
		String field = "";
		for (int i = 0; i < colunm.length; i++) {
			if(StringUtils.isNotEmpty(colunm[i]))
				field +=  colunm[i] + " = ? , ";
		}
		field = field.trim();
		
		
		String updateSql = "update " +tableName +" set "+field.substring(0,field.length()-1) + "where id = ?";
		
		return updateSql;
	}