【实例简介】联系人管理Java加sql
【实例截图】
登陆账号:admin 密码 1234
【核心代码】
package frame;
import javax.swing.table.*;
import java.sql.*;
public class ResultSetTableModel extends AbstractTableModel {
private static final long serialVersionUID = 1L;
private ResultSet rs = null;
private ResultSetMetaData rsmd = null;
public ResultSetTableModel(ResultSet rs) {
this.rs = rs;
try {
rsmd = rs.getMetaData();
} catch (SQLException e) {
e.printStackTrace();
}
}
// 必须重写
public int getRowCount() {
int rowCount = 0;
try {
rs.last();
rowCount = rs.getRow();
return rowCount;
} catch (SQLException e) {
System.out.println(e.getMessage());
return -1;
}
}
// 必须重写
public int getColumnCount() {
try {
return rsmd.getColumnCount();
} catch (SQLException e) {
System.out.println(e.getMessage());
return -1;
}
}
// 必须重写
public Object getValueAt(int row, int column) {
try {
rs.absolute(row 1);
return rs.getObject(column 1);
} catch (SQLException e) {
System.out.println(e.getMessage());
return null;
}
}
// 可选:若不重写这个方法,则表格模型按照默认的 A B C D ... 依次命名各个字段
public String getColumnName(int column) {
try {
return rsmd.getColumnName(column 1);
} catch (SQLException e) {
return String.valueOf(column 1);
}
}
}