xinxifind.java

是一个用数据库结合JAVA语言的开发

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.io.*;
import java.sql.*;
public class xinxifind extends JFrame implements ActionListener

{
	public static void main(String[] args)
	{
		xinxifind frame=new xinxifind();
	}

	JTextArea ta1;

	JComboBox jobsBox;
	JLabel lb;
	JLabel lb1;
	JTextField tf1;
	JLabel lb2;
	JComboBox jobsBox1;
	JComboBox jobsBox2;
	JTextField tf2;
	JComboBox jobsBox3;
	JComboBox jobsBox4;
	JTextField tf3;
	Connection con1;
	ResultSet rs1;
	Statement st1;
	String str1="";
	String str2="";
	String pp="2号楼住宿花名册";
	String pp1="体社系";
	String pp2="社会体育";
	String pp3="体社系";
	String pp4="社会体育";
	JButton bu11,bu12,bu13,bu14,bu15,bu16,bu17;
	public xinxifind()
	{
//《=================面版设置=============================================================		
		super("全校学生住宿信息查询");
		Container c=getContentPane();
	    c.setLayout(null);
		
	
		JPanel textPanel=new JPanel();
		JPanel p=new JPanel();
        JPanel p1=new JPanel();
        JPanel p2=new JPanel();
        JPanel p3=new JPanel();
        JPanel p4=new JPanel();
		ta1=new JTextArea("",25,35);
		JScrollPane scrollPane=new JScrollPane(ta1);
		textPanel.add(scrollPane);
		textPanel.setSize(400,500);
		textPanel.setLocation(0,0);
		lb1=new JLabel("按楼查询");
        
		lb1.setSize(100,30);
		lb1.setLocation(450,20);

	    jobsBox=new JComboBox();
		
		jobsBox.addItem("2号楼住宿花名册");
		jobsBox.addItem("3号楼住宿花名册");
		jobsBox.addItem("5号楼住宿花名册");
		jobsBox.addItem("7号楼住宿花名册");
		jobsBox.addItem("8号楼住宿花名册");
		jobsBox.addItem("13号楼住宿花名册");
		jobsBox.addItem("14号楼住宿花名册");
		jobsBox.addItem("明煌楼学生住宿花名册");
		jobsBox.addItem("学生公寓楼住宿花名册");
		p.add(jobsBox);
		p.setSize(200,40);
		p.setLocation(450,80);
		lb=new JLabel("楼号*");
        lb.setSize(40,40);
		lb.setLocation(420,80);
		bu11=new JButton("房号");
		bu11.setSize(60,30);
		bu11.setLocation(405,120);
		tf1=new JTextField("");
		tf1.setSize(100,30);
		tf1.setLocation(470,120);
		jobsBox1=new JComboBox();
		jobsBox1.setEditable(true);
		jobsBox1.addItem("体社系");
		jobsBox1.addItem("经法系");
		p1.add(jobsBox1);
		p1.setSize(150,40);
		p1.setLocation(460,160);
		bu12=new JButton("系别");
		bu12.setSize(60,30);
		bu12.setLocation(400,160);
		jobsBox2=new JComboBox();
	    jobsBox2.setEditable(true);
		jobsBox2.addItem("社会体育");
		jobsBox2.addItem("体保");
		p2.add(jobsBox2);
		p2.setSize(150,40);
		p2.setLocation(462,200);
		bu13=new JButton("专业");
		bu13.setSize(60,30);
		bu13.setLocation(402,200);
		tf2=new JTextField("");
		tf2.setSize(150,30);
		tf2.setLocation(465,240);
		bu14=new JButton("姓名");
		bu14.setSize(60,30);
		bu14.setLocation(402,240);
		lb2=new JLabel("全校查询");
    
		lb2.setSize(100,30);
		lb2.setLocation(450,300);
		bu15=new JButton("系别");
		bu15.setSize(60,30);
		bu15.setLocation(402,340);
		jobsBox3=new JComboBox();
		jobsBox3.setEditable(true);
		jobsBox3.addItem("体社系");
		jobsBox3.addItem("经法系");
	
		p3.add(jobsBox3);
		p3.setSize(150,40);
		p3.setLocation(455,340);
		bu16=new JButton("专业");
		bu16.setSize(60,30);
		bu16.setLocation(399,380);
		jobsBox4=new JComboBox();
		jobsBox4.setEditable(true);
		jobsBox4.addItem("社会体育");
		jobsBox4.addItem("体保");
		p4.add(jobsBox4);
		p4.setSize(150,40);
		p4.setLocation(458,380);
		bu17=new JButton("姓名");
		bu17.setSize(60,30);
		bu17.setLocation(402,420);
		tf3=new JTextField("");
		tf3.setSize(150,30);
		tf3.setLocation(465,420);
		
		c.add(textPanel);
		c.add(p);
		c.add(lb1);
		c.add(lb);
		c.add(bu11);
		c.add(tf1);
		c.add(p1);
		c.add(bu12);
		c.add(p2);
		c.add(bu13);
		c.add(tf2);
		c.add(bu14);
		c.add(lb2);
		c.add(bu15);
		c.add(p3);
		c.add(p4);
		c.add(bu16);
		c.add(bu17);
		c.add(tf3);
		setSize(650,500);
		setVisible(true);
//========设置监听========================================================		
		
		jobsBox.addActionListener(this);
		jobsBox1.addActionListener(this);
		jobsBox2.addActionListener(this);
		jobsBox3.addActionListener(this);
		jobsBox4.addActionListener(this);
		bu11.addActionListener(this);
		bu12.addActionListener(this);
		bu13.addActionListener(this);
		bu14.addActionListener(this);
		bu15.addActionListener(this);
		bu16.addActionListener(this);
		bu17.addActionListener(this);
		connect_db();
		
//==============================================================》=========================		
	}
//========连接数据库======================================================================
	 public void connect_db()
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e1)
		{
			System.out.println("Driver not found!");
		}
		try
		{
			con1=DriverManager.getConnection("jdbc:odbc:student");
			st1=con1.createStatement();
		}
		catch(SQLException e2)
		{
			System.out.println("table not found!");
		}
	}
