youjian.java

实现简单宿舍管理系统

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
class select extends JFrame implements ActionListener
{JLabel j1;
JTextField t1;
JButton b1,b2,b3;
JPanel p1,p2;
String Sno,s1,s2,s3,s4,s5,s6,s7,s8,s9;
Container c1=null;
//查询模块的建立
public select()
	{super("查询模块");
	p1=new JPanel();
	p2=new JPanel();
	j1=new JLabel("请输入查询的学生学号");
	j1.setForeground(Color.BLUE);
	j1.setFont(new Font("BOLD",Font.BOLD,28));
	t1=new JTextField(20);
	b1=new JButton("确定");
	b2=new JButton("清除");
	b3=new JButton("退出");
	p1.add(j1);
	p1.add(t1);
	p2.add(b1);
	p2.add(b2);
	p2.add(b3);
	c1=getContentPane();
	c1.add(p1,"Center");
	c1.add(p2,"South");
	b1.addActionListener(this);
	b2.addActionListener(this);
	b3.addActionListener(this);
	}
public void actionPerformed(ActionEvent e)
	{ try{ if(e.getSource()==b1)
	          { try{ Sno=t1.getText();
                     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			         Connection cn=DriverManager.getConnection("jdbc:odbc:宿舍管理","df","1234");
			         String str="select * from email where Sno='"+Sno+"'";
			         PreparedStatement ps=cn.prepareStatement(str);
			         ResultSet rs=ps.executeQuery();
			         System.out.println("Sno="+Sno);
                     if(rs.next()) { s1=rs.getString("Sno");
			                         s2=rs.getString("Sname");
                                     s3=rs.getString("Ssex");
			                         s4=rs.getString("Sdept");
                                     s5=rs.getString("Dno");
			                         s6=rs.getString("Dnum");
                                     s7=rs.getString("Marrive");
			                         s8=rs.getString("Mreceive");
									 s9=rs.getString("Mnumber");
							         chaxun md=new chaxun(this);
							         md.setVisible(true);
			                       }
			        else { JOptionPane.showMessageDialog(null,"您输入的学号有误，请重新输入","输入错误",JOptionPane.YES_NO_OPTION);
			             }
			       cn.close();
                   }
		       catch(SQLException g)
		       { System.out.println("Error Code:"+g.getErrorCode());
		         System.out.println("Message="+g.getMessage());
		       }
		       catch(Exception f)
               { f.printStackTrace();
		       }
	       }
	  if(e.getSource()==b2)
	  { t1.setText("");
	    t1.repaint();
	  }
     if(e.getSource()==b3)
	  { System.exit(0);
      }
  }
	catch(NumberFormatException ex)
    { JOptionPane.showMessageDialog(null,"数据转换错误!"); }
}
class chaxun extends JFrame implements ActionListener
  { JTextField ss1,ss2,ss3,ss4,ss5,ss6,ss7,ss8,ss9;
    JButton j2;
	select pa2;
	Container pp=null;
	chaxun(select d)
	  { super("学生信息");
	     pa2=d;
        pp=getContentPane();
		setBackground(new Color(215,215,215));
		pp.setLayout(new GridLayout(3,1));
		ss1=new JTextField(s1);
		ss2=new JTextField(s2);
        ss3=new JTextField(s3);
		ss4=new JTextField(s4);
        ss5=new JTextField(s5);
		ss6=new JTextField(s6);
        ss7=new JTextField(s7);
		ss8=new JTextField(s8);
		ss9=new JTextField(s9);
		ss1.setEditable(false);
		ss2.setEditable(false);
        ss3.setEditable(false);
		ss4.setEditable(false);
        ss5.setEditable(false);
		ss6.setEditable(false);
        ss7.setEditable(false);
		ss8.setEditable(false);
		ss9.setEditable(false);
		JPanel pt1=new JPanel();
		pt1.add(new JLabel("学号为"+Sno+"学生的学生信息"));
		pp.add(pt1);
        JPanel pt2=new JPanel();
		pt2.add(new JLabel("学号",SwingConstants.CENTER));
		ss1.setText(Sno);
		pt2.add(ss1);
        pt2.add(new JLabel("姓名",SwingConstants.CENTER));
		pt2.add(ss2);
        pt2.add(new JLabel("性别",SwingConstants.CENTER));
		pt2.add(ss3);
        pt2.add(new JLabel("院系",SwingConstants.CENTER));
		pt2.add(ss4);
        pt2.add(new JLabel("宿舍号",SwingConstants.CENTER));
		pt2.add(ss5);
        pt2.add(new JLabel("宿舍电话",SwingConstants.CENTER));
		pt2.add(ss6);
        pt2.add(new JLabel("到达时间",SwingConstants.CENTER));
		pt2.add(ss7);
        pt2.add(new JLabel("接收时间",SwingConstants.CENTER));
		pt2.add(ss8);
		pt2.add(new JLabel("邮件数量",SwingConstants.CENTER));
        pt2.add(ss9); 
		pp.add(pt2);
		JPanel pt3=new JPanel(new FlowLayout());
		j2=new JButton("返回");
		j2.addActionListener(this);
		pt3.add(j2);
		pp.add(pt3);
		this.setSize(400,300);
	  }
public void actionPerformed(ActionEvent f)
	  {if(f.getSource()==j2)
		  { shutdown2();}
	  }
public void shutdown2()
	  { pa2.setVisible(true);
	    this.dispose();
	  }
 }
}
//添加模块的建立
	class charu extends JFrame implements ActionListener
	{ JPanel a1,a2;
	JButton o1,o2,o3;
	JLabel k1;
	JTextField e1,e2,e3,e4,e5,e6,e7,e8,e9;
	String Sno,Sname,Ssex,Sdept,Dno,Dnum,Marrive,Mreceive,Mnumber;
	Container dd=null;
	public charu()
		{super("添加模块");
		a1=new JPanel();
		a2=new JPanel();
		o1=new JButton("确定");
		o2=new JButton("清除");
		o3=new JButton("退出");
		k1=new JLabel("学生信息",SwingConstants.CENTER);
		k1.setForeground(Color.BLUE);
	    k1.setFont(new Font("BOLD",Font.BOLD,28));
		dd=getContentPane();
		dd.setLayout(new GridLayout(3,1));
		a1=new JPanel(new GridLayout(9,2));
		a2=new JPanel(new FlowLayout());
		dd.add(k1);
		e1=new JTextField(20);
		e2=new JTextField(20);
		e3=new JTextField(20);
		e4=new JTextField(20);
		e5=new JTextField(20);
		e6=new JTextField(20);
		e7=new JTextField(20);
		e8=new JTextField(20);
		e9=new JTextField(20);
		a1.add(new JLabel("学号",SwingConstants.CENTER));
	  a1.add(e1);
     a1.add(new JLabel("姓名",SwingConstants.CENTER));
	  a1.add(e2);
      a1.add(new JLabel("性别",SwingConstants.CENTER));
	  a1.add(e3);
     a1.add(new JLabel("院系",SwingConstants.CENTER));
	  a1.add(e4);
      a1.add(new JLabel("宿舍号",SwingConstants.CENTER));
	  a1.add(e5);
      a1.add(new JLabel("宿舍电话",SwingConstants.CENTER));
	  a1.add(e6);
      a1.add(new JLabel("到达时间",SwingConstants.CENTER));
	  a1.add(e7);
      a1.add(new JLabel("接收时间",SwingConstants.CENTER));
	  a1.add(e8);
	  a1.add(new JLabel("邮件数量",SwingConstants.CENTER));
	  a1.add(e9);
	  dd.add(a1);
	  a2.add(o1);
	  a2.add(o2);
	  a2.add(o3);
	  dd.add(a2);
	  o1.addActionListener(this);
	  o2.addActionListener(this);
	  o3.addActionListener(this);
	}
public void actionPerformed(ActionEvent e)
	{ if(e.getSource()==o1)
		{ addfi();}
      if(e.getSource()==o2)
		{ clearform(); }
	  if(e.getSource()==o3)
		{ shutdown4(); }
	}
private void addfi()
		{ Sno=e1.getText();
	      Sname=e2.getText();
          Ssex=e3.getText();
          Sdept=e4.getText();
	      Dno=e5.getText();
          Dnum=e6.getText();
          Marrive=e7.getText();
          Mreceive=e8.getText();
		  Mnumber=e9.getText();
		  if(Sno.length()==0||Sname.length()==0||Ssex.length()==0||
			  Sdept.length()==0||Dno.length()==0||Dnum.length()==0||
			  Marrive.length()==0||Mreceive.length()==0||Mnumber.length()==0)
			  JOptionPane.showMessageDialog(this,"请添加完全信息");
		  else
			{ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			       Connection cn=DriverManager.getConnection("jdbc:odbc:宿舍管理","df","1234");
			       String sqm="insert into email values(?,?,?,?,?,?,?,?,?)";
			       PreparedStatement ps=cn.prepareStatement(sqm);
				   ps.setString(1,Sno);
				   ps.setString(2,Sname);
				   ps.setString(3,Ssex);
                   ps.setString(4,Sdept);
				   ps.setString(5,Dno);
				   ps.setString(6,Dnum);
                   ps.setString(7,Marrive);
				   ps.setString(8,Mreceive);
				   ps.setString(9,Mnumber);
				   ps.executeUpdate();
				   cn.close();
				   JOptionPane.showMessageDialog(this,"添加成功!");
				   clearform();
		         }
			catch(SQLException e)
			{ System.out.println("E Code:"+e.getErrorCode());
		      System.out.println("E Message="+e.getMessage());
			}
			catch(Exception e)
				{ e.printStackTrace();}
			}
		}
