// SqlAssistant.java

import  java.sql.*;
import  java.util.Vector;

public
    class       SqlAssistant
    extends     Object
    {
    public static
        boolean         append
        (
        StringBuffer    poBuffer,
        boolean         ptSeparator,
        String          poStringSeparator,
        String          poStringPrefix,
        Object          poObject,
        String          poStringSuffix
        )
        {
        boolean tDidAppend;
        String  oStringObject = poObject.toString();
        if (tDidAppend = 0 < oStringObject.length())
            {
            if (ptSeparator) poBuffer.append(poStringSeparator);
            poBuffer.append(poStringPrefix);
            poBuffer.append( oStringObject);
            poBuffer.append(poStringSuffix);
            }
        return ptSeparator | tDidAppend;
        }

    public static
        String      sqlDeleteByExample
        (
        String      poStringTable,
        SqlObject   poSqlObject
        )
        {
        String  oString;
        oString = poSqlObject.sqlWhereString();
        if (0 != oString.length())
            oString = " where"+ oString;
        oString = "delete from "
                    +poStringTable
                    +oString;
        return oString;
        }

    public static
        String      sqlInsertByExample
        (
        String      poStringTable,
        SqlObject   poSqlObject
        )
        {
        String  oString;
        oString = poSqlObject.sqlValuesString();
        if (0 != oString.length())
            {
            oString = "insert into "
                        +poStringTable
                        +" values ("
                        +oString
                        +")";
            }
        return oString;
        }

    public static
        Vector      sqlReadResult
        (
        ResultSet   poResult,
        SqlObject   poSqlObject
        )
        {
        Vector      oVector = new Vector();
        try {
            while (poResult.next())
                {
                oVector.addElement
                    (poSqlObject.newInstance().sqlReadResult(poResult));
                }
            }
            catch (Exception x)
                {
                x.printStackTrace();
                };
        return oVector;
        }

    public static
        String      sqlSelectByExample
        (
        String      poStringTable,
        SqlObject   poSqlObject
        )
        {
        String  oString;
        oString = poSqlObject.sqlWhereString();
        if (0 != oString.length())
            oString = " where"+ oString;
        oString = "select * from "
                    +poStringTable
                    +oString;
        return oString;
        }

    public static
        String      sqlUpdateByExample
        (
        String      poStringTable,
        SqlObject   poSqlObjectOld,
        SqlObject   poSqlObjectNew
        )
        {
        String  oString;
        oString = poSqlObjectOld.sqlWhereString();
        if (0 != oString.length())
            {
            oString = "update "
                        +poStringTable
                        +" set"
                        +poSqlObjectNew.sqlSetString()
                        +" where"+oString;
            }
        return oString;
        }
    }