reachinf.java

我们学完java后的一个综合作业

import java.awt.*;
import java.awt.event.*;

import javax.swing.*;
//import javax.swing.border.*;

import java.sql.*;
public class reachinf implements ActionListener,ItemListener{
	JDialog dialog;
	JTextField tF1=new JTextField();
	ButtonGroup bg;
	JRadioButton r1,r2;
	int op=0;
	public reachinf(JFrame f)
	{
		 dialog=new JDialog(f,"查询联糸人",true);
			Container dialogPane=dialog.getContentPane();
			dialogPane.setLayout(new GridLayout(3,2));
		r1=new JRadioButton("姓名");
		r2=new JRadioButton("电话");
		dialogPane.add(r1);
		dialogPane.add(r2);
		bg=new ButtonGroup();
		bg.add(r1);
		bg.add(r2);
		//r1.addItemListener(this);
		//r2.addItemListener(this);
		r1.addItemListener(this);
		r2.addItemListener(this);
		dialogPane.add(new JLabel("请输入要查询的联糸人的信息:",SwingConstants.CENTER));
		dialogPane.add(tF1);
		JButton button1=new JButton("查询");
		JButton button2=new JButton("取消");
		dialogPane.add(button1);
		dialogPane.add(button2);
		button1.addActionListener(this);
		button2.addActionListener(this);
		dialog.getRootPane().setDefaultButton(button1);
		dialog.pack();
		dialog.setVisible(true);
		f.addWindowListener(new WindowAdapter()
		  {public void windowClosing(WindowEvent e){System.exit(0);}});
		
	}
	public void itemStateChanged(ItemEvent e)
	{
		if(e.getSource()==r1) op=1;
		if(e.getSource()==r2) op=2;
	}
	public void actionPerformed(ActionEvent e)
	{
		String cmd=e.getActionCommand();
		if(cmd.equals("查询")){
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=
				DriverManager.getConnection("jdbc:odbc:notebook","zxp","121");
			//Statement s=con.createStatement(); 
			String n=tF1.getText();
			PreparedStatement ps=null;
			ResultSet resultSet=null;
			switch(op)
			{
			case 1:
			ps=con.prepareStatement("select * FROM phone where name=?");
			ps.setString(1, n);
			resultSet=ps.executeQuery();
			if(resultSet.next()==false)
			{
				JOptionPane.showMessageDialog(dialog,"您查询的联糸人不存在!");
			}else
			{
			StringBuffer results=new StringBuffer(); 
			ResultSetMetaData metaData=resultSet.getMetaData(); 
			int m=metaData.getColumnCount(); 
			for(int i=1;i<=m;i++) 
				results.append(metaData.getColumnName(i)+"                           "); 
				results.append("\n"); 
				for(int j=1;j<=m;j++) 
					results.append(resultSet.getObject(j)+"             "); 
					results.append("\n");
					dialog.dispose();
					JOptionPane.showMessageDialog(null,results.toString(),"联糸人信息", 
							JOptionPane.INFORMATION_MESSAGE);
			} break;
			case 2:
				ps=con.prepareStatement("select * FROM phone where phone=?");
				ps.setString(1, n);
				resultSet=ps.executeQuery();
				if(resultSet.next()==false)
				{
					JOptionPane.showMessageDialog(dialog,"您查询的联糸人不存在!");
				}else
				{
				StringBuffer results=new StringBuffer(); 
				ResultSetMetaData metaData=resultSet.getMetaData(); 
				int m=metaData.getColumnCount(); 
				for(int i=1;i<=m;i++) 
					results.append(metaData.getColumnName(i)+"                           "); 
					results.append("\n"); 
					for(int j=1;j<=m;j++) 
						results.append(resultSet.getObject(j)+"             "); 
						results.append("\n");
						dialog.dispose();
						JOptionPane.showMessageDialog(null,results.toString(),"联糸人信息", 
								JOptionPane.INFORMATION_MESSAGE);
				}break;
			}
		}catch(Exception ex){}
		}
		else if(cmd.equals("取消"))
		{
			dialog.dispose();
		}
	}
}