使用JTable组件操作数据库中的表
使用JTable组件显示message表的记录、更新message表的记录、像message表插入记录。本例共有4个Java源文件，需分别保存编译，其中Example.java是主类，效果图如
Example.java代码
1 import javax.swing.*; 2 import java.awt.*; 3 import java.awt.event.*; 4 import java.sql.*; 5 public class Example{ 6 public static void main(String args[ ]){ 7 try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 8 } 9 catch(ClassNotFoundException e){ 10 System.out.println(""+e); 11 } 12 DatabaseWin win=new DatabaseWin(); 13 } 14 } 15 class DatabaseWin extends JFrame implements ActionListener{//主窗口 16 JMenuBar menubar; 17 JMenu menu; 18 JMenuItem itemShow,itemUpdate,itemInsert; 19 ShowRecord showRecord; 20 ModifyRecord modifyRecord; 21 InsertRecord insertRecord; 22 DatabaseWin(){ 23 menubar=new JMenuBar(); 24 menu=new JMenu("操作数据库"); 25 itemShow=new JMenuItem("显示记录"); 26 itemUpdate=new JMenuItem("更新记录"); 27 itemInsert=new JMenuItem("插入记录"); 28 itemShow.addActionListener(this); 29 itemUpdate.addActionListener(this); 30 itemInsert.addActionListener(this); 31 menu.add(itemShow); 32 menu.add(itemUpdate); 33 menu.add(itemInsert); 34 menubar.add(menu); 35 showRecord=new ShowRecord("显示记录对话框"); 36 modifyRecord=new ModifyRecord("修改记录对话框"); 37 insertRecord=new InsertRecord("插入记录对话框"); 38 setJMenuBar(menubar); 39 setBounds(100,100,370,250); 40 setVisible(true); 41 setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); 42 } 43 public void actionPerformed(ActionEvent e){ 44 if(e.getSource()==itemShow) 45 showRecord.setVisible(true); 46 else if(e.getSource()==itemUpdate) 47 modifyRecord.setVisible(true); 48 else if(e.getSource()==itemInsert) 49 insertRecord.setVisible(true); 50 } 51 }
ShowRecord.java代码
1 import javax.swing.* ; 2 import java.awt.* ; 3 import java.awt.event.* ; 4 import java.sql.* ; 5 public class ShowRecord extends JDialog implements ActionListener //负责显示记录的类 6 { 7 JTable table ; 8 Object a[][] ; 9 Object name[]={"学号","姓名","出生日期","身高"} ; 10 JButton showRecord ; 11 Connection con ; 12 Statement sql ; 13 ResultSet rs ; 14 ShowRecord(String title){ 15 setTitle(title) ; 16 showRecord=new JButton("显示记录") ; 17 showRecord.addActionListener(this) ; 18 add(showRecord,BorderLayout.NORTH) ; 19 setBounds(200,60,400,250) ; 20 } 21 public void actionPerformed(ActionEvent e){ 22 try 23 { 24 con=DriverManager.getConnection("jdbc:odbc:hello","","") ; 25 sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY) ; 26 rs=sql.executeQuery("SELECT * FROM message") ; 27 rs.last() ; 28 int lastNumber=rs.getRow() ; 29 a=new Object[lastNumber][4] ; 30 int k=0 ; 31 rs.beforeFirst() ; 32 while(rs.next()){ 33 a[k][0]=rs.getString(1) ; 34 a[k][1]=rs.getString(2) ; 35 a[k][2]=rs.getDate(3) ; 36 a[k][3]=rs.getString(4) ; 37 k++ ; 38 } 39 con.close() ; 40 } 41 catch (SQLException ee) 42 { 43 System.out.println(ee) ; 44 } 45 table=new JTable(a,name) ; 46 getContentPane().removeAll() ; 47 add(showRecord,BorderLayout.NORTH) ; 48 add(new JScrollPane(table),BorderLayout.CENTER) ; 49 validate() ; 50 } 51 }
ModifyRecord.java代码
1 import javax.swing.*; 2 import java.awt.*; 3 import java.awt.event.*; 4 import java.sql.*; 5 import javax.swing.border.*; 6 public class ModifyRecord extends JDialog implements ActionListener{ //负责更新记录的类 7 JLabel hintLabel; 8 JTextField inputNumber; 9 Object name[]={"姓名","出生日期","身高"}; 10 Object a[][]=new Object[1][3]; 11 JTable table; 12 JButton enterModify; 13 Connection con; 14 Statement sql; 15 ResultSet rs; 16 String num; 17 ModifyRecord(String s){ 18 setTitle(s); 19 hintLabel=new JLabel("输入学号(回车确认):"); 20 inputNumber=new JTextField(20); 21 table=new JTable(a,name); 22 enterModify=new JButton("更新记录"); 23 setLayout(null); 24 Box baseBox=Box.createHorizontalBox(); 25 baseBox.add(hintLabel); 26 baseBox.add(inputNumber); 27 baseBox.add(new JScrollPane(table)); 28 baseBox.add(enterModify); 29 add(baseBox); 30 baseBox.setBounds(10,40,600,38); 31 inputNumber.addActionListener(this); 32 enterModify.addActionListener(this); 33 setBounds(20,60,700,200); 34 } 35 public void actionPerformed(ActionEvent e){ 36 if(e.getSource()==inputNumber) 37 try{ num=inputNumber.getText().trim(); 38 con=DriverManager.getConnection("jdbc:odbc:hello","",""); 39 sql=con.createStatement(); 40 rs=sql.executeQuery("SELECT * FROM message WHERE number='"+num+"'"); 41 boolean boo=rs.next(); 42 if(boo==false){ 43 JOptionPane.showMessageDialog 44 (this,"学号不存在","提示",JOptionPane.WARNING_MESSAGE); 45 } 46 else{ 47 a[0][0]=rs.getString(2); 48 a[0][1]=rs.getDate(3).toString(); 49 a[0][2]=rs.getString(4); 50 table.repaint(); 51 } 52 con.close(); 53 } 54 catch(SQLException ee){ 55 System.out.println(ee); 56 } 57 if(e.getSource()==enterModify){ 58 try{ con=DriverManager.getConnection("jdbc:odbc:hello","",""); 59 sql=con.createStatement(); 60 sql.executeUpdate 61 ("UPDATE message SET name='"+a[0][0]+ 62 "',birthday='"+a[0][1]+ 63 "',height='"+a[0][2]+"'WHERE number='"+num+"'"); 64 JOptionPane.showMessageDialog 65 (this,"更新成功","成功",JOptionPane.PLAIN_MESSAGE); 66 con.close(); 67 } 68 catch(SQLException ee){ 69 JOptionPane.showMessageDialog 70 (this,"更新失败"+ee,"失败",JOptionPane.ERROR_MESSAGE); 71 } 72 } 73 } 74 }
InsertRecord.java代码
1 import javax.swing.*; 2 import java.awt.*; 3 import java.awt.event.*; 4 import java.sql.*; 5 import javax.swing.border.*; 6 public class InsertRecord extends JDialog implements ActionListener{ //负责插入记录的类 7 JLabel hintLabel; 8 Object name[]={"学号","姓名","出生日期","身高"}; 9 Object a[][]=new Object[1][4]; 10 JTable table; 11 JButton enterInsert; 12 Connection con; 13 Statement sql; 14 ResultSet rs; 15 String num; 16 InsertRecord(String s){ 17 setTitle(s); 18 hintLabel=new JLabel("输入新记录:"); 19 table=new JTable(a,name); 20 enterInsert=new JButton("插入新记录"); 21 setLayout(null); 22 Box baseBox=Box.createHorizontalBox(); 23 baseBox.add(hintLabel); 24 baseBox.add(new JScrollPane(table)); 25 baseBox.add(enterInsert); 26 add(baseBox); 27 baseBox.setBounds(10,40,600,38); 28 enterInsert.addActionListener(this); 29 setBounds(120,160,700,200); 30 } 31 public void actionPerformed(ActionEvent e){ 32 try{ con=DriverManager.getConnection("jdbc:odbc:hello","",""); 33 sql=con.createStatement(); 34 int k=sql.executeUpdate 35 ("INSERT INTO message VALUES('"+ 36 a[0][0]+"','"+a[0][1]+"','"+a[0][2]+"','"+a[0][3]+"')"); 37 if(k==1) 38 JOptionPane.showMessageDialog 39 (this,"插入记录成功","成功",JOptionPane.PLAIN_MESSAGE); 40 con.close(); 41 } 42 catch(SQLException ee){ 43 JOptionPane.showMessageDialog 44 (this,"插入记录失败"+ee,"失败",JOptionPane.ERROR_MESSAGE); 45 } 46 } 47 }
