a03cb5ec8f30001d14bca828f5ee0475

这个一个用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);
    	 lbName.setForeground(Color.blue);
    	 ptop.setBackground(Color.red);
    	 
    	 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()
     {
    	 chooseColor();
    	 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.setHorizontalAlignment(JTextField.CENTER);
    	    tfMenoy.setText(""+sum);
    	    tfMenoy.setForeground(Color.red);
    	    if(!flag)
    	    {
    	    	JOptionPane.showMessageDialog(this, "该修理员不存在，请核实你的输入！");
    	    }
    	    else 
    	    {
    	    	JOptionPane.showMessageDialog(this, "恭喜你操作成功！");
    	    }
    	   
    		 
    	 }
    	 catch(Exception e)
    	 {
    		 e.printStackTrace();
    	 }
     }
     public void chooseColor()
     {
    	 TableColumn NameColumn=table.getColumn("修理工姓名");
 		DefaultTableCellRenderer NameColumnRenderer=new DefaultTableCellRenderer();
 		NameColumnRenderer.setBackground(Color.yellow);
 		NameColumnRenderer.setToolTipText("该列为修理工姓名");
 		NameColumn.setCellRenderer(NameColumnRenderer);
 		
 		 TableColumn IDColumn=table.getColumn("修理车牌号码");
  		DefaultTableCellRenderer IDColumnRenderer=new DefaultTableCellRenderer();
  		IDColumnRenderer.setBackground(new Color(22,145,3));
  		IDColumnRenderer.setToolTipText("该列为车牌号码");
  		IDColumn.setCellRenderer(IDColumnRenderer);
 		
  		
  		TableColumn HourColumn=table.getColumn("修理小时");
  		DefaultTableCellRenderer HourColumnRenderer=new DefaultTableCellRenderer();
  		HourColumnRenderer.setBackground(Color.green);
  		HourColumnRenderer.setToolTipText("修理该车所需时间");
  		HourColumn.setCellRenderer(HourColumnRenderer);
  		
  		
  		TableColumn HourPayColumn=table.getColumn("小时工资");
  		DefaultTableCellRenderer HourPayColumnRenderer=new DefaultTableCellRenderer();
  		HourPayColumnRenderer.setBackground(Color.yellow);
  		HourPayColumnRenderer.setToolTipText("修理工小时工资");
  		HourPayColumn.setCellRenderer(HourPayColumnRenderer);
  		
  		
  		
  		TableColumn PayColumn=table.getColumn("修理工净收入");
  		DefaultTableCellRenderer PayColumnRenderer=new DefaultTableCellRenderer();
  		PayColumnRenderer.setBackground(Color.BLUE);
  		PayColumnRenderer.setToolTipText("修理工净收入");
  		PayColumn.setCellRenderer(PayColumnRenderer);
  		
 		
 		
     }
     public static void main(String [] args)
     {
    	 new PersonMoney();
     }
     
}