1 /*
  2  * To change this template, choose Tools | Templates
  3  * and open the template in the editor.
  4  */
  5 
  6 package db_adapter;
  7 
  8 /**
  9  *
 10  * @author sameldin
 11  */
 12 
 13 import java.io.*;
 14 import java.sql.Connection;
 15 import java.sql.DriverManager;
 16 import java.sql.PreparedStatement;
 17 import java.sql.ResultSet;
 18 import java.sql.SQLException;
 19 import java.util.ArrayList;
 20 import java.util.Hashtable;
 21 import java.util.MissingResourceException;
 22 import java.util.ResourceBundle;
 23 
 24 //import org.apache.log4j.Logger;
 25 //import org.apache.log4j.PropertyConfigurator;
 26 
 27 import utils.*;
 28 import constants.*;
 29 
 30 public class ROWCOUNT
 31 {
 32     Connection  localConnection = null;
 33 
 34     public ROWCOUNT()
 35     {
 36         BD_Connector localBD_Connector = new BD_Connector();
 37         localConnection = localBD_Connector.getConnection();
 38     }
 39     /*
 40      *
 41      */
 42      public int updateUsing_ROWCOUNT(String passedTableName, String name, String email, int passedID)
 43      {
 44         if(null == localConnection)
 45             return(Constants.ERROR_RUN);
 46         PreparedStatement   localPreparedStatement      = null;
 47         //==========================
 48         try
 49         {
 50 
 51             // UPDATE table_1
 52             //     set NAME = 'AAjoeList', IMAGE_NAME = 'BB_rbf.BMP',
 53             //     ITEM _NUMBER = '00002', ITEM _ID = '123',
 54             //     ITEM _DESCRIPTION = 'Sam Item Description' ,
 55             //     DISTRIBUTED_BY = 'jbond', DISTRIBUTED_DATE = 1080414,
 56             //     DISTRIBUTED_TIME = 123619 WHERE NAME = 'Sam' and
 57             //     IMAGE_NAME = 'BB'
 58             // IF @@ROWCOUNT=0
 59             //     INSERT INTO table_1
 60             //    (NAME, IMAGE_NAME, ITEM _NUMBER, ITEM _ID, ITEM _DESCRIPTION,
 61             //      DISTRIBUTED_BY, DISTRIBUTED_DATE, DISTRIBUTED_TIME)
 62             //     VALUES('Sam', 'BB', '00002', '123', 'Sam Item Description' , 'Eldin', 1080414, 123619);
 63 
 64                 String qryString        = "";
 65                 String table_1          = DatabaseKeysPropertyManager.getParameter(passedTableName);
 66                 //==========================
 67                 qryString       =       "UPDATE "
 68                                 + table_1
 69                                 + " set NAME = 'AAjoeList',"
 70                                 + "IMAGE_NAME = 'BB_rbf.BMP',"
 71                                 + "ITEM _NUMBER = '00002', "
 72                                 + "ITEM _ID = '123',"
 73                                 + "ITEM _DESCRIPTION = 'Sam Item Description' "
 74                                 + "DISTRIBUTED_BY = 'jbond',"
 75                                 + "DISTRIBUTED_DATE = 1080414, "
 76                                 + "DISTRIBUTED_TIME = 123619"
 77                                 + " WHERE "
 78                                 + " NAME = 'Sam' "
 79                                 + " AND "
 80                                 + " IMAGE_NAME = 'BB'"
 81                                 //===============================
 82                                 // IF @@ROWCOUNT=0
 83                                 + " IF @@ROWCOUNT=0"
 84                                 + " INSERT INTO "
 85                                 + table_1
 86                                 + " (NAME, IMAGE_NAME, ITEM _NUMBER, ITEM _ID, ITEM _DESCRIPTION,"
 87                                 + " DISTRIBUTED_BY, DISTRIBUTED_DATE, DISTRIBUTED_TIME)"
 88                                 + " VALUES('Sam', 'BB', '00002', '123', 'Sam Item Description' , 'Eldin', 1080414, 123619);";
 89                 
 90                 localPreparedStatement = localConnection.prepareStatement(qryString);
 91                 localPreparedStatement.executeQuery();
 92                 localPreparedStatement.close();
 93         }
 94         catch(MissingResourceException eMissingResourceException)
 95         {
 96             eMissingResourceException.printStackTrace();
 97             return(Constants.ERROR_RUN);
 98         }
 99         catch(SQLException eSQLException)
100         {
101             eSQLException.printStackTrace();
102             return(Constants.ERROR_RUN);
103         }
104         return(Constants.NORMAL_RUN);
105      }
106 
107 }
108 
109