window.java

宿舍管理系统（包括论文）： 该系统是用JAVA语言编写的学生公寓管理系统,本系统在研制开发过程中

import java.awt.*;

import javax.swing.*;
import javax.swing.event.*;
import javax.swing.tree.DefaultMutableTreeNode;

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

class Window extends JFrame implements ActionListener,TreeSelectionListener	
{
	MenuBar m_bar=new MenuBar();
	Menu m_user=new Menu("用户管理"),m_student=new Menu("学生管理"),m_dormitory=new Menu("宿舍管理");
	MenuItem m_users=new MenuItem("用户综合管理"),s_insert=new MenuItem("学生信息添加"),
	s_delete=new MenuItem("学生信息删除"),s_update=new MenuItem("学生信息修改"),
	d_update=new MenuItem("宿舍信息查询");
	MenuItem m_exit=new MenuItem("退出");
	Menu m_help=new Menu("联系我们");
	JToolBar t_bar=new JToolBar();
	JButton b_insert,b_delete,b_update,bd_update;
	JTree tree=null;
	JScrollPane jp1,jp2;
	JSplitPane js;
	JSplitPane sp;
	Connection con;
	Statement sta;
	String conURL="jdbc:mysql://localhost/login?user=root&password=root";
	JTable table;
	
	ResultSet rs;
	
	Window()
	{
		super("宿舍管理系统");
		setBounds(150,150,500,300);
		this.setResizable(false);
		b_insert=new JButton("学生信息添加");
		b_delete=new JButton("学生信息删除");
		b_update=new JButton("学生信息修改");
		
		bd_update=new JButton("宿舍信息查询");
		m_bar.add(m_user);
		m_bar.add(m_student);
		m_bar.add(m_dormitory);
		m_user.add(m_users);m_users.setEnabled(true);
		m_user.add(m_exit);m_exit.setEnabled(true);
		m_student.add(s_insert);s_insert.setEnabled(true);
		m_student.add(s_delete);s_delete.setEnabled(true);
		m_student.add(s_update);s_update.setEnabled(true);
		
		m_dormitory.add(d_update);d_update.setEnabled(true);
		this.setMenuBar(m_bar);
		setLayout(new BorderLayout());
		add(t_bar,"North");
		t_bar.add(b_insert);t_bar.add(b_delete);t_bar.add(b_update);t_bar.add(bd_update);
		DefaultMutableTreeNode root;
		DefaultMutableTreeNode[][] treeNode;
		String[][] data={
					{"一层","101宿舍","102宿舍","103宿舍","104宿舍","105宿舍"},
					{"二层","201宿舍","202宿舍","203宿舍","204宿舍","205宿舍"},
					{"三层","301宿舍","302宿舍","303宿舍","304宿舍","305宿舍"},
					{"四层","401宿舍","402宿舍","403宿舍","404宿舍","405宿舍"},
					{"五层","501宿舍","502宿舍","503宿舍","504宿舍","505宿舍"},
					{"六层","601宿舍","602宿舍","603宿舍","604宿舍","605宿舍"}
			};
		
		jp2=new JScrollPane();
		
		root=new DefaultMutableTreeNode("北海楼");
		treeNode=new DefaultMutableTreeNode[7][8];
		for(int i=0;i<data.length;i++)
		{
			treeNode[i][0]=new DefaultMutableTreeNode(data[i][0]);
			root.add(treeNode[i][0]);
			for(int j=1;j<6;j++)
			{
				treeNode[i][0].add(new DefaultMutableTreeNode(data[i][j]));
			}
		}
		tree=new JTree(root);
		jp1=new JScrollPane();
		jp1.setViewportView(tree);
		sp=new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,true,jp1,jp2);
		sp.setDividerLocation(150);
		
		add(sp,"Center");
		s_insert.addActionListener(this);
		s_delete.addActionListener(this);
		s_update.addActionListener(this);
		
		d_update.addActionListener(this);
		m_exit.addActionListener(this);
		m_users.addActionListener(this);
		tree.addTreeSelectionListener(this);
		b_insert.addActionListener(this);
		b_delete.addActionListener(this);
		b_update.addActionListener(this);
		
