import java.math.BigDecimal;
import java.sql.*;
import java.util.Date;

import oracle.jdbc.pool.OracleDataSource;

public class MyOracle {

	private static Connection conn=null;
	private static Statement stmt=null;
	private static ResultSet rs=null;
	
	private final static String connect_string = "jdbc:oracle:thin:@192.168.0.6:1521:ntidb";
	private final static String userName="faisalbasra";
	private final static String password="7034019";
	
	public static void main(String[] args) {
	
		String query = "select * from MyTable";
		conn=getConnection();
		ResultSet rs=executeQuery(conn,query);
		try {
			while(rs.next()){
				short one=rs.getShort("one");
				System.out.println(one);
				
				int two=rs.getInt("two");
				System.out.println(two);
				
				float three=rs.getFloat("threee");
				System.out.println(three);
				
				double four=rs.getDouble("four");
				System.out.println(four);
				
				String five=rs.getString("five");
				System.out.println(five);
				
				BigDecimal six=rs.getBigDecimal("six");
				System.out.println(six);
				
				BigDecimal seven=rs.getBigDecimal("seven");
				System.out.println(seven);
				
				Date eight=rs.getDate("eight");
				System.out.println(eight);
				
				Clob nine=rs.getClob("nine");
				System.out.println(nine);
				
				Blob ten=rs.getBlob("ten");
				System.out.println(ten);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
//		System.out.println(""+traverseResultSet(rs));
	}
	static public Connection getConnection(){
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection con=DriverManager.getConnection(connect_string,userName,password);
			return con;
			
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	static public ResultSet executeQuery(Connection conn, String query){
		ResultSet rs;
		Statement stmt;
		try {
			stmt=conn.createStatement();
			rs=stmt.executeQuery(query);
			return rs;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	static public StringBuffer traverseResultSet(ResultSet rs){
		StringBuffer output=new StringBuffer();
		if(rs!=null){
			try {
				while(rs.next()){
					//System.out.print(rs.getString(1));
					output.append(rs.getString(1)+"\t");
					//System.out.print("\t\t"+rs.getString(2));
					output.append("\t\t"+rs.getString(2));
					//System.out.print("\t\t"+rs.getString(3)+"\n");
					output.append("\t\t"+rs.getString(3)+"\n");
				}
				return output;
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return null;
	}

}