JTable 與oralce 數據庫

package test; import java.awt.*; import java.awt.event.*; import javax.swing.*; import javax.swing.table.DefaultTableModel; import java.sql.*; import java.io.*; public class DBShow extends JFrame implements ActionListener{ JLabel label=new JLabel("顯示數據庫中的數據"); JButton display = new JButton("顯示數據列表"); JTable table=new JTable(); JScrollPane jscrollpane = new JScrollPane(table);//將表格加個滾動條 DBShow(){ //super(s); this.setLayout(new BorderLayout()); this.add(label,BorderLayout.NORTH); this.add(jscrollpane,BorderLayout.CENTER); this.add(display,BorderLayout.SOUTH); display.addActionListener(this); this.setSize(600,400); //設置JFrame窗口大小 this.setVisible(true);//設置窗口顯示TRUE } public void actionPerformed(ActionEvent arg0) { // TODO Auto-generated method stub String[] names; String sql; int i=0; Connection conn=null; Statement stmt=null; ResultSet rs; String[] col = {"用戶名", "類型", "簡稱","中文名","地址"}; DefaultTableModel mm= new DefaultTableModel(col,0); //定義一個表的模板 try{ Class.forName("oracle.jdbc.driver.OracleDriver"); String url="jdbc:oracle:thin:@192.168.1.10:1521:test"; conn=DriverManager.getConnection(url,"test","test"); stmt=conn.createStatement(); sql="select vendor,vnd_type, sim_name,cht_name,v_address from fbvendor where vendor between 'AL001' and 'BF001'"; rs=stmt.executeQuery(sql); i=0; while(rs.next()){ String username=rs.getString("username"); String vnd_type=rs.getString("vnd_type"); String sim_name=rs.getString("sim_name"); String cht_name=rs.getString("cht_name"); String v_address=rs.getString("v_address"); String[] info={vendor,vnd_type,sim_name,cht_name,v_address}; mm.addRow(info); i++; } table.setModel(mm);//將table 這個表設置為剛剛定義的模板 this.add(jscrollpane);//將加載了表的滾動條在JFrame 中顯示 } catch(ClassNotFoundException ex){ System.out.println("ClassNotFoundException"+ex.getMessage()); } catch(SQLException sqlex){ System.out.println("SQLException "+sqlex.getMessage()); } } public static void main(String[] args) throws Exception{ new DBShow(); } }