insertsqlexecuter.java

采用Eclispe开发平台

package com.whatratimes.dbms;

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

/**
 * Created by IntelliJ IDEA.
 * User: Tao
 * Date: May 8, 2003
 * Time: 11:06:31 PM
 */
public class InsertSQLExecuter extends SQLExecuter
{

    public InsertSQLExecuter()
    {
        super();
    }

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

    public String getSQL()
    {

        StringBuffer column_string = new StringBuffer(" ( ");
        StringBuffer value_string = new StringBuffer(" values ( ");

        Enumeration enu = values.keys();

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

        column_string.deleteCharAt(column_string.length() - 1);
        column_string.append(" )");

        value_string.deleteCharAt(value_string.length() - 1);
        value_string.append(" )");

        return "insert into " + tablesClause + column_string + value_string;
    }

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

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

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

}