cc.java

java练习程序

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

//命令行运行：appletviewer c1.htm
public class cc
{
	public static void main(String args[])
	{
		myWindow win1=new myWindow();

	}

}

class myWindow extends Frame implements ActionListener
{
	TextArea text;
	Panel myPanel;
	TextField xingming;
	Button Btn1,Btn2;
	String dbUrl = "jdbc:odbc:redsun";
//  	String dbUrl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=student.mdb";
  	String User="a";
  	String Password="b";
        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
  		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){}
	  	}
  	}
  	//方式1:按姓名查询
  	public void Liststudent1()throws SQLException
  	{
	  	String name;
  		int myMath,english,physics,sum;
  		//建立Jdbc
  		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		} catch(java.lang.ClassNotFoundException e)
		{
			text.setText(e.getMessage());
		}
		
  		Connection mycon;
  		Statement sql;
  		ResultSet rs;
  		//建立连接,进行查询
  		mycon=DriverManager.getConnection(dbUrl,User,Password);
  		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("没有该人的成绩!");
  		}
	}
	//方式2:全部查询
	public void Liststudent2()throws SQLException
	{
	  	String name;
 	 	int myMath,english,physics,sum;
	  	try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//			Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");
		} catch(java.lang.ClassNotFoundException e) {
	  	}
	  	Connection mycon;
	  	Statement sql;
	  	ResultSet rs;
	  	mycon=DriverManager.getConnection(dbUrl,User,Password);
	  	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");
		}
		if((text.getText().trim()).equals("查询结果"))
  		{
  			text.setText("没有该人的成绩!");
  		}
	}
}