computerframe.java

一个水气收费系统 具有 删除 查询等功能

import java.awt.*;
import java.awt.event.*;
import javax.swing.* ;
import java.sql.* ;
import java.lang.Object ;

/**
 * Sample application using Frame.
 *
 * @author 
 * @version 1.00 07/01/03
 */
public class ComputerFrame extends JFrame {
    
    /**
     * The constructor.
     */  
     
       Integer i[] = new Integer[25] ;
          
            List list = new List() ;
            List list1 = new List(4) ;
            TextField tf[] = {  new TextField(),
                                new TextField(),
                                new TextField(),
                                
                                new TextField(),
                                new TextField()		,
                                new TextField(),
                                
                                new TextField(),
                                new TextField(),
                                new TextField(),
                                
                                new TextField(),
                                new TextField(),
                                new TextField(),
                                
                                new TextField(),
                                new TextField(),
                                new TextField(),
                                
                                new TextField(),
                                new TextField(),
                                new TextField(),
                                new TextField(),
                                
                                new TextField(),
                                new TextField(),
                                new TextField(),
                                
                                new TextField(),
                                new TextField(),
                                new TextField(),
                                new TextField()
                                } ;
            TextArea ta = new TextArea() ;
            
            JButton button = new JButton("next user") ;
            JButton buttonw = new JButton("water") ;
            JButton buttong = new JButton("gas") ;
            JButton buttona = new JButton("add") ;
            JButton buttond = new JButton("delete") ;
            JButton buttonl = new JButton("look") ;
            JButton button1 = new JButton("userid") ;
            JButton button2 = new JButton("apply") ;
            JButton buttonnext = new JButton("next user") ;
     	private JTabbedPane tbpane ;
     	private JPanel panel1 ;
     	private JPanel panel2 ;
     	private JPanel panel3 ;
     	private JPanel panel4 ;
        
       // Connection conn = null ;   
        //Statement Stmt = null ;     
       // PreparedStatement prepStmt = null ;
     public ComputerFrame() 
     {
                
        setTitle( "Date" );
        setSize( 400, 300 );
        setBackground( Color.red );
        
        JPanel toppanel = new JPanel() ;
        toppanel.setLayout( new BorderLayout() ) ;
        getContentPane().add( toppanel ) ;
        
        
         createpage1() ;
         createpage2() ;
         createpage3() ;
         createpage4() ;
        
         	 
        tbpane = new JTabbedPane() ;
        tbpane.add("money",panel1) ;
        tbpane.add("select",panel2) ;
        tbpane.add("user",panel3) ;  
        tbpane.add("price",panel4) ;
        toppanel.add(tbpane,BorderLayout.CENTER) ;
         
      
    }//frame
    
