f0f915fffb2f001d17a39fa8a118b5a5

来自「这个一个用j2se实现的汽车销售管理系统」· 代码 · 共 132 行

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.*;
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);
		btnID.setBounds(100, 100, 40, 22);
		btnName.setBounds(220, 100, 40, 22);
		//btnQuery.setBounds(320, 100, 80, 22);
		
		lbImg.add(btnID);
		//lbImg.add(btnName);
		//lbImg.add(btnQuery);
		
		
	//	ptop.add(btnID);
		//ptop.add(btnName);
	//	btnQuery.setBounds(300, 30, 80, 22);
		ptop.add(lbImg, SwingConstants.CENTER);
		btnQuery.setBackground(Color.green);
		
		//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 dealQuery()
	{
		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

	}

}