JdbcConnection.java

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

public class JdbcConnection 
{
	JdbcConnection()
	{

	}
	public Connection conn() throws SQLException//method of class JdbcConnection
	{
	Connection conn;
		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");//Load DB-specific JDBC driver
		}
		catch(ClassNotFoundException e)
		{
			System.out.println("Database Driver not found");
			System.out.println(e.toString());
		}
		catch(Exception e)
		{
			System.out.println(e.toString());
		}
                //return(DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:XE","SYSTEM","Oracle1"));////Get a Connection object
                return(DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:XE","monish001","oracle"));////Get a Connection object
	}
	
	public static void main(String args[]) throws SQLException,IOException
	{
		JdbcConnection c=new JdbcConnection();
		//String qry= new String();
		Connection con=c.conn();//Get a Connection object
		Scanner in=new Scanner(System.in);
		Statement stmt = con.createStatement();//Get a Statement object
        	ResultSet rset;  // = stmt.executeQuery("select max(studentid) from student");
		String qry=new String("select * from batch");//Execute queries and/or updates
		rset=stmt.executeQuery(qry);
		//System.out.println("Name\tNull?\tType");
		while(rset.next())
		{
			System.out.println(rset.getString(1));
		}
		//close(con);
	}
}