工具：JBUILDER2006。MYSQL5。0

        我查了好幾天才成功的，寫出來目的是希望大家不要浪費時間，

        代碼如下：（運行時肯定要自己改改）

 public void getTables() {
        try {
            int i;
            i = 0;
            DatabaseMetaData md = this.con.getMetaData();
            ResultSet rs;
            rs = md.getCatalogs();
            MainFrame.msg.append("databases start!!!"n");
            //////顯示數據庫名
            while (rs.next()) {
                MainFrame.msg.append(rs.getString("TABLE_CAT") + ""n");
            }
            rs = md.getTableTypes();
            rs.last();
            i = rs.getRow();
            String[] str = new String[i];
            rs.first();
            //////顯示數據庫類型
            while (rs.next()) {
                str[i - 1] = rs.getString("TABLE_TYPE");
                MainFrame.msg.append(rs.getString("TABLE_TYPE") + ""n");
            }
            ///這行代碼是關鍵，查了好久,具體參數我也不太明白，望高人指點
            /////因為在JDK幫助文檔中沒有看到有%這個東東
            rs = md.getTables(null, "%","%", null);
            //////顯示表名
            MainFrame.msg.append("tables start!!!"n");
            while (rs.next()) {
                MainFrame.msg.append(rs.getString("TABLE_NAME")+"   "+rs.getString("TABLE_CAT") + ""n");            }
        } catch (Exception e) {
            MainFrame.msg.append(e.getMessage() + ""n");

        }

運行結果：（students 是自己建的數據庫，表為course,sc,student）

databases start!!!
information_schema
mysql
students
test
VIEW
LOCAL TEMPORARY
tables start!!!
course   students
sc   students
student   students