marksdb.java

java练习程序

import java.sql.*;
import java.awt.*;
import java.awt.event.*;
class MarksDBWindow extends Thread
{
	Frame f=new Frame("Database");
	TextArea text=new TextArea();
	String name, xuehao;
	Date date;
	int math, physics, english;
	Connection con;
	Statement sql;
	ResultSet rs;
	MarksDBWindow()
	{
		f.setBounds(150, 150, 300, 120);
		f.setVisible(true);
		f.add(text,"Center");
		f.pack();
		f.addWindowListener(new WindowAdapter()
		{
			public void windewClosing(WindowEvent e)
			{
				System.exit(0);
			}
		});
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e)
		{}
		try
		{
			con=DriverManager.getConnection("jdbc:odbc:redsun", "a","b");
			sql=con.createStatement();
			
		}
		catch(SQLException e1)
		{}
	}
	public void run()
	{
		while (true)
		{
			text.setText(null);
			try
			{
				rs=sql.executeQuery("SELECT * FROM chengjibiao");
				while(rs.next())
				{
					name=rs.getString(2);
					xuehao=rs.getString(1);
					date=rs.getDate(3);
					math=rs.getInt("数学");
					physics=rs.getInt("物理");
					english=rs.getInt("英语");
					
					text.append("姓名:  "+name+"\n");
					text.append("学号:  "+xuehao+"\n");
					text.append("出生:  "+date.toString()+"\n");
					text.append("数学:  "+math+"\n");
					text.append("物理:  "+physics+"\n");
					text.append("英语:  "+english+"\n");
				}
			}
			catch(SQLException el)
			{}
			f.pack();
			try
			{
				sleep(2000);
			}
			catch(InterruptedException exp)
			{}
		}
	}
}

public class MarksDB
{
	public static void main(String args[])
	{
		MarksDBWindow w=new MarksDBWindow();
		w.start();
	}
}