f0336b520530001d17a39fa8a118b5a5

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

import javax.swing.*;
import javax.swing.event.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.*;

import javax.swing.table.DefaultTableModel;
import javax.swing.tree.*;
import javax.swing.table.*;
public class QueryUser extends JPanel implements ActionListener{

	/**
	 * @param args
	 */
	private JButton btnQuery=new JButton("查询");
	private DefaultTableModel dtm=new DefaultTableModel();
	private JTable table=new JTable(dtm);
	private JScrollPane jscrollpane=new JScrollPane(table);
	private JRadioButton btnID=new JRadioButton("按车牌编号查询");
	private JRadioButton btnName=new JRadioButton("按车主姓名查询");
	private ButtonGroup groupone=new ButtonGroup();
	
	
	
	
	private JLabel lbImg=new JLabel("");
	public QueryUser()
	{
		this.init();
	 	this.setVisible(true);	
	}
	public void init()
	{
		dtm.addColumn("车牌编号");
		dtm.addColumn("车主姓名");
		dtm.addColumn("车主性别");
		dtm.addColumn("身份证号");
		dtm.addColumn("联系方式");
		dtm.addColumn("车主地址");
		dtm.addColumn("购车时间");
		
		
		JPanel ptop=new JPanel();
		groupone.add(btnID);
		groupone.add(btnName);
		btnID.setSelected(true);
	
		
		
		
		
	    ptop.add(btnID);
		ptop.add(btnName);
		ptop.add(btnQuery);
		btnQuery.addActionListener(this);
		
		JPanel pMid=new JPanel();
		pMid.add(jscrollpane);
		
		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()==btnQuery)
		{
			dealQuery();
		}
		
	}
	public String QqueryString(ButtonGroup g)
	{
		if(g.getSelection()==btnID.getModel())
		{
			return "select * from UserInfo order by CarID";
		}
		else 
		{
			return "select * from UserInfo order by userName";
		}
		
	}
	
	public void setColor()
	{

		TableColumn carIDColumn=table.getColumn("车牌编号");
		DefaultTableCellRenderer carIDColumnRenderer=new DefaultTableCellRenderer();
		carIDColumnRenderer.setBackground(Color.yellow);
		carIDColumnRenderer.setToolTipText("该列为车牌编号");
		carIDColumn.setCellRenderer(carIDColumnRenderer);
		
		
		TableColumn OwnerNameColumn=table.getColumn("车主姓名");
		DefaultTableCellRenderer OwnerNameColumnRenderer=new DefaultTableCellRenderer();
		OwnerNameColumnRenderer.setBackground(Color.green);
		OwnerNameColumnRenderer.setToolTipText("该列显示车主姓名");
		OwnerNameColumn.setCellRenderer(OwnerNameColumnRenderer);
		
		
		TableColumn SexColumn=table.getColumn("车主性别");
		DefaultTableCellRenderer  SexColumnRenderer=new DefaultTableCellRenderer();
		SexColumnRenderer.setBackground(new Color(112,101,12));
		SexColumnRenderer.setToolTipText("该列显示车主性别");
		SexColumn.setCellRenderer(SexColumnRenderer);
		
	
		TableColumn OwnerIDColumn=table.getColumn("身份证号");
		DefaultTableCellRenderer  OwnerIDColumnRenderer=new DefaultTableCellRenderer();
		OwnerIDColumnRenderer.setBackground(Color.blue);
		OwnerIDColumnRenderer.setToolTipText("该列显示车主身份证号");
		OwnerIDColumn.setCellRenderer(OwnerIDColumnRenderer);
		
		
		TableColumn TelColumn=table.getColumn("联系方式");
		DefaultTableCellRenderer  TelColumnRenderer=new DefaultTableCellRenderer();
		TelColumnRenderer.setBackground(Color.YELLOW);
		TelColumnRenderer.setToolTipText("该列显示电话号码");
		TelColumn.setCellRenderer(TelColumnRenderer);
		
		
		TableColumn AddrColumn=table.getColumn("车主住址");
		DefaultTableCellRenderer  AddrColumnRenderer=new DefaultTableCellRenderer();
		AddrColumnRenderer.setBackground(Color.YELLOW);
		AddrColumnRenderer.setToolTipText("该列显示车主住址");
		AddrColumn.setCellRenderer(AddrColumnRenderer);
		
		
		/*TableColumn TimeColumn=table.getColumn("购车时间");
		DefaultTableCellRenderer  TimeColumnRenderer=new DefaultTableCellRenderer();
		TimeColumnRenderer.setBackground(Color.green);
		TimeColumnRenderer.setToolTipText("该列显示购车时间");
		TimeColumn.setCellRenderer(TimeColumnRenderer);*/
		
		
		
		
	}
	public void dealQuery()
	{
		
		setColor();
		
		
		
		try
		{
			String sql=QqueryString(groupone);
			ConToDB DB=new ConToDB();
			DB.LinkDB();
			PreparedStatement st=DB.con.prepareStatement(sql);
			
			ResultSet rs=st.executeQuery();
			while(rs.next())
			{
				String  CarID=rs.getString(1);
				String Name=rs.getString(2);
				String sex=rs.getString(3);
				String UserID=rs.getString(4);
				String Tel=rs.getString(5);
				String Addr=rs.getString(6);
				String Time=rs.getString(7);
				String [] str={CarID,Name,sex,UserID,Tel,Addr,Time};
				dtm.addRow(str);
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	
	}
	public static void main(String[] args) {
		// TODO Auto-generated method stub

	}

}