searchclassframe.java

一个基于java的学生信息管理系统程序： 包括基本要求：学生信息（包括

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.sql.*;


/*2.编写学生信息管理系统程序：
（1）基本要求：学生信息（包括，学号、姓名、性别、年龄、家庭住址、电话）的
添加，删除，修改，查询（包括按学号，按姓名，按电话查询）。要求第二次上机时必须完成。
（2）提高要求：可填加班级信息（也可删除、修改班级），学生信息中包含班级信息，
        可按班级统计学生。简单统计，按性别统计等。
说明：此程序要求图形界面实现，如果不采用图形界面则扣减实验分数。
*/
class searchClassFrame
{
	String url = "jdbc:odbc:system";
    Connection con;
    String sql;
    Statement stmt;
    PreparedStatement stmt0;
	
	Frame searchframe;
	Label la1,la2;
	TextField tf;
	TextArea ta;
	Button id,name,department,all,back;
	
	Panel p1,p2,p3,p4,p5,p6;
	
	Dialog dialog;
	Button btn;
	Label lad;
	Panel pd1,pd2;
	searchClassFrame()
	{
		searchframe=new Frame("查找班级信息");
		p1=new Panel();
		p2=new Panel();
		p3=new Panel();
		p4=new Panel();
		p5=new Panel();
		p6=new Panel();
		la1=new Label("请输入查找关键字",Label.CENTER);
		la2=new Label("显示查询结果如下:",Label.LEFT);
		id=new Button("按班级号查询");
		name=new Button("按班级名称查询");
		department=new Button("按系别查询");
		all=new Button("全部显示");
		back=new Button("退出");
		tf=new TextField();
		ta=new TextArea(50,50);
		
		p1.add(la1);
		p1.add(tf);
		p1.setLayout(new GridLayout(1,2));
		p2.add(id);
		p2.add(name);
		p2.add(department);
		
		p3.add(all);
		p3.add(back);
		
		p5.add(p1);
		p5.add(p2);
		p5.add(p3);
		p5.setLayout(new GridLayout(3,1));
		p4.add(la2,BorderLayout.NORTH);
		p4.add(ta,BorderLayout.CENTER);
		
	
		searchframe.add(p5,BorderLayout.NORTH);
		searchframe.add(p4,BorderLayout.CENTER);
		//searchframe.setLayout(new GridLayout(2,1));
		searchframe.setSize(400,450);
		searchframe.setVisible(true);
		 
     //********************************对话框的定义
	    dialog=new Dialog(searchframe,"提示",true);
	    btn=new Button("确定");
		lad=new Label("显示结果如文本区!");
		pd1=new Panel();
		pd2=new Panel();
		pd1.add(lad);
		pd2.add(btn);
		dialog.add(pd1,BorderLayout.CENTER);
		dialog.add(pd2,BorderLayout.SOUTH);
		dialog.setSize(120,100);
		M m=new M();
		btn.addActionListener(m);
	    dialog.addWindowListener(m);
	    
		try {
         
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	    
            con = DriverManager.getConnection(url, "system", "system");
            stmt=con.createStatement();
              }  catch(ClassNotFoundException e) 
                 {
                System.err.print("ClassNotFoundException: ");
                System.err.println(e.getMessage());
                  }   
                  catch(SQLException e){
                  }   	
		Mon mon=new Mon();
		id.addActionListener(mon);
		name.addActionListener(mon);
		department.addActionListener(mon);
		all.addActionListener(mon);
		back.addActionListener(mon);
		searchframe.addWindowListener(mon);
		
	}
	class Mon extends WindowAdapter implements ActionListener
	{
		public void actionPerformed(ActionEvent e)
		{
			if(e.getSource()==id)
			{
				try{
                
                 sql="select * from CLASS where ID=?"; 
                 stmt0=con.prepareStatement(sql);
                 stmt0.setString(1,tf.getText());
                 ResultSet rs=stmt0.executeQuery();
                 
                 String id,name,department;
                 ta.append("********************************\n");
                 ta.append("班级号  班级名称     系别 \n");
                 while(rs.next())
                 {
                 
		          	  id=rs.getString("ID");
		          	  name=rs.getString("NAME");
		          	  department=rs.getString("DEPARTMENT");
		          	  
		              
		              ta.append(id+"  ");
		              ta.append(name+"  ");
		              ta.append(department+"  ");
		              ta.append("\n");
                 	
                 	
                 }
                  ta.append("\n********************************\n");
                  dialog.show();
                 }
                 catch(SQLException e1)
                 {
                 	e1.printStackTrace();
                 }
			}
			if(e.getSource()==name)
			{
				try{
                
                 sql="select * from CLASS where NAME=?"; 
                 stmt0=con.prepareStatement(sql);
                 stmt0.setString(1,tf.getText());
                 ResultSet rs=stmt0.executeQuery();
                 
                 String id,name,department;
                 ta.append("********************************\n");
                 ta.append("班级号  班级名称     系别 \n");
                 while(rs.next())
                 {
                 
		          	  id=rs.getString("ID");
		          	  name=rs.getString("NAME");
		          	  department=rs.getString("DEPARTMENT");
		          	  
		              
		              ta.append(id+"  ");
		              ta.append(name+"  ");
		              ta.append(department+"  ");
		              ta.append("\n");
                 	
                 	
                 }
                  ta.append("\n********************************\n");
                  dialog.show();
                 }
                 catch(SQLException e1)
                 {
                 	e1.printStackTrace();
                 }
			}
			if(e.getSource()==department)
			{
				try{
                
                 sql="select * from CLASS where DEPARTMENT=?"; 
                 stmt0=con.prepareStatement(sql);
                 stmt0.setString(1,tf.getText());
                 ResultSet rs=stmt0.executeQuery();
                 
                 ta.append("********************************\n");
                 String id,name,department;
                 ta.append("********************************\n");
                 ta.append("班级号  班级名称     系别 \n");
                 while(rs.next())
                 {
                 
		          	  id=rs.getString("ID");
		          	  name=rs.getString("NAME");
		          	  department=rs.getString("DEPARTMENT");
		          	  
		              
		              ta.append(id+"  ");
		              ta.append(name+"  ");
		              ta.append(department+"  ");
		              ta.append("\n");
                 	
                 	
                 }
                  ta.append("\n********************************\n");
                  dialog.show();
                 }
                 catch(SQLException e1)
                 {
                 	e1.printStackTrace();
                 }
			}
			if(e.getSource()==all)
			{
				try{
                
                 sql="select * from CLASS "; 
                 ResultSet rs=stmt.executeQuery(sql);
                 
                  String id,name,department;
                 ta.append("********************************\n");
                 ta.append("班级号  班级名称     系别 \n");
                 while(rs.next())
                 {
                 
		          	  id=rs.getString("ID");
		          	  name=rs.getString("NAME");
		          	  department=rs.getString("DEPARTMENT");
		          	  
		              
		              ta.append(id+"  ");
		              ta.append(name+"  ");
		              ta.append(department+"  ");
		              ta.append("\n");
                 	
                 	
                 }
                  ta.append("\n********************************\n");
                  dialog.show();
                 }
                 catch(SQLException e1)
                 {
                 	e1.printStackTrace();
                 }
			}
			if(e.getSource()==back)
			{
				searchframe.dispose();
			}
		
		}

		public void windowClosing(WindowEvent e)
		{
			//System.exit(0);
			searchframe.dispose();
		}
	}

    class M extends WindowAdapter implements ActionListener
	{
	    public void actionPerformed(ActionEvent e)
	    {
	        dialog.dispose();
	    }
	    public void windowClosing(WindowEvent e)
	    {
	        dialog.dispose();
	    }
	       
	}
	public static void main(String argv[])
	{
		new searchClassFrame();
	}
	
	
}