chaxun.java

java写的xuesheng信息管理系统！欢迎下载使用

import javax.swing.*;

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

public class Chaxun extends JFrame
{
	JPanel p0=new JPanel();	
	JPanel p1=new JPanel();	
	JPanel p2=new JPanel();
	JPanel p3=new JPanel();
	JPanel p4=new JPanel();
	JPanel p5=new JPanel();
	JPanel p6=new JPanel();
	JPanel p7=new JPanel();
	JPanel p8=new JPanel();
	JPanel p9=new JPanel();
	
	JLabel  Lab0=new JLabel("所在系:");
    JLabel  Lab1=new JLabel("所在班:");
    JLabel  Lab2=new JLabel("学号:");
	JLabel  Lab3=new JLabel("姓名:");
	JLabel  Lab4=new JLabel("出生日期:");
	JLabel  Lab5=new JLabel("性别:");
	JLabel  Lab6=new JLabel("电话:");
	JLabel  Lab7=new JLabel("班级:");
	JLabel  Lab8=new JLabel("地址:");
	JLabel  Lab9=new JLabel("简历:");
	JLabel  Lab10=new JLabel("系名:");
	
	Choice cc1=new Choice();
	Choice cc2=new Choice();
	
	JTextField  text2=new JTextField(24);
	JTextField  text3=new JTextField(24);
	JTextField  text4=new JTextField(22);
	JTextField  text5=new JTextField(24);
	JTextField  text6=new JTextField(24);
	JTextField  text7=new JTextField(24);
	JTextField  text8=new JTextField(24);                    
    JTextField  text9=new JTextField(24);
    JTextField  text10=new JTextField(24);
    
    JButton b1=new JButton("列出》");
    JButton b2=new JButton("返回");
	
    
    JLabel jlabel=new JLabel("显示信息");
    
    JTable t1=new JTable(5,6);
    JTextArea adfa=new JTextArea(20,50);
    
    String ximing[]={"请选择","软件","经管","数学","外语"};
    String banji[]={"请选择","软测1班","软测2班","工商1班","金融1班","数学1班","英语1班"};
   
    
    List myList=new List(12);
    
    
    public Chaxun()
	{
	super("查询界面");
	this.setBounds(400,300,470,390);
    
	for(int i=0;i<ximing.length;i++)
	cc1.add(ximing[i]);
	
	for(int i=0;i<banji.length;i++)
		cc2.add(banji[i]);
    
    this.add("North",p1);
    this.add("Center",p6);
    this.add("South",p7);
    
    p6.setLayout(new BorderLayout(1,2));
    p6.add("West",p2);
    p6.add("Center",p5);
    
   
    //p6.add("West",p2);
    //p2.setLayout(new BorderLayout(2,1))
    p2.add(myList);
    //p8.add(jlabel);
    
    p5.setLayout(new GridLayout(2,1,2,2));
	p5.add("North",p3);  
    p5.add("South",p4);    
	
	
	p3.setLayout(new FlowLayout(6,3,2));	
	p3.add(Lab2);
    p3.add(text2);    
    p3.add(Lab3);
    p3.add(text3);  
    p3.add(Lab4);
    p3.add(text4);
    p3.add(Lab5);
    p3.add(text5);  
    p3.add(Lab6);
    p3.add(text6); 
    p3.add(Lab7);
    p3.add(text7);  
    
    p4.setLayout(new FlowLayout(6,2,1));
    p4.add(Lab8);
    p4.add(text8); 
    p4.add(Lab9);
    p4.add(text9);  
    p4.add(Lab10);
    p4.add(text10); 
    
    
 
	p1.add(Lab0);         
    p1.add(cc1);
    p1.add(Lab1);
  	p1.add(cc2);
    p1.add(b1);
    
    add(p9, BorderLayout.SOUTH);
	 p9.add(b2);
	 
	 b2.addActionListener(
	    		
	    		new ActionListener()
	    		{

					
					public void actionPerformed(ActionEvent e)
					{
						Chaxun.this.dispose();				
					}
	    			
	    		}
	    );
	    
    
    cc1.addItemListener(
        	new ItemListener()
        	{

				public void itemStateChanged(ItemEvent e)
				{	
					final String xm= "'" + cc1.getSelectedItem() + "'";
						
					cc2.addItemListener(
					
							new ItemListener()
							{

								public void itemStateChanged(ItemEvent e) 
								{
									final String bj="'"+cc2.getSelectedItem()+"'";
									
									  b1.addActionListener(
										        
								        		new ActionListener()
								        		{

													public void actionPerformed(ActionEvent e) 
													{
														System.out.print(xm);
														System.out.print(bj);
														
														
														final String url="jdbc:odbc:stuinf";
														final String sqlstudent="select * from Student where Sdepartment="+xm+"and SClass="+bj;
														try
														{
															Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");															
														}
														catch(java.lang.ClassNotFoundException e1)
														{
															
														}
														
														try
														{
															
															Connection con=DriverManager.getConnection(url,"","");
															Statement stmt=con.createStatement();
			
															ResultSet rs=stmt.executeQuery(sqlstudent);
															while(rs.next())
															{
																String s1=rs.getString("Sno");
																String s2=rs.getString("Sname");
			
																System.out.print(s1+","+s2);//判断输出结果
																System.out.print("进行下步操作！");
																
																
																	String unit=s1;														 
																	 myList.add(unit);
																	 p2.add(myList);

															}
						 
															stmt.close();
															con.close();
														
														}
														catch(SQLException ex)
														{
															System.out.print(ex.getMessage());
														}
														
														
														
														myList.addItemListener(
																
																new ItemListener()
																{

																	public void itemStateChanged(ItemEvent e) 
																	{
																		List temp=(List)(e.getItemSelectable());
																		final String mm=temp.getSelectedItem();//获得List的单击内容
																		
																		
																		
																		final String url="jdbc:odbc:stuinf";
																		String sql="select * from Student";
																		try
																		{
																			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
																		}
																		catch(java.lang.ClassNotFoundException e1)
																		{	
																		}
																		try
																		{
																			Connection con=DriverManager.getConnection(url,"","");
																			Statement stmt=con.createStatement();

																				ResultSet rs=stmt.executeQuery(sql);
																				while(rs.next())
																				{
																				String s1=rs.getString("Sno");
																				String s2=rs.getString("Sname");
																				String s3=rs.getString("Sbirthday");
																				String s4=rs.getString("Ssex");
																				String s5=rs.getString("Stel");
																				String s6=rs.getString("Sclass");
																				String s7=rs.getString("Saddress");
																				String s8=rs.getString("Sresume");
																				String s9=rs.getString("Sdepartment");
																				
			
																				
																				if(mm.equals(s1))
																				{
																					
																					text2.setText(s1);
																					text3.setText(s2);
																					text4.setText(s3);
																				    text5.setText(s4);
																					text6.setText(s5);
																					text7.setText(s6);
																					text8.setText(s7);
																					text9.setText(s8);
																					text10.setText(s9);
									
																					break;
																				}
																				
																				}
																			stmt.close();
																			con.close();
																		
																		}
																		catch(SQLException ex)
																		{
																			System.out.print(ex.getMessage());
																		}
																	
																		
																		
																		
																		
																		
																							
																		
																		
																		
																	}
																	
																}
														);
														
														 
														
														
													}
								        			
								        		}
								        );
										
									
								}
								
							}
					);
					 
			      
				}
        		
        	}
        )  ;

	}
	
	}