909544360f30001d17a39fa8a118b5a5

这个一个用j2se实现的汽车销售管理系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.util.*;
import javax.swing.table.*;
import java.sql.*;
public class PersonMoney extends JPanel implements ActionListener{
     private JLabel lbName=new JLabel("请输入修理工姓名:");
     private JTextField tfName=new JTextField("",15);
     private JButton btnQuery=new JButton("查询");
     private DefaultTableModel dtm=new DefaultTableModel();
     private JTable table=new JTable(dtm);
     private JScrollPane jscrollpane1=new JScrollPane(table);
     private JLabel lbMenoy=new JLabel("该修理工月工资为:");
     private JTextField tfMenoy=new JTextField(10);
     private ConToDB DB;
     
     public PersonMoney()
     {
    	 
    	 this.init();
    	 this.setVisible(true);
    	 
     }
     public void init()
     {
    	 JPanel ptop=new JPanel();
    	 ptop.add(lbName);
    	 ptop.add(tfName);
    	 ptop.add(btnQuery);
    	 
    	 
    	 JPanel pMid=new JPanel();
    	 dtm.addColumn("修理工姓名");
    	 dtm.addColumn("修理车牌号码");
    	 dtm.addColumn("修理小时");
    	 dtm.addColumn("小时工资");
    	 dtm.addColumn("修理工净收入");
    	 pMid.add(jscrollpane1);
    	 
    	 
    	 JPanel pbuttom=new JPanel();
    	 Color c=new Color(21,123,53);
    	 lbMenoy.setBackground(c);
    	 pbuttom.add(lbMenoy);
    	 pbuttom.add(tfMenoy);
    	 
    	 btnQuery.addActionListener(this);
    	 tfMenoy.setEditable(false);
    	 
    	 
    	 JPanel p=new JPanel();
    	 p.setLayout(new BorderLayout());
    	 p.add(ptop,"North");
    	 p.add(pMid,"Center");
    	 p.add(pbuttom,"South");
    	
    	 this.add(p);
    	 
    	 
    	 
     }
     public void actionPerformed(ActionEvent e)
     {
    	 if(e.getSource()==btnQuery)
    	 {
    		 dealBtQuery();
    	 }
     }
     
     public void dealBtQuery()
     {
    	 boolean flag=false;
    	 try
    	 {
    		 float sum=0;
    		 String Name=tfName.getText().trim();
    		 String sql="select * from CarInfo where personName=? ";
    	     DB=new ConToDB();
    	     DB.LinkDB();
    	    PreparedStatement st=DB.con.prepareStatement(sql);
    	    
    	    st.setString(1, Name);
    	    ResultSet rs=st.executeQuery();
    	    while(rs.next())
    	    {
    	    	
    	    	String CarNum=rs.getString(1);//获得车牌号码
    	    	
    	    	float UseTime=rs.getFloat(7);
    	    	String useTime=new String(UseTime+"");
    	    	float HourMoney=rs.getFloat(8);
    	    	String hourMoney=new String(""+HourMoney);
    	    	float PersonMenoy=UseTime*HourMoney;
    	    	String personMenoy=new String(""+PersonMenoy);
    	       sum+=PersonMenoy;
    	    	String [] str={Name,CarNum,useTime,hourMoney,personMenoy};
    	    	dtm.addRow(str);
    	    	flag=true;
    	    	
    	    }
    	    tfMenoy.setText(""+sum);
    	    tfMenoy.setForeground(Color.red);
    	    if(!flag)
    	    {
    	    	JOptionPane.showMessageDialog(this, "该修理员不存在，请核实你的输入！");
    	    }
    	    else 
    	    {
    	    	JOptionPane.showMessageDialog(this, "恭喜你操作成功！");
    	    }
    	   
    		 
    	 }
    	 catch(Exception e)
    	 {
    		 e.printStackTrace();
    	 }
     }
     public static void main(String [] args)
     {
    	 new PersonMoney();
     }
     
}