j_studentmessage.java

简单的学生管理系统系统

		}
		return jDialog;
	}

	/**
	 * This method initializes jContentPane1	
	 * 	
	 * @return javax.swing.JPanel	
	 */
	private JPanel getJContentPane1() {
		if (jContentPane1 == null) {
			jLabel3 = new JLabel();
			jLabel3.setBounds(new Rectangle(9, 83, 48, 24));
			jLabel3.setText("学号：");
			jLabel2 = new JLabel();
			jLabel2.setBounds(new Rectangle(8, 47, 44, 27));
			jLabel2.setText("姓名：");
			jLabel1 = new JLabel();
			jLabel1.setBounds(new Rectangle(14, 12, 203, 29));
			jLabel1.setText("请输入要查找的学生的姓名和学号");
			jContentPane1 = new JPanel();
			jContentPane1.setLayout(null);
			jContentPane1.add(jLabel1, null);
			jContentPane1.add(getJtfname(), null);
			jContentPane1.add(getJButton3(), null);
			jContentPane1.add(getJButton4(), null);
			jContentPane1.add(jLabel2, null);
			jContentPane1.add(jLabel3, null);
			jContentPane1.add(getJtfnumber(), null);
			ImageIcon ic=new ImageIcon("hua.jpg");
			JLabel jbl=new JLabel();
			jbl.setIcon(ic);
			jbl.setBounds(new Rectangle(0, 0, 335, 146));
			jContentPane1.setOpaque(false);
			jContentPane1.add(jbl, null);
		}
		return jContentPane1;
	}

	/**
	 * This method initializes jtfname	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJtfname() {
		if (jtfname == null) {
			jtfname = new JTextField();
			jtfname.setBounds(new Rectangle(59, 47, 162, 26));
		}
		return jtfname;
	}

	/**
	 * This method initializes jButton3	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton3() {
		if (jButton3 == null) {
			jButton3 = new JButton();
			jButton3.setBounds(new Rectangle(193, 117, 62, 27));
			jButton3.setText("搜素");
			jButton3.addActionListener(new java.awt.event.ActionListener() 
			{
				public void actionPerformed(java.awt.event.ActionEvent e) 
				{
					try
				    {   if(!jtfname.getText().isEmpty()||!jtfnumber.getText().isEmpty())
				    {
				    	
					     J_Studentmessagepanel  jstdmsgpnl=new J_Studentmessagepanel();					
				    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				    	Connection c=DriverManager.getConnection("jdbc:odbc:studentSqlDatabase","sa","");
				    	Statement s=c.createStatement(
				    			ResultSet.TYPE_SCROLL_SENSITIVE,
				    			ResultSet.CONCUR_UPDATABLE
				    			);
				    	 System.out.println("actd");
				        ResultSet r=s.executeQuery("select * from  "+J_Denglu.choice.getSelectedItem()+" where 学号='"+jtfnumber.getText()
				        		+"' or  姓名='"+jtfname.getText()+"'");
				        r.beforeFirst();
				        if(r.next())
				           {
				        	    jstdmsgpnl.mb_showstudentmessage(r);jPanel1student.removeAll();	
				        	    jPanel1student.add(jstdmsgpnl);					    
							    jPanel1student.repaint();
							    jPanel1student.validate();
							    jPanel1student.setVisible(true);
							    getJDialog().dispose();
				           }
				        else JOptionPane.showMessageDialog(null,"没有找到所要的学生记录");
				      				   				     				       				      				
				        s.close();
				        c.close();
				      
				    }
				    else   JOptionPane.showMessageDialog(null,"请输入学号或姓名！");
				    	
				    }
				    catch(Exception e1)
				    {
				    	  JOptionPane.showMessageDialog(null,"查找失败");
				    }
				}
			});
		}
		return jButton3;
	}

	/**
	 * This method initializes jButton4	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton4() {
		if (jButton4 == null) {
			jButton4 = new JButton();
			jButton4.setBounds(new Rectangle(268, 116, 62, 26));
			jButton4.setText("取消");
			jButton4.addActionListener(new java.awt.event.ActionListener()
			{
				public void actionPerformed(java.awt.event.ActionEvent e)
				{
					getJDialog().dispose();
				}
			});
		}
		return jButton4;
	}

	/**
	 * This method initializes jtfnumber	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJtfnumber() {
		if (jtfnumber == null) {
			jtfnumber = new JTextField();
			jtfnumber.setBounds(new Rectangle(65, 80, 155, 30));
		}
		return jtfnumber;
	}
    public static  void mb_clicktable(Vector vectclick)
    {
    	try {
    		jPanel1student.removeAll();
        	J_Studentmessagepanel jst=new J_Studentmessagepanel();
        	jst.mb_lookmessage(vectclick);
        	jst.mb_button();
        	jPanel1student.add(jst);
        	jPanel1student.repaint();
        	jPanel1student.validate();
        	jPanel1student.setVisible(true);
		} catch (Exception e) {	}
    }

	/**
	 * This method initializes jButton5	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton5() {
		if (jButton5 == null) {
			jButton5 = new JButton();
			jButton5.setBounds(new Rectangle(29, 303, 150, 24));
			jButton5.setText("删除");
			jButton5.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					getJDialog1().setVisible(true);
				}
			});
		}
		return jButton5;
	}

	/**
	 * This method initializes jDialog1	
	 * 	
	 * @return javax.swing.JDialog	
	 */
	private JDialog getJDialog1() {
		if (jDialog1 == null) {
			jDialog1 = new JDialog(this);
			jDialog1.setSize(new Dimension(311, 168));
			jDialog1.setLocation(new Point(200, 100));
			jDialog1.setContentPane(getJContentPane2());
		}
		return jDialog1;
	}

	/**
	 * This method initializes jContentPane2	
	 * 	
	 * @return javax.swing.JPanel	
	 */
	private JPanel getJContentPane2() {
		if (jContentPane2 == null) {
			jLabel6 = new JLabel();
			jLabel6.setBounds(new Rectangle(2, 2, 303, 132));
			ImageIcon ic=new ImageIcon("hua.jpg");
			jLabel6.setIcon(ic);
			jLabel6.setBounds(new Rectangle(0, 0, 335, 146));		
			jLabel5 = new JLabel();
			jLabel5.setBounds(new Rectangle(11, 58, 49, 33));
			jLabel5.setText("学号：");
			jLabel4 = new JLabel();
			jLabel4.setBounds(new Rectangle(9, 15, 173, 29));
			jLabel4.setText("请输入要删除的学生的学号：");
			jContentPane2 = new JPanel();
			jContentPane2.setLayout(null);
			jContentPane2.add(jLabel4, null);
			jContentPane2.add(jLabel5, null);
			jContentPane2.add(getJTextField(), null);
			jContentPane2.add(getJButton6(), null);
			jContentPane2.add(getJButton7(), null);
			jContentPane2.setOpaque(false);
			jContentPane2.add(jLabel6, null);
		}
		return jContentPane2;
	}

	/**
	 * This method initializes jTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField() {
		if (jTextField == null) {
			jTextField = new JTextField();
			jTextField.setBounds(new Rectangle(62, 59, 168, 33));
		}
		return jTextField;
	}

	/**
	 * This method initializes jButton6	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton6() {
		if (jButton6 == null) {
			jButton6 = new JButton();
			jButton6.setBounds(new Rectangle(139, 102, 65, 28));
			jButton6.setText("确定");
			jButton6.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					try
					{   if(!jTextField.getText().isEmpty())
						{
						Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

						Connection c=DriverManager.getConnection("jdbc:odbc:studentSqlDatabase","sa","");
				    	Statement s=c.createStatement();
				    	int n=0;
				    	n=s.executeUpdate("delete from "+J_Denglu.m_strbanji+" where  学号='"+jTextField.getText()+"'");
				    	
				    	s.close();
				    	c.close();
				    	 if(n>0)
				    	 {
				    		 JOptionPane.showMessageDialog(null,"删除成功");
				    		 jTextField.setText("");
				    		 getJDialog1().dispose(); 
				    	 }
				    	 
				    	    else{
				    	    	JOptionPane.showMessageDialog(null,"找不到该学号的学生！");
				    	    	jTextField.setText("");
				    	    }
						}
				    	else 
					   {
						JOptionPane.showMessageDialog(null,"学号字段不能为空！");
				     	}
						
					}
					catch (Exception e1) {
						JOptionPane.showMessageDialog(null,e1.getMessage());
					}
				}
			});
		}
		return jButton6;
	}

	/**
	 * This method initializes jButton7	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton7() {
		if (jButton7 == null) {
			jButton7 = new JButton();
			jButton7.setBounds(new Rectangle(213, 101, 65, 30));
			jButton7.setText("取消");
			jButton7.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					getJDialog1().dispose();
				}
			});
		}
		return jButton7;
	}
}  //  @jve:decl-index=0:visual-constraint="12,10"