import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; /** * @author user * */ public class GetTableColumNames { /** * * 获取指定库和表的字段集合工具类 * @param dbDriver jdbc驱动的包路径 * @param tableName 表名 * @param dbUrl 连接数据库url、用户名、密码 * @throws Exception Exception */ private static void getColumns(String dbDriver, String tableName, String... dbUrl) throws Exception { Class.forName(dbDriver).newInstance(); Connection con = DriverManager.getConnection(dbUrl[0], dbUrl[1], dbUrl[2]); Statement st = con.createStatement(); String sql = "select * from " + tableName + " where 1=2"; ResultSet rss = st.executeQuery(sql); ResultSetMetaData rsmd = rss.getMetaData(); int columnCount = rsmd.getColumnCount(); StringBuffer sb = new StringBuffer(); sb.append("select "); for (int i = 1; i <= columnCount; i++) { sb.append(rsmd.getColumnName(i).toLowerCase()); if (i != columnCount) sb.append(","); } sb.append(" from "); sb.append(tableName + " a where "); System.out.println(tableName + ":" + columnCount); FileUtil.makeFile("e://" + tableName + ".txt", sb.toString()); } /** * @param args * @throws Exception */ public static void main(String[] args) throws Exception { getColumns("oracle.jdbc.driver.OracleDriver", "INF_COLLECTION_AGT", "jdbc:oracle:thin:@10.41.24.234:1521:cbsdbser64", "k4dcdb1", "cbs"); } }