ijg.java

Java的一个程序

import java.sql.*;
import java.awt.*;
import java.awt.event.*;
class QQ extends Frame implements ActionListener
{
	Button b3,b4;
	TextArea mm;
	Color c;
	QQ(String s)
	{
		super(s);
		setLayout(new FlowLayout());
		mm=new TextArea();
		b3=new Button("查询");
		b4=new Button("退出");
		c=new Color(200,200,250);
		b3.addActionListener(this);
		b4.addActionListener(this);
		add(b3);add(b4);
		add(mm);
		addWindowListener(new WindowAdapter()
		{
			public void windowClosing(WindowEvent e)
			{
				setVisible(false);
			}
		});
		mm.setBounds(50,50,400,280);
		setBounds(150,150,500,280);
		setBackground(c);
		setVisible(true);
		validate();
     }
	public void actionPerformed(ActionEvent e)
	{ Connection con;
	  Statement sm;
	  ResultSet rs;
      if(e.getSource()==b4)
	  { 
		setVisible(false);
	  }
	  if(e.getSource()==b3)
	  {try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	  } 
	  catch(ClassNotFoundException x)
	  {System.out.println(""+x);
	  }
	  try{con=DriverManager.getConnection("jdbc:odbc:sun"," "," ");
		sm=con.createStatement();
		rs=sm.executeQuery("SELECT * FROM 彩民信息表");
		while(rs.next())
		{String number=rs.getString(1);
		String name=rs.getString(2);
		String sex=rs.getString(3);
		String year=rs.getString(4);
		String addres=rs.getString(5);
		String work=rs.getString(6);
		String phone=rs.getString(7);
		String data=rs.getString(8);
		mm.append("编号:"+number+"  "+"姓名:"+name+" "+"性别:"+sex+" "+"年龄"+year+" "+"住址:"+addres+" "+"单位:"+work+" "+"联系电话:"+phone+"购票日期:"+data+"\n");	}
		con.close();
		}
	  catch(SQLException ee)
	  {System.out.println(ee);}
	  }	}
}
public class Ijg
{
	public static void main(String args[])
	{  QQ q=new QQ("彩民信息浏览");}
}