updatesqlexecuter.java

采用Eclispe开发平台

package com.whatratimes.dbms;

import java.util.Enumeration;
import java.util.Hashtable;

/**
 * Created by IntelliJ IDEA.
 * User: Tao
 * Date: May 9, 2003
 * Time: 11:25:25 AM
 */
public class UpdateSQLExecuter extends SQLExecuter
{
    public UpdateSQLExecuter()
    {
        super();
    }

    public void appendValuesByHashtable(Hashtable properties)
    {
        super.appendValuesByHashtable(properties);
    }

    public void appendSetValuesByBean(Object this_table)
    {
        super.appendValuesByBean(this_table);
    }

    public void appendSetValue(String column_name, Object value)
    {
        super.appendValue(column_name, value);
    }

    public void appendWhereCondition(String column_name, String operator, Object value)
    {
        super.appendWhereCondition(column_name, operator, value);
    }

    public void appendWhereClause(String where_clause)
    {
        super.appendWhereClause(where_clause);
    }

    public void setWhereConditionOR()
    {
        super.setWhereConditionOR();
    }

    public int executeUpdate()
    {
        return super.executeUpdate();
    }

    public String getSQL()
    {
        StringBuffer set_string = new StringBuffer();

        Enumeration enu = values.keys();

        while (enu.hasMoreElements())
        {
            String this_column = (String) enu.nextElement();
            set_string.append( " " + this_column + " = ?,");
        }

        set_string.deleteCharAt(set_string.length() - 1);

        return "update " + tablesClause + " SET " + set_string + getWhereClause();

    }
}