jdbcconnection.java

来自「j2EE」· Java 代码 · 共 41 行

// Program to make connection between Java Application and MS Access Database
import java.sql.*;
public class JDBCConnection 
{
	public static void main(String[] args)
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			try
			{
				Connection conn = DriverManager.getConnection("jdbc:odbc:dsnDirectory");
				Statement stmt = conn.createStatement();
				ResultSet rs = stmt.executeQuery("SELECT * FROM tblDirectory");
				System.out.println("\t\tTELEPHONE DIRECTORY");
				System.out.println("\t\t-------------------");
				System.out.println("\n");
				System.out.println("NAME\t\tPHONE\t\tEMAIL");
		        	while (rs.next())
				{
		        	System.out.println(rs.getString("NAME")+"\t\t"+rs.getString("PHONE")+"\t"+rs.getString("EMAIL"));
					
                        	}
				rs.close();
				stmt.close();
				conn.close();
	     		}
			catch (SQLException se)
			{
				System.out.println("SqlException: " + se.getMessage());
				se.printStackTrace(System.out);
			}
		}
		catch (ClassNotFoundException e)
		{
			System.out.println("ClassNotFound: " + e.getMessage());	
		}
	} //main
} //class