// package test;

 

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Date;

public class dbt {

  public static final String c_filename = ".\\system.log";
  public static final String c_sql_insert = "insert ELEMENT_NAME, STREAM_NAME, SEGMENT_ID, BYTE_ADDRESS, OPERATION_TIMESTAMP, "+
                                            "RECORD_TYPE, TAG_N_1, TAG_VS_1, TAG_VS_2, TAG_VL_1, TAG_VL_2 "+
	                                    "VALUES(?,?,?,?,?,?,?,?,?,?,?)";

  public static void main(String[] args) {

    try {

      String driverClass = "oracle.jdbc.driver.OracleDriver";
      String dbUrlsolv7 = "jdbc:oracle:thin:@solv7:1526:o2dxt";
      String dbUrl = "jdbc:oracle:thin:@solv8:1521:o2evra";
      String dbUrlRAC = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=s003975a-vip)(PORT=1521))"+
                        "(ADDRESS=(PROTOCOL=TCP)(HOST=s003976a-vip)(PORT=1521))(LOAD_BALANCE=yes)"+
                        "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=mdxtrac.kcc)))";
      String dbUser = "o2evra_feeder";
      String dbPassword = "dbmgr";

      String request = "select 'COUCOU' as \"MyString\" from dual union select 'BOUBOU' from dual";
      request += " union select null from dual union select 'BABA' from dual";

      String request2 = "select 4323 from dual union select 5647823.54235 from dual";
      request2 += " union select null from dual union select -423.532 from dual";

      String request3 = "select sysdate from dual union select sysdate +3 from dual";
      request3 += " union select null from dual union select sysdate-4000 from dual union select "+
                  "TO_DATE('12.02.2007:15:00','DD.MM.YYYY:HH24:MI') from dual";

      String request4 = "select * from l_table_logbrowser";



      Connection connection = null;
      Class.forName(driverClass);
      connection = DriverManager.getConnection(dbUrl, dbUser, dbPassword);
      Statement stmt = connection.createStatement();

      ResultSet rs = stmt.executeQuery(request4);

      ResultSetMetaData metadata = rs.getMetaData();

      int colCount = metadata.getColumnCount();

      System.out.println("COLUMN METADATA");

      for (int i = 1; i <= colCount; i++) {
        StringBuffer sb = new StringBuffer();
        sb.append("Column " + i + ": ");
        sb.append("Type " + metadata.getColumnType(i) + "; ");
        sb.append("Typename " + metadata.getColumnTypeName(i) + "; ");
        sb.append("Classname " + metadata.getColumnClassName(i) + "; ");
        sb.append("Name " + metadata.getColumnName(i) + "; ");
        sb.append("Label " + metadata.getColumnLabel(i) + "; ");
        sb.append("Displaysize " + metadata.getColumnDisplaySize(i) + "; ");
        System.out.println(sb.toString());
      }

      System.out.println("CONTENT");

      while (rs.next()) {

        Object obj = rs.getObject(1);
        //double dbl = rs.getDouble(1);
        //Double val = new Double(dbl);
        StringBuffer sb = new StringBuffer("Object(1): ");
        sb.append((obj == null) ? "<noclass>" : obj.getClass().getName());
        sb.append(": ");
        sb.append((obj == null) ? "<null>" : obj);
	Object d = null;
	try {
          d = rs.getTimestamp(5);
	} catch (Exception e) {
	    System.out.println("Exception in getTimestamp: "+e);
	    e.printStackTrace();
	}
        Date date = (Date) d;
        sb.append(" / " + d.getClass().getName() + "(5) - " + (new SimpleDateFormat("dd.MM.yyyy HH:mm:ss")).format(date));
        System.out.println(sb.toString());
      }

      stmt.close();

      System.out.println("--- Reading file: "+c_filename); 


      connection.close();

    } catch (Exception e) {
      e.printStackTrace();

    }
  }
}