import java.sql.ResultSet; public class MyTable { private static DefaultTableModel table=null; public static DefaultTableModel getTable(String sql){ //String sql是一条select语句 if(table==null){ try { ResultSet rs=new MySQL().myslect(sql); //MySQL是我前两天写的连接数据库的类 Vector heads=new Vector(); ResultSetMetaData rsmd=rs.getMetaData(); int count=rsmd.getColumnCount(); //获得表的列数 for(int i=1;i<=count;i++){ //获得表头,存于Vector heads中 heads.add(rsmd.getColumnLabel(i)); } table=new DefaultTableModel(null,heads); //把表头添加到表中 table.setRowCount(0); while(rs.next()){ //获得表每行的内容,并添加到表中 Vector row=new Vector(); for(int i=1;i<=count;i++) row.add(rs.getString(i)); table.addRow(row); } } catch (Exception e) { } } return table; } }