    public void createpage1()
        {    
              
        	panel1 = new JPanel() ;
        	
        	panel1.setLayout(new BorderLayout()) ;
        	
        	JPanel p1 = new JPanel() ;
         
        	JPanel p3 = new JPanel() ;
             
            
                     
           	p1.setLayout(new GridLayout(2,2)) ;
        	p1.add(new Label("water price:",Label.LEFT)) ;
        	p1.add(new Label("gas price:",Label.LEFT)) ;
        	p1.add(tf[1]) ;
        	p1.add(tf[2]) ;
        	panel1.add(p1,BorderLayout.NORTH) ;
        	
            p3.setLayout(new GridLayout(11,2) ) ;
        	p3.add(new Label("userID:"),Label.LEFT) ;
        	p3.add(tf[3]) ;
        	p3.add(new Label("")) ;
        	p3.add(button1) ;
         
        	p3.add(new Label("lasttime water:",Label.LEFT) ) ;
        	p3.add(tf[4]) ;
        	p3.add(new Label("lasttime gas:",Label.LEFT) ) ;
        	p3.add(tf[5]) ;
        	//p3.add(button) ;
        	
        	p3.add(new Label("this time water:",Label.LEFT) ) ;
        	p3.add(tf[6]) ;
        	p3.add(new Label("this time gas:",Label.LEFT) ) ;
        	p3.add(tf[7]) ;
            
            p3.add(new Label("")) ;
            p3.add(button2) ;
            
            
        	p3.add(new Label("water money:",Label.LEFT) ) ;
        	p3.add(tf[8]) ;
        	p3.add(new Label("gas money:",Label.LEFT) ) ;
        	p3.add(tf[9]) ;
        	p3.add(new Label("money:") ) ;
        	p3.add(tf[10]) ; 
        	p3.add(button) ;
        	panel1.add(p3,BorderLayout.CENTER) ;
        	
        try
        {	
             
        
        	sele sele = new sele("price") ;
        	 System.out.println("price1") ;
         
           
            if(sele.rsd.last())
            
            {
            
              i[0] = sele.rsd.getInt(1) ;
              i[1] = sele.rsd.getInt(2) ;
            }
            else
            {
            	i[0] = 0 ;
            	i[1] = 0 ;
            }
          
        }
        catch(Exception ex)
        {
         JOptionPane.showMessageDialog(new JFrame(), "Wrong price", "Dialog", 
                          JOptionPane.ERROR_MESSAGE); 
        }    
            tf[1].setText(i[0].toString()) ;
            tf[2].setText(i[1].toString()) ;
            
            	button1.addActionListener(
        			new ActionListener()
        	 {
                 public void actionPerformed(ActionEvent e) 
                  {
                  	try
                  	{
                  	
                     i[2] = Integer.parseInt(tf[3].getText()) ;  	
                     sele sele = new sele("da",i[2]) ;
                     
                     
                        sele.rsd.last() ;
                     
                      
                        i[3] = sele.rsd.getInt(2) ;
                        i[4] = sele.rsd.getInt(3) ;
                      
                     
                     tf[4].setText(i[3].toString()) ;
                     tf[5].setText(i[4].toString()) ;
                     
                      
                      
                      
                      
                      
                          button2.addActionListener(
         		new ActionListener()
        	 {
                 public void actionPerformed(ActionEvent e) 
                  { 
                      i[5] = Integer.parseInt(tf[6].getText()) ;
                      i[6] = Integer.parseInt(tf[7].getText()) ;
                      
                       if(i[5] < i[3] || i[6] < i[4])
                      {
                      	  JOptionPane.showMessageDialog(new JFrame(), "Wrong date", "Dialog", 
                          JOptionPane.ERROR_MESSAGE); 
                      }//if
                      
                      
                      i[7] = (i[5]-i[3])*i[0] ;
                      i[8] = (i[6]-i[4])*i[1] ;   
                      
                      i[9] = i[7] + i[8] ;
                      
                      tf[8].setText(i[7].toString()) ;
                      tf[9].setText(i[8].toString()) ;
                      tf[10].setText(i[9].toString()) ;  
                      
                     
                          
             
                     
                      
                  }//actionperformed
              }//action
                      ) ;//button2
                     }//try
                    catch(Exception ex)
                    {
                          JOptionPane.showMessageDialog(new JFrame(), "Wrong no user", "Dialog", 
                          JOptionPane.ERROR_MESSAGE); 
                    } 
                     
                  } //actionPerformed
             }  //button1
             ) ;//button1
               
        	 
                   button.addActionListener(
                    	new ActionListener()
                    	{
                    		public void actionPerformed(ActionEvent e)
                    		{
                    			
                    			i[2] = Integer.parseInt(tf[3].getText()) ;
                    			i[5] = Integer.parseInt(tf[6].getText()) ;
                    			i[6] = Integer.parseInt(tf[7].getText()) ;
                    			i[7] = Integer.parseInt(tf[8].getText()) ;
                    			i[8] = Integer.parseInt(tf[9].getText()) ;
                    			i[9] = Integer.parseInt(tf[10].getText()) ;
                    			inse inse = new inse(i[2],i[5],i[6],i[7],i[8],i[9]) ; 
                    			
                    			tf[3].setText("") ;
                    			tf[4].setText("") ;
                    			tf[5].setText("") ;
                    			tf[6].setText("") ;
                    			tf[7].setText("") ;
                    			tf[8].setText("") ;
                    			tf[9].setText("") ;
                    			tf[10].setText("") ;
                    			 
                    			
                    		}
                    	}
                    	
                    	) ;//button  
        
        }//createpage1
    
    public void createpage2() 
    {
    		panel2 = new JPanel() ;
        	
        	panel2.setLayout( new BorderLayout()) ;
        	
        	JPanel panel = new JPanel() ;
        	
        	panel.setLayout(new GridLayout(2,3)) ;
        	
            panel.add(new Label("userID",Label.LEFT)) ;
        	
        	panel.add(new Label("userName:",Label.LEFT)) ;
        	
        	panel.add(new Label("userAddress",Label.LEFT)) ;
        	
        	panel.add(tf[11]) ;