import java.util.*;
import java.io.*;
import java.sql.*;

public class DBUtil
{
    private String uName = "sevls";
    private String pass = "******";
    private Connection con;
    private PreparedStatement pstmt;

    public DBUtil() throws ClassNotFoundException, SQLException
    { 
	Class.forName("oracle.jdbc.driver.OracleDriver");
	
	con = DriverManager.getConnection("jdbc:oracle:thin:@oracle-prod:1521:8PRD", uName, pass);

	con.setAutoCommit(true);
    }
    
    public int execUpdate(String query)
    {
	try {
	    Statement stmt = con.createStatement();
	    int result = stmt.executeUpdate(query);
	    
	    stmt.close();
	    return result;
	}
	catch (SQLException e) {
	    return -1;
	} 
    }

    public ResultSet execQuery(String query)
    {
	try {
	    pstmt = con.prepareStatement(query);
	    ResultSet rs = pstmt.executeQuery();
	    
	    return rs;
	}
	catch (SQLException e) {
	    return null;
	}
    }

    public void closeQuery()
    {
	try { pstmt.close(); }
	catch (SQLException e) {}
    }

    public void close() 
    { 
	try { con.close();
	pstmt.close(); }
	catch (SQLException e) {}
    }
}