prog1.java

SQL embedded in Java for database

/*
Java and use of JDBC to retrieve from an Access database
ODBC Name: 	       	odbcInterfaceForMyDatabase 
Database file:    	myDatabase.mdb 
myDatabase.mdb table:  	Students {three attributes: IS, SSN, Name}
Task:		       	Use JDBC to display rows of Students table
*/
import java.sql.*;
import java.util.*;
import java.io.*;


public class prog1
{



	static String nameOfJdbcOdbcDriver = "sun.jdbc.odbc.JdbcOdbcDriver";

	static String dataBaseNameDSN = "jdbc:odbc:odbcprog1";
	static String userName = "";
	static String passwordForUser = "";

	static Connection myConnectionRequest = null;
	static Statement myStatementObject = null;
	static ResultSet myResultTuples = null;



	public static void main(String args[]) 
			throws Exception
	{
		try
		{
			//Identify the driver to use
			Class.forName(nameOfJdbcOdbcDriver);

			//Attempt a connection to database...    
			Connection myConnectionRequest = DriverManager.getConnection(dataBaseNameDSN, userName, passwordForUser);

			String query1 = "select * from person";
			String query2 = "select * from car ssn=";

			//Create a statement object, use its method to execute query
			Statement stmt1 = myConnectionRequest.createStatement();//yuhui
			Statement stmt2 = myConnectionRequest.createStatement();
	
			ResultSet rs1 = stmt1.executeQuery(query1);
			//int numberOfAttributes = 3;
			//System.out.println(Integer.toString(numberOfAttributes));
			//For each row in result set, print ALL columns
			for (int rowNum1 = 1; rs1.next(); rowNum1++)
			{
			
				ResultSetMetaData getmetadata1 = rs1.getMetaData();

				int colnum1 = getmetadata1.getColumnCount();
			

				String temp = new String();
				temp = rs1.getString(1);
				System.out.print(temp + "      ");

				for (int i = 2; i <= colnum1; i++)
				{

					System.out.print(rs1.getString(i) + "\t");
				}
				//System.out.println("\n");

				ResultSet rs2 = stmt2.executeQuery(query2 + temp);
			
				for (int rowNum2 = 1; rs2.next(); rowNum2++)
				{
					System.out.println("\n");
					ResultSetMetaData getmetadata2 = rs2.getMetaData();
					int colnum2 = getmetadata2.getColumnCount();

					for (int j = 2; j <= colnum2; j++)
						System.out.print(rs2.getString(j) + "\t");
				}
			
				System.out.println("\n...next row... \n");
			}
			

		}  // end of try block

		//handle ALL exceptions to above database calls
		catch (ClassNotFoundException error)
		{
			error.printStackTrace();
		}
	}  // end of main method of this class

	
		
}//end of the class