15m.txt

一本关于JBuilder 应用开发的书籍,希望大家喜欢,其实我没看过的,

import java.net.URL;
import java.sql.*;
import java.util.*;
class 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--");
  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--");
   //尝试实际的 SQL 语句
   try
   {
   Statement stmt = con.createStatement();
      results = stmt.executeQuery(query);
   }
   catch (Exception e)
   {System.out.println("query exception");}
   dumpResults("--Results of Query--");
 }