java的jtable、从数据库取数据显示在表格中教学文稿.docVIP

Java的Jtable、从数据库取数据显示在表格中 __________________________________________________ __________________________________________________ __________________________________________________ __________________________________________________ __________________________________________________ __________________________________________________ 数据库操作代码： //?Load?JDBC?driver ??Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); ?? ??String?dbUrl?=?jdbc:odbc:driver={Microsoft?Access?Driver?(*.mdb)};DBQ=access\\test.mdb; ??Connection?con?=?DriverManager.getConnection(dbUrl,?, ); ??Statement?state?=?con.createStatemen(ResultSet.TYPE_SCROLL_SENSITIVE, ??????????????????????????????????????ResultSet.CONCUR_UPDATABLE); ??//?执行SQL语句 ??String?sql?=?select?*?from?score; ??ResultSet?rs?=?state.executeQuery(sql); ??displayResultSet(rs); ??rs.close(); ??state.close(); ??con.close(); ? 将数据显示在表格中： ? ????private?void?displayResultSet(ResultSet?rs)?throws?SQLException?{ ????????boolean?moreRecords?=?rs.next();?//?定位到达第一条记录 ????????if?(!moreRecords)?{ ????????????JOptionPane.showMessageDialog(null,?结果集中无记录,?无记录, ????????????????????JOptionPane.INFORMATION_MESSAGE); ????????????return; ????????} ????????Vector?rows?=?new?Vector(); ????????Vector?columnHeads?=?new?Vector(); ????????try?{ ????????????ResultSetMetaData?rsmd?=?rs.getMetaData();?//?获得rs结果集中列属性信息 ????????????for?(int?i?=?1;?i?=?rsmd.getColumnCount();?++i) ????????????????columnHeads.addElement(rsmd.getColumnName(i));?//?获得列名(将列名存放至向量columnHeads) ????????????do?{ ????????????????rows.addElement(getNextRow(rs,?rsmd)); ????????????}? ????????????while?(rs.next());?//?利用循环获得所有记录 ????????????jTable?=?new?JTable(rows,?columnHeads);?//?将获得的行列数据信息作为参数重新构造表格视图 ????????????jTable.setSize(new?Dimension(383,?81)); ????????????JScrollPane?scroller?=?new?JScrollPane(jTable);//?创建带有滚动条的面板,并将表格视图加入 ????????????Container?c?=?getContentPane();?//?获取溶器 ????????????//?c.remove(2);?// ????????????//?从溶器中移除指定控件(本窗体中有二级面板有两个,第一个存放文本域及按钮,第二个存放表格视图,故移除1) ????????????c.a