Java：读取本连接中所有数据表的名称

package com.happy.ssh;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import com.happy.util.DBHelper;

public class ReadTables {
 private Connection conn;
 private ResultSet rs;
 private String sql = "";

 /**
  * 得到该数据所有的表名
  * @return
  */
 public List<String> getTablesName() {
  List<String> list = new ArrayList<String>();
  conn = DBHelper.getConn();
  sql = "exec sp_tables";
  try {
   rs = conn.prepareCall(sql).executeQuery();
   while (rs.next()) {
    if ("TABLE".equals(rs.getString(4))) {
     list.add(rs.getString(3));
    } else {
     break;
    }
   }

   // conn.prepareCall( "{call procedure_name(?,?)} ");
   /*
    * 循环获取resultset里面所有的数据 int i = 1; while(rs.next()){ if(i == 6) i =
    * 1; System.out.println(rs.getString(i)); i++; }
    */
  } catch (SQLException e) {
   e.printStackTrace();
  }
  
  return list;
 }

 public static void main(String[] args) {
  ReadTables readTables = new ReadTables();
  List<String> list = readTables.getTablesName();
  for (Iterator<String> iterator = list.iterator(); iterator.hasNext();) {
   String string = iterator.next();
   System.out.println(string);
  }
 }
}