ch15_1_1.java

java练习程序

import java.applet.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.net.*;

//命令行运行：appletviewer c.htm

class myWindow extends Frame implements ActionListener
{
	TextArea text;
	Panel myPanel;
	TextField xingming;
	Button Btn1,Btn2;
        myWindow()
        {
          	super("成绩查询");
          	setLayout(new BorderLayout());
          	setBackground(Color.cyan);
          	setBounds(150,150,300,120);
          	setVisible(true);
  		text=new TextArea();
  		xingming=new TextField(16);
  		Btn1=new Button("确定");
	  	Btn2=new Button("查询所有人的成绩");
  		myPanel=new Panel();
		myPanel.add(new Label(" 输入被查询学生的姓名"));
		myPanel.add(xingming);
		myPanel.add(Btn1);
		add("North",myPanel);
		add(text,"Center");
		add(Btn2,"South");
		text.setEditable(false);
		text.setBackground(Color.pink);
		Btn1.addActionListener(this);
		Btn2.addActionListener(this);
		addWindowListener(new WindowAdapter()
  	  	{
  	  		public void windowClosing(WindowEvent e)
  	  		{
  	  			setVisible(false);
  	  			System.exit(0);
  	  		}
	  	});
        	pack();//紧凑方式显示窗口
        }
        
        public void actionPerformed(ActionEvent e)
        {
//        	text.setText("btn "+"\n");
	  	if(e.getSource()==Btn1)
  		{
  			text.setText("查询结果"+"\n");
  			try{Liststudent1();}
  			catch(SQLException ee){}
  		}
  		else if(e.getSource()==Btn2)
  		{
	  		text.setText("查询结果"+"\n");
  			try{Liststudent2();}
  			catch(SQLException ee){}
	  	}
  	}
  	public void Liststudent1()throws SQLException
  	{
//  		text.setText("没有该人的成绩!");
	  	String name;
  		int myMath,english,physics,sum;
  		String dbUrl = "jdbc:odbc:redsun";
  		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		} catch(java.lang.ClassNotFoundException e)
		{
			text.setText(e.getMessage());
//  			text1.setText("wrong 1");
			return;
		}
  		Connection mycon;
  		Statement sql;
  		ResultSet rs;
//	 	mycon=DriverManager.getConnection("jdbc:odbc:redsun","wuliu","99");
  		mycon=DriverManager.getConnection(dbUrl);
  		sql=mycon.createStatement();
  		rs=sql.executeQuery("SELECT * FROM chengjibiao");
		while(rs.next())
		{
			name=rs.getString(2);
  			myMath=rs.getInt("数学");
  			physics=rs.getInt("物理");
  			english=rs.getInt("英语");
  			sum=myMath+english+physics;
  			if((name.trim()).equals(xingming.getText().trim()))
  			{
	  			text.append("***"+"\n"+name+"的成绩"+"\n"+"数学:"+myMath
  				+"英语:"+english+"物理:"+physics+"总分:"+sum+"\n");
  			}
  		}
  		if((text.getText().trim()).equals("查询结果"))
  		{
  			text.setText("没有该人的成绩!");
  		}
	}
	public void Liststudent2()throws SQLException
	{
//		text.setText("没有该人的成绩222!");
  	
  	String name;
  	int myMath,english,physics,sum;
  	String dbUrl = "jdbc:odbc:redsun";
  	try {
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	} catch(java.lang.ClassNotFoundException e) {
//		text1.setText(e.getMessage());
//  		text1.setText("wrong 1");
  	}
  	Connection mycon;
  	Statement sql;
  	ResultSet rs;
// 	mycon=DriverManager.getConnection("jdbc:odbc:redsun","wuliu","99");
  	mycon=DriverManager.getConnection(dbUrl);
  	sql=mycon.createStatement();
  	rs=sql.executeQuery("SELECT * FROM chengjibiao");
	while(rs.next())
	{
		name=rs.getString(2);
  		myMath=rs.getInt("数学");
  		physics=rs.getInt("物理");
  		english=rs.getInt("英语");
  		sum=myMath+english+physics;
		text.append("***"+"\n"+name+"的成绩"+"\n"+"数学:"+myMath
		+"英语:"+english+"物理:"+physics+"总分:"+sum+"\n");
	}
	
  }
}
public class ch15_1_1 extends Applet
{
	myWindow win1;
	public void init()
	{
		win1=new myWindow();
        }
}