简单问题:用Jtable显示数据库中的记录,帮小弟添加这段小程序
请看程序中间部分的文字说明,谢谢。
import java.awt.*;
import java.awt.event.*;
import java.awt.Font;
import javax.swing.*;
import javax.swing.table.*;
import java.sql.*;
import java.util.*;
public class Search extends JFrame implements ActionListener{
private javax.swing.JPanel jpnlSearch = new javax.swing.JPanel();
private javax.swing.JLabel jlblSearchTitle = new javax.swing.JLabel("商品情报一览(情报检索)");
private javax.swing.JButton jbtnSearchMain = new javax.swing.JButton(" 主菜单");
private javax.swing.JTable jtblSearch;
private int iWidth=700;
private int iHeight=380;
private Connection conn;
private Statement stm;
private ResultSet rest;
private String SQL;
Vector vcData = new Vector(20,20);
Vector vcTitle=new Vector(10,10);
public void openDatabase() throws SQLException{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e) {}
conn=DriverManager.getConnection("jdbc:odbc:MyDatabase","","");
stm=conn.createStatement();
}
public Search() {
super();
java.awt.Dimension dPoint = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
dPoint.width = (dPoint.width - iWidth) / 2;
dPoint.height = (dPoint.height - iHeight) / 2;
setBounds(dPoint.width ,dPoint.height ,iWidth ,iHeight);
setResizable(false);
init();
}
void init(){
jpnlSearch.setLayout(null);
getContentPane().add(jpnlSearch);
jlblSearchTitle.setBounds(10,0,350,60);
jlblSearchTitle.setFont(new Font("宋体",Font.PLAIN,24));
jlblSearchTitle.setForeground(java.awt.Color.black);
jpnlSearch.add(jlblSearchTitle,null);
jbtnSearchMain.setBounds(550,10,120,30);
jbtnSearchMain.setFont(new Font("",Font.PLAIN,12));
jbtnSearchMain.setForeground(java.awt.Color.black);
jpnlSearch.add(jbtnSearchMain,null);
jbtnSearchMain.addActionListener(this);
try{
this.openDatabase();
SQL="select * from KENS001 where DelFlg='0' order by ShohinCd";
ResultSet rest=stm.executeQuery(SQL);
// 哪位帮忙将这里添上程序代码,将查询到的数据添加到
// jtblSearch(已经定义了)中去,并且使表格中的数据
// 能够滚动上下左右滚动
rest.close();
}catch(SQLException e){
do{
System.err.println("\nSQLException--------------------");
System.err.println("SQLState:"+e.getSQLState());
System.err.println("SQLMessage:"+e.getMessage());
System.exit(0);
}while((e=e.getNextException())!=null);
}
}
public static void main(String[] args) throws SQLException{
Search frmSearch=new Search();
frmSearch.show();
frmSearch.addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent evt) {
System.exit(0);
}
});
}
public void actionPerformed(ActionEvent evt) {
if (evt.getSource()==jbtnSearchMain) {
System.exit(0);
}
}
}