private void clearform()
		{ e1.setText("");
          e2.setText("");
          e3.setText("");
          e4.setText("");
          e5.setText("");
          e6.setText("");
          e7.setText("");
          e8.setText("");
		  e9.setText("");
		}
private void shutdown4()
	{ System.exit(0);
    }
}
//删除模块的建立
class shanchu extends JFrame implements ActionListener
{ JButton u1,u2;
JTextField x1;
JLabel z1,z2;
JPanel y1,y2;
String Sno;
Container ff=null;
public shanchu()
	{super("删除模块");
    ff=getContentPane();
	ff.setLayout(new GridLayout(3,1));
	ff.setFont(new Font("true",Font.TRUETYPE_FONT,13));
	y1=new JPanel();
	y2=new JPanel();
	z1=new JLabel("删除学生信息",SwingConstants.CENTER);
	z1.setFont(new Font("true",Font.TRUETYPE_FONT,20));
	z1.setForeground(Color.BLUE);
   	ff.add(z1);
	u1=new JButton("确定");
	u2=new JButton("退出");
	z2=new JLabel("请输入学号：");
	x1=new JTextField(20);
	y1.add(z2);
	y1.add(x1);
	y2.add(u1);
	y2.add(u2);
	ff.add(y1);
	ff.add(y2);
	u1.addActionListener(this);
	u2.addActionListener(this);
	}
public void actionPerformed(ActionEvent e)
	{ if(e.getSource()==u1)
		{ del(); }
	  if(e.getSource()==u2)
		{ shutdown3(); }
	}
	 private void del()
		{ Sno=x1.getText();
	      try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		       Connection cn=DriverManager.getConnection("jdbc:odbc:宿舍管理","df","1234");
			   Statement stmt=cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
               String sqm="delete from email where Sno='"+Sno+"'";
               stmt.executeUpdate(sqm);
			   stmt.close();
		       cn.close();
		       JOptionPane.showMessageDialog(this,"删除成功");
	         }
	  catch(SQLException e)
		  { System.out.println("Error Code:"+e.getErrorCode());
		    System.out.println("Message="+e.getMessage());
		  }
	  catch(Exception e)
			{ e.printStackTrace(); }
		}
		private void shutdown3()
	        {   System.exit(0);
			}
}
//邮递快件系统页面的建立
public class youjian extends JFrame implements ActionListener
{ Container cp=null;
  JLabel m;
  JButton n1,n2,n3,n4;
  JPanel m1,m2;
select st=new select();
charu is=new charu();
shanchu sc=new shanchu();
  public youjian()
	{ super("收取快件");
      cp=getContentPane();
      m=new JLabel("欢迎进入邮件接收系统！",SwingConstants.CENTER);
	  m.setForeground(Color.BLUE);
	  m.setFont(new Font("BOLD",Font.BOLD,25));
	  m1=new JPanel();
	  m1.add(m);
	  cp.add(m1,BorderLayout.CENTER);
	  n1=new JButton("查询");
	  n2=new JButton("添加");
	  n3=new JButton("删除");
	  n4=new JButton("退出");
	  m2=new JPanel();
      m2.add(n1);
      m2.add(n2);
	  m2.add(n3);
	  m2.add(n4);
	  cp.add(m2,BorderLayout.SOUTH);
      st.setSize(350,200);
	  st.setVisible(false);
	  is.setSize(500,600);
	  is.setVisible(false);
	  sc.setSize(350,200);
	  sc.setVisible(false);
	  n1.addActionListener(this);
	  n2.addActionListener(this);
	  n3.addActionListener(this);
	  n4.addActionListener(this);
	}
public void actionPerformed(ActionEvent e)
	{ if((JButton)e.getSource()==n1)
	   st.setVisible(true);
      if((JButton)e.getSource()==n2)
		is.setVisible(true);
	  if((JButton)e.getSource()==n3)
		sc.setVisible(true);
	  if((JButton)e.getSource()==n4)
		  System.exit(0);
	}
 public static void main(String[] args)
	{  
      try
	       { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	         Connection con=DriverManager.getConnection("jdbc:odbc:宿舍管理","df","1234");
	         Statement stmt=con.createStatement();
	         ResultSet rs=stmt.executeQuery("select * from email");
	         ResultSetMetaData rmeta=rs.getMetaData();
	         int numCols=rmeta.getColumnCount();
	         while(rs.next())
		       { for(int i=1;i<=numCols;i++)
			     { String sTemp=rs.getString(i);
	               System.out.println(sTemp);
			     }
		       }
	       }
	  catch(ClassNotFoundException e)
	    { e.printStackTrace();
	    }
	 catch(SQLException e)
	    { e.printStackTrace();
	    }
		youjian frame2=new youjian();
		frame2.setSize(400,200);
		frame2.setVisible(true);
}
}