/*
 * DBhandler.java
 *
 * Created on 7. huhtikuuta 2003, 9:42
 * 
 * Modified: 
 * 16.5.2003: 
 *       - added another bringFromDatabase-function (DB brought from caller)
 *       - changed methods static
 */

package kottarainenbeans;

import java.beans.*;
import kotkabeans.*;
import kottarainenbeans.*;

/** Purpose is to handle database and save writing in other classes.
 * 
 * @author  tmpoyhon
 */
public class DBhandler extends Object implements java.io.Serializable {
    
   /** Brings data from database.
    *  @param SQLsentence tells which SQL-sentence is used in SQL-query.
    *  @return rs , which contains data brought from db.
    */
    public static RS2 bringFromDatabase(String logInfo,String SQLsentence,
      String SentenceFact) {
        DB db = new DB(logInfo);
        RS2 rs;
        try {
            db.connect();    
            rs=bringFromDatabase(db,logInfo,SQLsentence,SentenceFact);
        }
        // käytä db:tä
        // mutta mielellään älä kutsu toista metodia, joka luo
        // oman db:n        
        catch (Exception e) {   
           System.out.println(e.getMessage());
           rs=null;
        } finally {
           db.disconnect();
        }
        return rs;
    }
   /** Brings data from database.using brought connection. */
    public static RS2 bringFromDatabase(DB db,String logInfo,String SQLsentence,
      String SentenceFact) throws Exception{
      
        RS2 rs = new RS2(db.executeQuery(SQLsentence),SentenceFact);
        return rs;
    }
   
   /**  Inserts into database. 
    *   Sentence brought here must be correct! No checks are made.
    *   @return If everything goes right, returns 0.
    */
    public static int insertIntoDatabase(String logInfo,String SQLsentence,
      String SentenceFact){
 
       DB db = new DB(logInfo);
       RS2 rs;
       int modifiedNumb;
       try {
         db.connect();
         insertIntoDatabase(db, logInfo, SQLsentence, SentenceFact);
         // käytä db:tä
         // mutta mielellään älä kutsu toista metodia, joka luo
         // oman db:n        
       } catch (Exception e) {   
          System.out.println(e.getMessage());
       } finally {
          db.disconnect();
       }
       return 0;  
    }
    
    /**  Inserts into database using brought connection. */
    public static int insertIntoDatabase(DB db, String logInfo,
      String SQLsentence,String SentenceFact) throws Exception {
    
        db.executeUpdate(SQLsentence);
        return 0;
    }
}