通过系统把几乎所有与人力资源相关的数据统一管理

				//$Id: Update.java,v 1.3.2.2 2003/11/27 15:28:38 oneovthafew Exp $
				package net.sf.hibernate.sql;
				
				import java.util.Iterator;
				import java.util.Map;
				
				import net.sf.hibernate.type.LiteralType;
				import net.sf.hibernate.util.StringHelper;
				
				import org.apache.commons.collections.SequencedHashMap;
				
				/**
				 * An SQL UPDATE statement
				 * 
				 * @author Gavin King
				 */
				public class Update {
					
					private String tableName;
					private String[] primaryKeyColumnNames;
					private String versionColumnName;
					private String where;
					
					private Map columns = new SequencedHashMap();
					private Map whereColumns = new SequencedHashMap();
					
					public Update addColumns(String[] columnNames) {
						for ( int i=0; i							addColumn( columnNames[i] );
						}
						return this;
					}
				
					public Update addColumns(String[] columnNames, String value) {
						for ( int i=0; i							addColumn( columnNames[i], value );
						}
						return this;
					}
				
					public Update addColumn(String columnName) {
						return addColumn(columnName, "?");
					}
				
					public Update addColumn(String columnName, String value) {
						columns.put(columnName, value);
						return this;
					}
					
					public Update addColumn(String columnName, Object value, LiteralType type) throws Exception {
						return addColumn( columnName, type.objectToSQLString(value) );
					}
					
					public Update addWhereColumns(String[] columnNames) {
						for ( int i=0; i							addWhereColumn( columnNames[i] );
						}
						return this;
					}
				
					public Update addWhereColumns(String[] columnNames, String value) {
						for ( int i=0; i							addWhereColumn( columnNames[i], value );
						}
						return this;
					}
				
					public Update addWhereColumn(String columnName) {
						return addWhereColumn(columnName, "=?");
					}
				
					public Update addWhereColumn(String columnName, String value) {
						whereColumns.put(columnName, value);
						return this;
					}
					
					public Update setTableName(String tableName) {
						this.tableName = tableName;
						return this;
					}
					
					public Update setWhere(String where) {
						this.where=where;
						return this;
					}
					
					public String toStatementString() {
						StringBuffer buf = new StringBuffer( columns.size()*15 + tableName.length() + 10 );
						buf.append("update ")
							.append(tableName)
							.append(" set ");
						Iterator iter = columns.entrySet().iterator();
						while ( iter.hasNext() ) {
							Map.Entry e = (Map.Entry) iter.next();
							buf.append( e.getKey() )
								.append('=')
								.append( e.getValue() );
							if ( iter.hasNext() ) buf.append(StringHelper.COMMA_SPACE);
						}
						buf.append(" where ")
							.append( StringHelper.join("=? and ", primaryKeyColumnNames) )
							.append("=?");
						if (where!=null) {
							buf.append(" and ")
								.append(where);
						}
						iter = whereColumns.entrySet().iterator();
						while ( iter.hasNext() ) {
							Map.Entry e = (Map.Entry) iter.next();
							buf.append(" and ")
								.append( e.getKey() )
								.append( e.getValue() );
						}
						if (versionColumnName!=null) {
							buf.append(" and ")
								.append(versionColumnName)
								.append("=?");
						}
						return buf.toString(); 
					}
				
					public Update setPrimaryKeyColumnNames(String[] primaryKeyColumnNames) {
						this.primaryKeyColumnNames = primaryKeyColumnNames;
						return this;
					}
				
					public Update setVersionColumnName(String versionColumnName) {
						this.versionColumnName = versionColumnName;
						return this;
					}
				
				}