//===================响应监听事件================================================
		public void actionPerformed(ActionEvent e)
	{
		String str11;
		String str12;
		String str13;
		String str2;
		String std_id;
		String str3;
	    String str4;
	    pp=jobsBox.getSelectedItem().toString();
             	
        pp1=jobsBox1.getSelectedItem().toString();
             	
             	
        pp2=jobsBox2.getSelectedItem().toString();
        pp3=jobsBox3.getSelectedItem().toString();
             	
             	
        pp4=jobsBox4.getSelectedItem().toString();
		try
		{
			str2=tf2.getText();
			str3=tf1.getText();
			str4=tf3.getText();
			if(e.getSource()==bu14)
			{
			rs1=st1.executeQuery("select * from "+pp+" WHERE (name LIKE '%"+str2+"%' OR name LIKE '%"+str2+"' OR name LIKE '"+str2+"%') OR (fanghao='房号')");
			str11="";
			while(rs1.next())
			{
				str11=str11+rs1.getString(1)+"\t"+rs1.getString(2)+"\t"+rs1.getString(3)+"\t"+
				rs1.getString(5)+"\t"+rs1.getString(6)+"\t"+rs1.getString(7)+"\n";
			}
		
			ta1.setText(str11);
		}
		if(e.getSource()==bu11)
		{
			rs1=st1.executeQuery("select * from "+pp+" WHERE  (fanghao='"+str3+"') OR (fanghao='房号')");
			str12="";
			while(rs1.next())
			{
				str12=str12+rs1.getString(1)+"\t"+rs1.getString(2)+"\t"+rs1.getString(3)+"\t"+
				rs1.getString(5)+"\t"+rs1.getString(6)+"\t"+rs1.getString(7)+"\n";
			}
		
			ta1.setText(str12);
		}
		if(e.getSource()==bu12)
		{
			rs1=st1.executeQuery("select * from "+pp+" WHERE (xibie='"+pp1+"') OR (fanghao='房号')");
			str13="";
			while(rs1.next())
			{
				str13=str13+rs1.getString(1)+"\t"+rs1.getString(2)+"\t"+rs1.getString(3)+"\t"+
				rs1.getString(5)+"\t"+rs1.getString(6)+"\t"+rs1.getString(7)+"\n";
			}
		
			ta1.setText(str13);
		}
		if(e.getSource()==bu13)
		{
			rs1=st1.executeQuery("select * from "+pp+" WHERE (zhuanye='"+pp2+"') OR (fanghao='房号')");
			str13="";
			while(rs1.next())
			{
				str13=str13+rs1.getString(1)+"\t"+rs1.getString(2)+"\t"+rs1.getString(3)+"\t"+
				rs1.getString(5)+"\t"+rs1.getString(6)+"\t"+rs1.getString(7)+"\n";
			}