find.java

班级管理查询系统

package huazheng;
import java.awt.Color;
import java.awt.Label;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JTextField;
public class Find {
   public void find(){
	 JFrame frame=new JFrame("查找");
	 JButton j1,j2,j3,j4,j5;
	final JTextField f1,f2,f3,f4;
	final Label l1,l2,l3,l4,l5;
	 
	 j1=new JButton("全部");
	 j2=new JButton("确定");
	 j3=new JButton("确定");
	 j4=new JButton("确定");
	 j5=new JButton("确定");
	 
	 f1=new JTextField("输入姓名");
	 f2=new JTextField("输入性别");
	 f3=new JTextField("学号后两位");
	 f4=new JTextField("输入学号");
	 
	 l1=new Label("全部");
	 l2=new Label("姓名");
	 l3=new Label("性别");
	 l4=new Label("学号");
	 l5=new Label("学号");
	 
	 frame.setLayout(null);
	 frame.setLocation(200,100);
	 frame.setSize(350,300);
	 frame.setAlwaysOnTop(true);
	// frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	 
	 frame.add(j1);
	 frame.add(j2);
	 frame.add(j3);
	 frame.add(j4);
	 frame.add(j5);
	 frame.add(f1);
	 frame.add(f2);
	 frame.add(f3);
	 frame.add(f4);
	 
	 frame.add(l1);
	 frame.add(l2);
	 frame.add(l3);
	 frame.add(l4);
	 frame.add(l5);
	 
	 j1.setBounds(250,20,60,30);
	 l1.setBounds(10,20,60,30);
	 
	 j2.setBounds(250,70,60,30);
	 f1.setBounds(100,70,90,30);
	 l2.setBounds(10,70,60,30);
	 
	 j3.setBounds(250,120,60,30);
	 f2.setBounds(100,120,90,30);
	 l3.setBounds(10,120,60,30);
	 
	 j5.setBounds(250,170,60,30);
	 f4.setBounds(100,170,90,30);
	 l4.setBounds(10,170,60,30);
	 
	 j4.setBounds(250,220,60,30);
	 f3.setBounds(100,220,90,30);
	 l5.setBounds(10,220,60,30);
	 
	 l1.setBackground(Color.red);
	 l2.setBackground(Color.BLUE);
	 l3.setBackground(Color.CYAN);
	 l4.setBackground(Color.GREEN);
	 l5.setBackground(Color.orange);
	 
	 frame.setResizable(false);
	 
	 j1.addActionListener(new ActionListener(){
		 public void actionPerformed(ActionEvent e){
			 String name = null, studynumber = null;
				String sex = null, address= null, major = null;
			 Connection con;
			 Statement sql;
			 ResultSet res;
			 try{
				 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			 }catch(ClassNotFoundException ee){
				 ee.toString();
			 }
			 
			 try{
				 con=DriverManager.getConnection("jdbc:odbc:hua","huazheng","huazheng");
				 sql=con.createStatement();
				 res=sql.executeQuery("SELECT * FROM huazheng3");
				 while(res.next()){
					 studynumber=res.getString(1);
					 name=res.getString(2);
					 sex=res.getString(3);
					 address=res.getString(4);
					 major=res.getString(5);
					 Run.area.append(studynumber+"   "+name+"   "+sex+"   "+address+"   "+major+"   "+"\n");
				 }
			 }catch(SQLException ee){
				 
			 }
		 }
	 });
	 
	 
	 j2.addActionListener(new ActionListener(){
		 public void actionPerformed(ActionEvent e){
			 String name = null, studynumber = null;
				String sex = null, address= null, major = null;
			 Connection con;
			 Statement sql;
			 ResultSet res;
			 try{
				 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			 }catch(ClassNotFoundException ee){
				 ee.toString();
			 }
			 
			 try{
				 con=DriverManager.getConnection("jdbc:odbc:hua","huazheng","huazheng");
				 sql=con.createStatement();
				 res=sql.executeQuery("SELECT * FROM huazheng3");
				 while(res.next()){
					 studynumber=res.getString(1);
					 name=res.getString(2);
					 sex=res.getString(3);
					 address=res.getString(4);
					 major=res.getString(5);
					 if(f1.getText().trim().equals(name))
					 Run.area.setText(studynumber+"   "+name+"   "+sex+"   "+address+"   "+major+"   "+"\n");
				 }
			 }catch(SQLException ee){
				 
			 }
		 }
	 });
	 
	 j3.addActionListener(new ActionListener(){
		 public void actionPerformed(ActionEvent e){
			 String name = null, studynumber = null;
				String sex = null, address= null, major = null;
			 Connection con;
			 Statement sql;
			 ResultSet res;
			 try{
				 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			 }catch(ClassNotFoundException ee){
				 ee.toString();
			 }
			 
			 try{
				 con=DriverManager.getConnection("jdbc:odbc:hua","huazheng","huazheng");
				 sql=con.createStatement();
				 res=sql.executeQuery("SELECT * FROM huazheng3");
				 while(res.next()){
					 studynumber=res.getString(1);
					 name=res.getString(2);
					 sex=res.getString(3);
					 address=res.getString(4);
					 major=res.getString(5);
					 if(f2.getText().trim().equals(sex))
					 Run.area.append(studynumber+"   "+name+"   "+sex+"   "+address+"   "+major+"   "+"\n");
				 }
			 }catch(SQLException ee){
				 
			 }
		 }
	 });
	 
	 j5.addActionListener(new ActionListener(){
		 public void actionPerformed(ActionEvent e){
			 String name = null, studynumber = null;
				String sex = null, address= null, major = null;
			 Connection con;
			 Statement sql;
			 ResultSet res;
			 try{
				 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			 }catch(ClassNotFoundException ee){
				 ee.toString();
			 }
			 
			 try{
				 con=DriverManager.getConnection("jdbc:odbc:hua","huazheng","huazheng");
				 sql=con.createStatement();
				 res=sql.executeQuery("SELECT * FROM huazheng3");
				 while(res.next()){
					 studynumber=res.getString(1);
					 name=res.getString(2);
					 sex=res.getString(3);
					 address=res.getString(4);
					 major=res.getString(5);
					 if(f4.getText().trim().equals(studynumber))
					 Run.area.setText(studynumber+"   "+name+"   "+sex+"   "+address+"   "+major+"   "+"\n");
				 }
			 }catch(SQLException ee){
				 
			 }
		 }
	 });
	 
	 j4.addActionListener(new ActionListener(){
		 public void actionPerformed(ActionEvent e){
			 String name = null, studynumber= null;
				String sex = null, address= null, major = null;
				String s=f3.getText().trim();
			 Connection con;
			 Statement sql;
			 ResultSet res;
			 try{
				 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			 }catch(ClassNotFoundException ee){
				 ee.toString();
			 }
			 
			 try{System.out.println(s);
				 con=DriverManager.getConnection("jdbc:odbc:hua","huazheng","huazheng");
				 sql=con.createStatement();
				 res=sql.executeQuery("SELECT * FROM huazheng3");
				 while(res.next()){
					 studynumber=res.getString(1);
					 name=res.getString(2);
					 sex=res.getString(3);
					 address=res.getString(4);
					 major=res.getString(5);
					 if(f3.getText().trim().equals(studynumber.substring(6,8)))
					 Run.area.setText(studynumber+"   "+name+"   "+sex+"   "+address+"   "+major+"   "+"\n");
				 }
			 }catch(SQLException ee){
				 
			 }
		 }
	 });
	 frame.setVisible(true);
   }
	
	public static void main(String[] args) {
		new Find().find();

	}

}