xsjm.java

Java的一个程序

import java.sql.*;
import java.awt.*;
import java.awt.event.*;
class Mm extends Frame implements ActionListener
{
	Button b3,b4;
	TextArea mm;
	Color c;
	Mm(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(Color.green);
		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 number1=rs.getString(1);
		String number2=rs.getString(2);
		String number3=rs.getString(3);
		String number4=rs.getString(4);
		String number5=rs.getString(5);
		String number6=rs.getString(6);
		String number7=rs.getString(7);
		
		mm.append("彩票组号:"+number1+"  "+"购票1:"+number2+" "+"购票2:"+number3+" "+"购票3"+number4+" "+"购票4:"+number5+" "+"购票5:"+number6+" "+"购票6:"+number7+"购票7:"+number7+"\n");
		}
		con.close();
		}
	  catch(SQLException ee)
	  {System.out.println(ee);}
	  }
	}
}
public class Xsjm
{
	public static void main(String args[])
	{     
		Mm h=new Mm("购票信息浏览");
	}
}