java,jtable,更新表格数据
篇一: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.INFORMATI