jdbcodbc_test.java

可以运用该程序

import java.net.URL;
import java.sql.*;
import java.util.*;
public class JdbcOdbc_test
{
	public static void main(String[] args)
	{
		new JdbcOdbc_test() ;
	}
	ResultSet results;
	ResultSetMetaData rsmd;
	DatabaseMetaData dma;
	Connection con;
	int numCols, i;
	public JdbcOdbc_test()
	{
		String url = "jdbc:odbc:Grocery prices";
		String query = "SELECT DISTINCTROW FoodName FROM Food " + "WHERE (FoodName like 'C%');";
		try
		{
			//加载 JDBC-ODBC 桥驱动程序
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			//连接数据库
			con = DriverManager.getConnection(url);
			//获取数据库的元数据
			dma =con.getMetaData();
			System.out.println("Connected to:"+dma.getURL());
			System.out.println("Driver "+dma.getDriverName());
			//将数据库中的表的名称转储出来
			String[] types = new String[1];
			types[0] = "TABLES";
			results = dma.getTables(null, null, "%", types);
			//dumpResults("--Tables--");
			System.out.println("--Tables--");
			results.close();
		}
		catch (Exception e)
		{System.out.println(e);}
		//获取表列的名称
		System.out.println("--Column Names--");
		try 
		{
			results =dma.getColumns(null, null, "FoodPrice", null);
			ResultSetMetaData rsmd = results.getMetaData();
			int numCols = rsmd.getColumnCount();
			while (results.next() )
			{
				String cname = results.getString("COLUMN_NAME");
				System.out.print(cname + " ");
				System.out.println();
			}
			results.close();
		}
		catch (Exception e)
		{System.out.println(e);}
		//列出一个列的内容 -- 这是一个查询
		try 
		{
			Statement stmt = con.createStatement();
			results =stmt.executeQuery("SELECT FOODNAME FROM FOOD;");
		}
		catch (Exception e)
		{System.out.println("query exception");}
		//dumpResults("--Contents of FoodName column--");
		System.out.println("--Contents of FoodName column--");
		//尝试实际的 SQL 语句
		try
		{
			Statement stmt = con.createStatement();
			results = stmt.executeQuery(query);
		}
		catch (Exception e)
		{System.out.println("query exception");}
		//dumpResults("--Results of Query--");
		System.out.println("--Results of Query--");
	}
}