对数据库所有表名的读取

 

connection  这个比较简单就不写了  谢最主要的实现 利用URL就可以的    要是想看connection 就看下一片吧  一般不许我我就没写在这上面的

package cn.edu.nwsuaf.cie.aisa.wsc.operation;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Hashtable;
import java.util.List;

import com.mysql.jdbc.ResultSetMetaData;

public class DataBaseAttribute {
 ConnectionSource dbConnectionSourceImpl = null; //  这是一个接口定义的
 ResultSet resultSet = null;
 public Hashtable<String, Object> row = null;
 PreparedStatement preparedStatement = null;
 
 public List<String> listattributeList =  null;

 public List<String> getAttribute(String tableNameString) {
  dbConnectionSourceImpl = new DBConnectionSourceImpl();
  Connection connection = dbConnectionSourceImpl.getConnection();
  try {
   preparedStatement = connection.prepareStatement("select * from "
     + tableNameString);
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  ResultSet resultSet = null;
  try {
   resultSet = preparedStatement.executeQuery();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }

  ResultSetMetaData metaData = null;
  try {
   metaData = (ResultSetMetaData) resultSet.getMetaData();
  } catch (SQLException e1) {
   // TODO Auto-generated catch block
   e1.printStackTrace();
  }
  //Map< Object,Object> attributemMap = null;
   listattributeList = new ArrayList<String>();
  try {
   //while (resultSet.next()) {
    for (int i = 1; i <= metaData.getColumnCount(); i++) {
     //attributemMap = new HashMap<Object, Object>();
     System.out.println("metaData.getColumnCount()"+metaData.getColumnCount());
     System.out.println(metaData.getColumnName(i));
     listattributeList.add(metaData.getColumnName(i));
     //attributemMap.put(metaData.getColumnName(i), resultSet.getObject(i));
    }
    //listattributeList.add(attributemMap);
   //}
  } catch (SQLException e1) {
   // TODO Auto-generated catch block
   e1.printStackTrace();
  }
  try {
   resultSet.close();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  try {
   preparedStatement.close();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  try {
   connection.close();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return listattributeList;
    
 }
}