把ResultSet 值循环遍历之后再赋给相应的对象,然后再循环遍历到相应的集合中.docx

package com.test;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;/** * * @author 这个查询数据库的方法。 * */public class TestTableClass {//数据库连接public static Connection getConnection(){ Connection conn = null; try {Class.forName(com.mysql.jdbc.Driver);String url = jdbc:mysql://192.168.1.243:3306/aws;String user = root;String pass = root;conn = DriverManager.getConnection(url,user,pass); System.out.println(数据库连接成功了);} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} return conn;}/** * 定义一个查询所有的方法，查询出所有 的值，并且封装到一个集合中。用来显示相关的内容 * @param args */@SuppressWarnings(null)public static List selelcttable(String tablename) { Connection conn = getConnection(); ListSysbusinessmetadataMap sysbusinesList = new ArrayList() ; PreparedStatement stmt; //根据表名查询出相应的在另外一张表中的id try { String tablesql = SELECT a.* FROM sys_business_metadata_map a,sys_business_metadata b WHERE a.METADATA_ID = b.ID AND b.ENTITY_NAME = +tablename+;stmt = conn.prepareStatement(tablesql);ResultSet rssys = stmt.executeQuery(tablesql);while(rssys.next()){SysbusinessmetadataMap sysbusinessmetadataMap = new SysbusinessmetadataMap();String chinaName = rssys.getString(FIELD_TITLE);sysbusinessmetadataMap.setField_title(chinaName);//获得指定列的列名String columnName = rssys.getString(FIELD_NAME);sysbusinessmetadataMap.setField_name(columnName);//获得指定列的数据类型名String columnTypeName = rssys.getString(FIELD_TYPE);sysbusinessmetadataMap.setField_type(columnTypeName); //是否为空 int fieldnotnull = rssys.getInt(FIELD_NOTNULL); sysbusinessmetadataMap.setField_notnull(fieldnotnull); //获得列的模式 String fieldlength = rssys.getString(FIELD_LENGTH); sysbusinessmetadataMap.setField_length(fieldlength); int isdisplay = rssys.getInt(ISDISPLAY); sysbusinessmetadataMap.setI