10-1.txt

jsp常用实例讲解

import java.net.URL;
import java.sql.*;
import java.util.*;
class JdbcOdbc_test
{
  ResultSetresults;
   ResultSetMetaData rsmd;
   DatabaseMetaData dma;
   Connection con;
   int numCols, i;
public JdbcOdbc_test()
{
StringURL= "jdbc:odbc:Shopsprices";
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 {
 Statementstmt = con.createStatement();
  results=stmt.executeQuery("SELECT FOODNAME FROM FOOD;");
   }
   catch (Exception e)
   {System.out.println("query exception");}
   dumpResults("--Contents of FoodName column--");
   //尝试实际的SQL语句
   try
   {
  Statementstmt = con.createStatement();
   results = stmt.executeQuery(query);
   }
   catch (Exception e)
   {System.out.println("query exception");}
   dumpResults("--Results of Query--");
 }