package  test;

 import  java.sql.Connection;
 import  java.sql.DriverManager;
 import  java.sql.PreparedStatement;
 import  java.sql.ResultSet;
 import  java.util.GregorianCalendar;
 import  java.text.SimpleDateFormat;

 public   class  Timest {
     public   static   void  main(String[] args)  throws  ClassNotFoundException, IllegalAccessException, InstantiationException {
        java.util.Date n =  new  java.util.Date();
        String driver = "oracle.jdbc.driver.OracleDriver";
         Class .forName(driver).newInstance();

	    String url = "jdbc:oracle:thin:@...";
        String user = "...";
        String bdpwd = "...";
        Connection conn =  null ;
	 try {

	    conn = DriverManager.getConnection(url, user, bdpwd);
        java.util.Date timecon =  new  java.util.Date();
        GregorianCalendar start =  new  GregorianCalendar();

        SimpleDateFormat sdf =  new  SimpleDateFormat("yyyyMMddHHmmss");
        start.set(GregorianCalendar.MONTH, GregorianCalendar.JUNE);
        start.set(GregorianCalendar.DAY_OF_MONTH,  1 );
        start.set(GregorianCalendar.HOUR_OF_DAY,  0 );
        start.set(GregorianCalendar.MINUTE,  0 );
        start.set(GregorianCalendar.SECOND,  0 );
        start.set(GregorianCalendar.MILLISECOND,  0 );

        GregorianCalendar end = (GregorianCalendar)start.clone();
        end.add(GregorianCalendar.MONTH,  1 );
        end.add(GregorianCalendar.MILLISECOND, - 1 );

        
        PreparedStatement ps = conn.prepareStatement("");
        ps.setString( 1 , sdf.format(start.getTime()));
        ps.setString( 2 , sdf.format(end.getTime()));
        ResultSet rs = ps.executeQuery();

         while (rs.next()){
            System.out.println("1="+rs.getString( 1 )+"  2="+rs.getString( 2 ) + " 3="+rs.getString( 3 ));
        }
        rs.close();
        ps.close();

        java.util.Date beforeclose =  new  java.util.Date();
        rs.close();
        ps.close();
        conn.close();
        java.util.Date n1 =  new  java.util.Date();

         double  secs = (n1.getTime() - n.getTime())/( double ) 1000 ;
         double  podkl = (timecon.getTime() - n.getTime())/( double ) 1000 ;
         double  otkl = (n1.getTime() - beforeclose.getTime())/( double ) 1000 ;

        System.out.println(" podkl(secs)= "+podkl);
        System.out.println(" otkl(secs)= "+otkl);
        System.out.println("\n\n Itogo(secs)= "+secs);
	} catch (Exception e){
        System.out.print(e.getLocalizedMessage());
	}

    }
}