//这是按钮的实现
btSearch.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
String sno=textField_sno.getText();
String sql="select* from studentdata where sno="+sno;
try {
ResultSet rs=LinkSQL.executeQuery(sql);
while(rs.next()){
Vector<Object> v=new Vector<Object>();
v.add(rs.getInt("sno"));
v.add(rs.getString("sname"));
v.add(rs.getString("Ssex"));
v.add(rs.getInt("sage"));
v.add(rs.getString("sdept"));
data.add(v);
}
LinkSQL.close();
} catch (SQLException c) {
c.printStackTrace();
}
}
});
//最后显示查询到的结果没有显示到table上,滚动条也没有出现
dtm = new DefaultTableModel(data,columnNames);
table = new JTable(dtm);
table.getTableHeader().setFont(new Font("宋体",Font.BOLD,14));
table.setFont(new Font("宋体",Font.PLAIN,14));
table.setRowHeight(20);
TableRowSorter sorter = new TableRowSorter(table.getModel());
table.setRowSorter(sorter);
table.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
table.getSelectionModel().setSelectionInterval(0, 0);
JScrollPane ScrollPane=new JScrollPane(table);
panel_table.add(ScrollPane);
table.setFillsViewportHeight(true);
ScrollPane.setViewportView();
数据查询出来了吗,把查询的数据输出一下
参考:
//刷新表格数据
public void refresh() {
//读取数据库的数据
rowData = dao.list();
//更新表格数据
((DefaultTableModel)dataTable.getModel()).setDataVector(rowData, head);
}