import java.awt.*;
import java.util.*;
import java.text.*;
import java.sql.*;

public class Validate
{

   public Validate()
   {
   }

   // get date & time
   static String getDate()
   {
     DateFormat  df;
     java.util.Date  d;
     String dt;
     d   = new java.util.Date();
     df  = DateFormat.getTimeInstance(4);
     dt  = df.format(d);
     df  = DateFormat.getTimeInstance(3);
     //dt  = dt + " , " + df.format(d);
     return dt;
   }




   // converts string to integer
   static int stringToInt(String s) throws Exception
   {
     return Integer.parseInt(s);
   } // end



   // converts '01-Apr-98' to '01-04-98'
   static String stringSQLDateToString(String ss) throws Exception
   {
        String mm,dd,yy,s;
        int m;

        dd   = ss.substring(0,2);
        mm   = ss.substring(3,6);
        yy   = ss.substring(7,9);

        s  = monthNumber(mm);
        s  = dd + "-" + s + "-" + yy;

        return s;

   } // end


   // converts '01-04-98' to '01-Apr-98'
   static String stringToSQLDateString(String s) throws Exception
   {
        String mm,dd,yy,ss;
        int m;

        dd   = s.substring(0,2);
        mm   = s.substring(3,5);
        yy   = s.substring(6,8);

        m  = stringToInt(mm);
        ss = monthName(m);
        ss = dd + "-" + ss + "-" + yy;

        return ss;

   } // end



   // converts 1 to 'JAN'
   static String monthName(int i)
   {
     String mon[] = {"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"};
     String s = mon[i-1];
     return s;

   }// end 



   // converts 'JAN' to '01' type
   static String monthNumber(String s)
   {

     String mon[] = {"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec"};
     s = s.toLowerCase();

     for (int i=0 ; i <= 11 ; i++)
     {
       if ( mon[i].equals(s) )
       {
         int x = i+1;

         String ss = new Integer(x).toString() ;
         if ( ss.length() == 1 )
         {
           ss = "0" + ss;
         }

         return ss;
       }
     }
     return "";
   }// end 




 static Connection openConnection(String dbn,String uid, String pwd,String tbn) throws Exception
 {
    String url = "jdbc:odbc:" + dbn  ;
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con = DriverManager.getConnection(url,uid,pwd);
    return con;
 }//

 static int callStmt(Connection con,String sqlstmt) throws Exception
  {

    CallableStatement cstmt = con.prepareCall(sqlstmt);
    int i = cstmt.executeUpdate();
    cstmt.close();
    return i;
  } // 




} // end of class