exercise25.java

这是我平是的一个小型基于java的数据库系统

import java.awt.event.*;
import javax.swing.*;
import java.awt.*;
public class Exercise25 extends JFrame {
   private JButton jbFirst=new JButton("First");
   private JButton jbNext=new JButton("Next");
   private JButton jbPrior=new JButton("Prior");
   private JButton jbLast=new JButton("Last");
   private JButton jbInsert=new JButton("Insert");
   private JButton jbDelete=new JButton("Delete");
   private JButton jbUpdate=new JButton("Update");
   private JLabel jlFirst=new JLabel("First Name");
   private JTextField jtFirst=new JTextField(10);
   private JLabel jlMI=new JLabel("MI");
   private JTextField jtMI=new JTextField(2);
   private JLabel jlLast=new JLabel("Last Name");
   private JTextField jtLast=new JTextField(20);
   private JLabel jlStreet=new JLabel("Street");
   private JTextField jtStreet=new JTextField(45);
   private JLabel jlCity=new JLabel("City");
   private JTextField jtCity=new JTextField(20);
   private JLabel jlState=new JLabel("State");
   private JTextField jtState=new JTextField(2);
   private JLabel jlZIP=new JLabel("ZIP");
   private JTextField jtZIP=new JTextField(15);
   private JLabel jlTel=new JLabel("Telephone");
   private JTextField jtTel=new JTextField(13);
   private JLabel jlEmail=new JLabel("Email");
   private JTextField jtEmail=new JTextField(25);
   private JLabel jlCurrent =new JLabel ("Current row number:");
   private JLabel jlnum=new JLabel();
   private JPanel jp1=new JPanel();
   private JPanel jp2=new JPanel();
   private DataBase database=new DataBase();
   public Exercise25(){
	   jp1.setLayout(new GridLayout(1,7,5,5));
	   jp1.add(jbFirst);
	   jp1.add(jbNext);
	   jp1.add(jbPrior);
	   jp1.add(jbLast);
	   jp1.add(jbInsert);
	   jp1.add(jbDelete);
	   jp1.add(jbUpdate);

       jp2.setLayout(new FlowLayout(FlowLayout.LEFT,10,10));
       jp2.add(jlFirst);
       jp2.add(jtFirst);
       jp2.add(jlMI);
       jp2.add(jtMI);
       jp2.add(jlLast);
       jp2.add(jtLast);
       jp2.add(jlStreet);
       jp2.add(jtStreet);
       jp2.add(jlCity);
       jp2.add(jtCity);
       jp2.add(jlState);
       jp2.add(jtState);
       jp2.add(jlZIP);
       jp2.add(jtZIP);
       jp2.add(jlTel);
       jp2.add(jtTel);
       jp2.add(jlEmail);
       jp2.add(jtEmail);
       jp2.add(jlCurrent);
       jp2.add(jlnum);

       add(jp1,BorderLayout.NORTH);
       add(jp2,BorderLayout.CENTER);

       jbFirst.addActionListener(new ActionListener(){
		    public void actionPerformed(ActionEvent e){
		    	try{
			  		  database.resultSet.first();
		    	}
		    	catch(Exception ex){
		    		}
		    	}
			});
			jbNext.addActionListener(new ActionListener(){
					    public void actionPerformed(ActionEvent e){
					    	try{
						      database.resultSet.next();
						      }
					    	catch(Exception es){
					    }
					 }
			});
       jbInsert.addActionListener(new ActionListener(){
		   public void actionPerformed(ActionEvent e){
			  database.add(jtFirst.getText().trim(),jtMI.getText().trim(),jtLast.getText().trim(),jtStreet.getText().trim(),jtCity.getText().trim(),jtState.getText().trim(),jtZIP.getText().trim(),jtTel.getText().trim(),jtEmail.getText().trim());
			  jlnum.setText(database.num+"");
			      }
			   });
   }
   public static void main(String[]args){
	   Exercise25 frame=new Exercise25();
	   frame.setTitle("Exercise25_1");
	   frame.setDefaultCloseOperation(3);
	   frame.setSize(580,230);
	   frame.setVisible(true);
   }
}