// package test;

import java.util.*;
import java.text.*;
import java.io.FileReader;
import java.io.BufferedReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
// import java.sql.Date;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.text.SimpleDateFormat;
// import java.util.Date;

// log browser write test 
// this class's main method deletes all entries from SAMPL_NGIN from L_TABLE_LOGBROWSER
public class lbdt {

  public static final String c_filename    = ".\\ngin.log";
  public static final String c_sql_insert  = "insert INTO L_TABLE_LOGBROWSER "+
                                            "(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 final String c_sql_delete  = "delete FROM L_TABLE_LOGBROWSER WHERE ELEMENT_NAME='SAMPL_NGIN'";

    public static final String c_driverClass = "oracle.jdbc.driver.OracleDriver";
    public static final String c_dbUrl       = "jdbc:oracle:thin:@solv8:1521:o2evra";
    public static final String c_dbUser      = "o2evra_feeder";
    public static final String c_dbPassword  = "dbmgr";

    private Connection conn = null;
    private PreparedStatement stmt = null;

    public String f_element_name = "SAMPL_NGIN";
    public String f_stream_name  = "system_log";
    public int f_segment_id      = 5002;
    public int f_byte_address    = 0;
    public java.util.Date f_operation_timestamp = new java.util.Date();
    public String f_record_type  = "LOG";
    public int    f_tag_n_1      = 7;
    public String f_tag_vs_1     = "VS_1 - severity";
    public String f_tag_vs_2     = "VS_2 - component id";
    public String f_tag_vl_1     = "VL_1 - remaining_header_line";
    public String f_tag_vl_2     = "VL_2 - remaining_record_text";

    private void dbopen() {
	try {
	  Class.forName(c_driverClass);
	  conn = DriverManager.getConnection(c_dbUrl, c_dbUser, c_dbPassword);
	  stmt = conn.prepareStatement(c_sql_delete);
	  stmt.clearParameters();
	} catch (Exception e) {
	    e.printStackTrace();
	}
    }

    private void dbclose() {
	try {
	stmt.close();
	conn.close();
	} catch (Exception e) {
	    e.printStackTrace();
	}
    }

    private void insert() {
	try {
	stmt.clearParameters();
	stmt.setString(1,f_element_name);
	stmt.setString(2,f_stream_name);
	stmt.setInt(3,f_segment_id);
	stmt.setInt(4,f_byte_address);
	stmt.setDate(5,new java.sql.Date(f_operation_timestamp.getTime()));
	stmt.setString(6,f_record_type);
	stmt.setInt(7,f_tag_n_1);
	stmt.setString(8,f_tag_vs_1);
	stmt.setString(9,f_tag_vs_2);
	stmt.setString(10,f_tag_vl_1);
	stmt.setString(11,f_tag_vl_2);
	stmt.executeUpdate();
	conn.commit();
	} catch (Exception e) {
	    e.printStackTrace();
	}
    }

    private void delete() {
	try {
	stmt.executeUpdate();
	conn.commit();
	} catch (Exception e) {
	    e.printStackTrace();
	}
    }

  public static void main(String[] args) {

      String lb = null;

    try {
	lbdt t = new lbdt();

	t.dbopen();
	t.delete();
	t.dbclose();
    } catch (Exception e) {
      e.printStackTrace();

    }
  }
}