// SqlServer.java

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

public
    class   SqlServer
    {
    private String  oStringURL;
    private String  oStringUsername;
    private String  oStringPassword;

// CONSTRUCTORS

    public
        SqlServer
        (
        String  poStringDriverName,
        String  poStringURL,
        String  poStringUsername,
        String  poStringPassword
        )
        {
        loadDriver(poStringDriverName);
        oStringURL      = poStringURL;
        oStringUsername = poStringUsername;
        oStringPassword = poStringPassword;
        }

    private
        boolean loadDriver
        (
        String  poStringDriverName
        )
        {
        boolean t = false;
        try {
            Class.forName(poStringDriverName);
            System.out.println(poStringDriverName+" loaded");
            t = true;
            }
            catch (Exception x)
                {
                x.printStackTrace();
                }
        return t;
        }
        
    public
        Vector      sqlQuery
        (
        String      poStringSql,
        SqlObject   poSqlObject
        )
        throws      SQLException
        {
        Connection  oConnection;
        ResultSet   oResult;
        SqlObject   oSqlObject;
        Statement   oStatement;
        Vector      oVector;
        oConnection = DriverManager.getConnection(  oStringURL,
                                                    oStringUsername,
                                                    oStringPassword);
        oStatement  = oConnection.createStatement();
        oResult     = oStatement.executeQuery(poStringSql);
        oVector     = SqlAssistant.sqlReadResult(   oResult,
                                                    poSqlObject);
        oStatement.close();
        oConnection.close();
        return oVector;
        }
        
    public
        int         sqlUpdate
        (
        String      poString
        )
        throws      SQLException
        {
        Connection  oConnection;
        Statement   oStatement;
        int         i = 0;
        oConnection = DriverManager.getConnection(  oStringURL,
                                                    oStringUsername,
                                                    oStringPassword);
        oStatement = oConnection.createStatement();
        try {
            i = oStatement.executeUpdate(poString);
            }
            catch (Exception x)
                {
                x.printStackTrace();
                };
        oStatement.close();
        oConnection.close();
        return i;
        }
    }