10488cc77f31001d1f76c87180e3a9e2

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

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import javax.swing.table.*;
import java.sql.*;
public class RepInfoQuery extends JPanel implements ActionListener{
	
	private JLabel lbName=new JLabel("车主姓名");
	private DefaultTableModel dtm=new DefaultTableModel();
	private JTable table=new JTable(dtm);
	private JScrollPane jscrollpane1=new JScrollPane(table);
	private JLabel lbTitle=new JLabel("维修信息查询");
	private JTextField tfName=new JTextField(10);
	private JButton btnM=new JButton("模糊查询");
	private JButton btnJ=new JButton("精确查询");

	public RepInfoQuery()
	{
		
		this.init();
		this.setVisible(true);
	}
	public void init()
	{
		JPanel ptop=new JPanel();
		Font font=new Font("楷体GB2312",Font.BOLD,25);
		lbTitle.setFont(font);
		ptop.add(lbTitle);
		ptop.setBackground(Color.green);
		
		
		JPanel p=new JPanel();
		p.add(lbName);
		lbName.setForeground(Color.red);
		p.add(tfName);
		p.add(btnM);
		p.add(btnJ);
		btnM.addActionListener(this);
		btnJ.addActionListener(this);
		p.setBackground(new Color(44,45,2));
		
		JPanel pup=new JPanel();
		pup.setLayout(new BorderLayout());
		pup.add(ptop,"North");
		pup.add(p,"South");
		
		dtm.addColumn("维修车辆编号");
		dtm.addColumn("车主姓名");
		dtm.addColumn("维修故障原因");
		dtm.addColumn("修理工姓名");
		dtm.addColumn("维修总费用");
		JPanel pMid=new JPanel();
		pMid.setLayout(new BorderLayout());
		pMid.add(jscrollpane1);
		pMid.setBackground(Color.yellow);
		
		
		JPanel pAll=new JPanel();
		pAll.setLayout(new BorderLayout());
		pAll.add(pup,"North");
		pAll.add(pMid,"Center");
		pAll.setBackground(Color.yellow);
		
		this.add(pAll);
		
		
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==btnM)
		{
			dealBtnM();
		}
		else if(e.getSource()==btnJ)
		{
			
		}
	}
	
	public void dealBtnM()
	{
		boolean flag=false;
		try
		{
			String Name=tfName.getText().trim();
			String sql="select * from CarInfo  where userName like '?'";
			ConToDB DB=new ConToDB();
			DB.LinkDB();
			PreparedStatement st=DB.con.prepareStatement(sql);
			
			st.setString(1, Name);
			ResultSet rs=st.executeQuery();
			while(rs.next())
			{
				String Num=rs.getString(1);
				/*String Name1=rs.getString(2);
				String p=rs.getString(9);
				String Re=rs.getString(10);
				String M=rs.getString(13);
				String [] str={Num,Name1,p,Re,M};
				dtm.addColumn(str);
				flag=true;*/
				System.out.println(Num+":");
			}
			if(!flag)
			{
				JOptionPane.showMessageDialog(this, "该车主维修记录为０！");
			}
			
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public void dealBtnJ()
	{
		try
		{
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public static void main(String [] args)
	{
		new RepInfoQuery();
	}

}