simpledbconnection.java

j2EE

import java.sql.*;
public class SimpleDBConnection {
public static void main(String[] args) {
try {
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	try {
		Connection conn = DriverManager.getConnection("jdbc:odbc:WUHAN");
		Statement stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery("SELECT city FROM cities");
		        while (rs.next()) {
		          System.out.println(rs.getString("city"));	
                                                       }
		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