import java.sql.*;

class SimpleSelect {

public static void main (String[] args)
{
	try
	{
 		Class.forName("oracle.jdbc.driver.OracleDriver");
	 	Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@cypress.cacs.louisiana.edu:1521:DMDB","<user_id>", "<passwd>" );

         	Statement stmt = conn.createStatement();
         	ResultSet rs;

	        rs = stmt.executeQuery("SELECT * FROM meddocs");
	        while(rs.next())
	        {
             	    String title = rs.getString("Title");
            	    String author = rs.getString("Author");
                    String journal = rs.getString("Journal");
                    String pdate = rs.getString("PubDate");
                    String pages = rs.getString("Pages");
                    System.out.println(title+","+author+","+journal+","+pdate+","+pages);
            	}

            	conn.close();
           } catch (Exception e) {
            	System.err.println("Got an exception! ");
            	System.err.println(e);
            	System.err.println(e.getMessage());
           }

 }

	}