		bd_update.addActionListener(this);
//		new ConSql().consql();
		ConSql();
		setVisible(true);
	}
	public void valueChanged(TreeSelectionEvent e)
	{
		if(e.getSource()==tree)
		{
			DefaultMutableTreeNode node=(DefaultMutableTreeNode)tree.getLastSelectedPathComponent();
			if(node.isLeaf())
			{
				String str=node.toString();
				
				
				int z=0;
				if(str.equals("101宿舍"))
				{
					
					String[] s_data={
							"姓名","学号","性别","所在宿舍"};
					Object[][] s_d={{"","","",""},{"","","",""},{"","","",""},{"","","",""}};
					
					String s,s1,s2,s3;
					try{
						con=DriverManager.getConnection(conURL);
						rs=sta.executeQuery("select * from student");

						int i=0;
						while(rs.next())
						{
							s=rs.getString("name").trim();
							s1=rs.getString("s_number").trim();
							s2=rs.getString("sex").trim();
							s3=rs.getString("d_number").trim();
							if(s3.equals("101"))
							{
							   s_d[i][0]=s;
							   s_d[i][1]=s1;
							   s_d[i][2]=s2;
						 	   s_d[i][3]=s3;
						 	  i++;
							}
						}
					}
					catch(SQLException e1)
					{
						e1.printStackTrace();
					}
					
				    table=new JTable(s_d,s_data);
					jp2.setViewportView(table);
				}
				else if(str.equals("102宿舍"))
				{
					String[] s_data1={
							"姓名","学号","性别","所在宿舍"};
					Object[][] s_d={{"","","",""},{"","","",""},{"","","",""},{"","","",""}};
					String s,s1,s2,s3;
					
					try{
						con=DriverManager.getConnection(conURL);
						rs=sta.executeQuery("select * from student");

						int i=0;
						while(rs.next())
						{
							s=rs.getString("name").trim();
							s1=rs.getString("s_number").trim();
							s2=rs.getString("sex").trim();
							s3=rs.getString("d_number").trim();
							
							if(s3.equals("102")){
								s_d[i][0]=s;
							
							   s_d[i][1]=s1;
							   s_d[i][2]=s2;
							   s_d[i][3]=s3;
							   i++;
							}
						}
					}
					catch(SQLException e1)
					{
						e1.printStackTrace();
					}
					
				    table=new JTable(s_d,s_data1);
					jp2.setViewportView(table);
				}
				else if(str.equals("103宿舍"))
				{
					String[] s_data2={
							"姓名","学号","性别","所在宿舍"};
					Object[][] s_d={{"","","",""},{"","","",""},{"","","",""},{"","","",""}};
					String s,s1,s2,s3;
					
					try{
						con=DriverManager.getConnection(conURL);
						rs=sta.executeQuery("select * from student");

						int i=0;
						while(rs.next())
						{
							s=rs.getString("name").trim();
							s1=rs.getString("s_number").trim();
							s2=rs.getString("sex").trim();
							s3=rs.getString("d_number").trim();
							if(s3.equals("103"))
							{
							s_d[i][0]=s;
							s_d[i][1]=s1;
							s_d[i][2]=s2;
							s_d[i][3]=s3;
							i++;
							}
							
							
							}
					}
					catch(SQLException e1)
					{
						e1.printStackTrace();
					}
					
				    table=new JTable(s_d,s_data2);
					jp2.setViewportView(table);
				}
				else if(str.equals("104宿舍"))
				{
					String[] s_data3={
							"姓名","学号","性别","所在宿舍"};
					Object[][] s_d={{"","","",""},{"","","",""},{"","","",""},{"","","",""}};
					String s,s1,s2,s3;
				
					try{
						con=DriverManager.getConnection(conURL);
						rs=sta.executeQuery("select * from student");

						int i=0;
						while(rs.next())
						{
							s=rs.getString("name").trim();
							s1=rs.getString("s_number").trim();
							s2=rs.getString("sex").trim();
							s3=rs.getString("d_number").trim();
							if(s3.equals("104"))
							{
							s_d[i][0]=s;
							s_d[i][1]=s1;
							s_d[i][2]=s2;
							s_d[i][3]=s3;
							i++;
							}
							
							}
					}
					catch(SQLException e1)
					{
						e1.printStackTrace();
					}
					
				    table=new JTable(s_d,s_data3);
					jp2.setViewportView(table);
				}
				else if(str.equals("105宿舍"))
				{
					String[] s_data4={
							"姓名","学号","性别","所在宿舍"};
					Object[][] s_d={{"","","",""},{"","","",""},{"","","",""},{"","","",""}};
					String s,s1,s2,s3;
				
					try{
						con=DriverManager.getConnection(conURL);
						rs=sta.executeQuery("select * from student");

						int i=0;
						while(rs.next())
						{
							s=rs.getString("name").trim();
							s1=rs.getString("s_number").trim();
							s2=rs.getString("sex").trim();
							s3=rs.getString("d_number").trim();
							if(s3.equals("105"))
							{
							s_d[i][0]=s;
							s_d[i][1]=s1;
							s_d[i][2]=s2;
							s_d[i][3]=s3;
							i++;
							}
							
							}
					}
					catch(SQLException e1)
					{
						e1.printStackTrace();
					}
					
				    table=new JTable(s_d,s_data4);
					jp2.setViewportView(table);
				}
				
				else 
				{
					
				}
			}
		}
	}
	public void actionPerformed(ActionEvent e)
	{
		if((e.getSource()==b_insert)||(e.getSource()==s_insert))
		{
			new B_insert();
		}
		else if((e.getSource()==b_delete)||(e.getSource()==s_delete))
		{
			new B_delete();
		}
		else if((e.getSource()==b_update)||(e.getSource()==s_update))
		{
		    new B_update();	
		}
		
		else if((e.getSource()==bd_update)||(e.getSource()==d_update))
		{
			new BD_update();
		}
	}
	public void ConSql()
	{
		try{
			Class.forName("com.mysql.jdbc.Driver");
			con=DriverManager.getConnection(conURL);
			sta=con.createStatement();
		}
		catch(ClassNotFoundException e){
			e.printStackTrace();
		}
		catch(SQLException e){
			e.printStackTrace();
		}
	}
	
}