a03b4ada5e30001d1d3dd9f6da141579

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

import java.awt.*;
import java.awt.event.*;
import javax.swing.event.*;
import javax.swing.*;
import java.util.*;
import javax.swing.tree.*;
import javax.swing.table.*;

import java.sql.*;
public class PrintMenu  extends JPanel implements ActionListener{
	/*
	 *  车主姓名
   车牌号码
     维修原因
     更换部件
     耗用零件数
      维修工时
小时工资
维修人员
 零件费
 修车费
修理总费用
*/
	//private ImageIcon icon=new ImageIcon("2.jpg");
	//private JLabel lbImg=new JLabel(icon);
	private DefaultTableModel dtm=new DefaultTableModel();
	private JTable table=new JTable(dtm);
	private JScrollPane jscrollpane1=new JScrollPane(table);
	
	
	private JButton btnMessage=new JButton("打印发票信息");
	private ConToDB DB;
	JPanel ptop=new JPanel();
	
	public PrintMenu()
	{
		
		this.init();
		this.setVisible(true);
	}
	public void init()
	{
		ptop.add(btnMessage);
		btnMessage.addActionListener(this);
		
		
		dtm.addColumn("车主姓名");
		dtm.addColumn("车牌号码");
		dtm.addColumn("维修原因");
		dtm.addColumn("维修人员");
		dtm.addColumn("修理费");
		dtm.addColumn("零件费");
		dtm.addColumn("修车费");
		JPanel pMid=new JPanel();
		pMid.add(jscrollpane1);
		
		JPanel pAll=new JPanel();
		pAll.setLayout(new BorderLayout());
		pAll.add(ptop,"North");
		pAll.add(pMid,"Center");
		
	
		this.add(pAll);
		
		
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==btnMessage)
		{
			dealBtnMessage();
		}
	}
	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 ResultColumn=table.getColumn("维修原因");
   		DefaultTableCellRenderer ResultColumnRenderer=new DefaultTableCellRenderer();
   		ResultColumnRenderer.setBackground(new Color(22,145,3));
   		ResultColumnRenderer.setToolTipText("该列为维修原因");
   		ResultColumn.setCellRenderer(ResultColumnRenderer);
   		
   		TableColumn PersonColumn=table.getColumn("维修人员");
   		DefaultTableCellRenderer PersonColumnRenderer=new DefaultTableCellRenderer();
   		PersonColumnRenderer.setBackground(new Color(22,145,3));
   		PersonColumnRenderer.setToolTipText("该列为维修人员");
   		PersonColumn.setCellRenderer(PersonColumnRenderer);
   		
   		TableColumn MenoyColumn=table.getColumn("修理费");
   		DefaultTableCellRenderer MenoyColumnRenderer=new DefaultTableCellRenderer();
   		MenoyColumnRenderer.setBackground(new Color(22,145,3));
   		MenoyColumnRenderer.setToolTipText("该列修理费");
   		MenoyColumn.setCellRenderer(MenoyColumnRenderer);
   		
   		TableColumn ChangeColumn=table.getColumn("零件费");
   		DefaultTableCellRenderer ChangeColumnRenderer=new DefaultTableCellRenderer();
   		ChangeColumnRenderer.setBackground(new Color(22,145,3));
   		ChangeColumnRenderer.setToolTipText("该列零件费");
   		ChangeColumn.setCellRenderer(ChangeColumnRenderer);
   		
   		TableColumn ChangePayColumn=table.getColumn("修车费");
   		DefaultTableCellRenderer ChangePayColumnRenderer=new DefaultTableCellRenderer();
   		ChangePayColumnRenderer.setBackground(new Color(22,145,3));
   		ChangePayColumnRenderer.setToolTipText("该列修车费");
   		ChangePayColumn.setCellRenderer(ChangePayColumnRenderer);
   		
	}
	public void dealBtnMessage()
	{
		chooseColor();
		try
		{
			String sql="select * from CarInfo ";
			 DB=new ConToDB();
			 DB.LinkDB();
			Statement st=DB.con.createStatement();
			 
			 ResultSet rs=st.executeQuery(sql);
			 while(rs.next())
			 {
				
				 String Name=rs.getString(1);
				 String Num=rs.getString(2);
				 String Result=rs.getString(10);
				 
				String p = rs.getString(10);
				System.out.println(p);
			/*	float i=rs.getFloat(11);
				float j=rs.getFloat(12);
				float k=rs.getFloat(13);
				String RepPerson=new String(j+"");
				String RepChange=new String(i+"");
				String  AllMoney=new String(k+"");
				System.out.println(Name+":"+Num+":"+Result+":"+RepPerson+":"+RepChange+":"+AllMoney);
				//String [] obj={Name,Num,Result,Person,RepPerson,RepChange,AllMoney};
				//dtm.addRow(obj);*/
			 }
			 
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public static void main(String [] args)
	{
		new PrintMenu();
	}
	

}