java 排序库_Java数据库排序

privateJButtongetJButtonOK(){if(jButtonOK==null){jButtonOK=newJButton();jButtonOK.setBounds(newRectangle(20,32,100,22));jButtonOK.setText("按姓名排序");jButtonOK.addMouse...

private JButton getJButtonOK() {

if (jButtonOK == null) {

jButtonOK = new JButton();

jButtonOK.setBounds(new Rectangle(20, 32, 100, 22));

jButtonOK.setText("按姓名排序");

jButtonOK.addMouseListener(new java.awt.event.MouseAdapter() {

public void mouseClicked(java.awt.event.MouseEvent e) {

try {

TurnSQL();

} catch (Exception e1) {

// TODO 自动生成 catch 块

e1.printStackTrace();

} // TODO Auto-generated Event stub mouseClicked()

}

private void TurnSQL() throws Exception {

Statement stmt=null;

ResultSet rs=null;

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:sun","","");

stmt=con.createStatement();

rs=stmt.executeQuery("Select * From StuInfo ORDER BY Num");

stmt.executeUpdate();

stmt.close();

con.close();

MainForm.Reflesh();

getJFrame().dispose();

}

});

}

stmt.executeUpdate();这个括号里该填什么？

如果要以Num这列来对表格排序 并且在表格上更新显示排序后的结果 代码该怎么写？

要不直接给个Access数据库 表格排序代码也行

展开