j_studentmessagepanel.java

简单的学生管理系统系统

import java.awt.Color;
import java.awt.Font;
import java.awt.Image;
import java.awt.Rectangle;
import java.awt.event.KeyEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Vector;

import javax.swing.ButtonGroup;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFileChooser;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JRadioButton;
import javax.swing.JTextField;

public class J_Studentmessagepanel extends JPanel {

	private static final long serialVersionUID = 1L;
	private JLabel jLabel = null;
	private JLabel jLabel1 = null;
	private JLabel jLabel2 = null;
	private JLabel jLabel3 = null;
	private JLabel jLabel4 = null;
	private JLabel jLabel5 = null;
	private JLabel jLabel6 = null;
	private  JTextField jtfname = null;
	private  JTextField jtfnumber = null;
	private  JTextField jtfage = null;
	private  JTextField jtfaddress = null;
	private  JTextField jtftelphone = null;
	private  JLabel jLabel7 = null;
	private JButton jButton = null;
	private JButton jButton1 = null;
	private JButton jButton2 = null;
	private JButton jButton3 = null;
	private JButton jButton4 = null;
	private JButton jButton5 = null;
	private JButton jButton6 = null;
	private static JRadioButton jrbman = null;
	private static JRadioButton jrbwoman = null;
	private static String m_photo=null;
	ResultSet r;  //  @jve:decl-index=0:
	Connection c;
	Statement s;
	Vector vectrow;  //  @jve:decl-index=0:
    Vector vectclum=new Vector();  //  @jve:decl-index=0:
    private static int index;
    
    JFileChooser jchose;
	/**
	 * This is the default constructor
	 */
	public J_Studentmessagepanel() {
		super();
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		jLabel7 = new JLabel();
		jLabel7.setBounds(new Rectangle(323, 71, 135, 145));
		jLabel7.setIcon(new ImageIcon("52065.gif"));
		jLabel7.setDisplayedMnemonic(KeyEvent.VK_UNDEFINED);
		jLabel7.setText("照片");
		jLabel6 = new JLabel();
		jLabel6.setBounds(new Rectangle(19, 290, 97, 32));
		jLabel6.setForeground(new Color(244, 241, 167));
		jLabel6.setText("电话：");
		jLabel5 = new JLabel();
		jLabel5.setBounds(new Rectangle(17, 246, 100, 34));
		jLabel5.setForeground(new Color(244, 241, 167));
		jLabel5.setText("家庭住址：");
		jLabel4 = new JLabel();
		jLabel4.setBounds(new Rectangle(18, 202, 97, 34));
		jLabel4.setForeground(new Color(244, 241, 167));
		jLabel4.setText("性别：");
		jLabel3 = new JLabel();
		jLabel3.setBounds(new Rectangle(19, 156, 97, 34));
		jLabel3.setForeground(new Color(244, 241, 167));
		jLabel3.setText("年龄：");
		jLabel2 = new JLabel();
		jLabel2.setBounds(new Rectangle(19, 110, 96, 34));
		jLabel2.setForeground(new Color(244, 241, 167));
		jLabel2.setText("学号：");
		jLabel1 = new JLabel();
		jLabel1.setBounds(new Rectangle(153, 6, 166, 46));
		jLabel1.setFont(new Font("Dialog", Font.BOLD, 24));
		jLabel1.setForeground(new Color(244, 241, 167));
		jLabel1.setText("学生基本信息");
		jLabel = new JLabel();
		jLabel.setBounds(new Rectangle(18, 66, 98, 34));
		jLabel.setForeground(new Color(244, 241, 167));
		jLabel.setText("姓名：");
		this.setSize(461, 366);
		this.setLayout(null);
		this.add(jLabel, null);
		this.add(jLabel1, null);
		this.add(jLabel2, null);
		this.add(jLabel3, null);
		this.add(jLabel4, null);
		this.add(jLabel5, null);
		this.add(jLabel6, null);
		this.add(getJtfname(), null);
		this.add(getJtfnumber(), null);
		this.add(getJtfage(), null);
		this.add(getJtfaddress(), null);
		this.add(getJtftelphone(), null);
		this.add(jLabel7, null);
		this.add(getJButton(), null);
		this.add(getJButton1(), null);
		this.add(getJButton2(), null);
		this.add(getJButton3(), null);
		this.add(getJButton4(), null);
		this.add(getJButton5(), null);
		this.add(getJButton6(), null);
		this.add(getJrbman(), null);
		this.add(getJrbwoman(), null);
		
		ImageIcon ic=new ImageIcon("yue.jpg");
		JLabel jbl=new JLabel();
		jbl.setIcon(ic);
		jbl.setBounds(new Rectangle(-30, 0, 491, 366));
		this.setOpaque(false);
		this.add(jbl, null);
		
		chazhaoxiangliang();
		index=0;
		mb_lookmessage((Vector) vectclum.get(index));
		jtfname.setEditable(false);
		jtfnumber.setEditable(false);
		jtfage.setEditable(false);
		jtfaddress.setEditable(false);
		jtftelphone.setEditable(false);
		jrbman.setEnabled(false);
		jrbwoman.setEnabled(false);
		jButton.setEnabled(false);
		jButton6.setEnabled(false);
	}

	private void chazhaoxiangliang() {
		try 
		{
			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);
		    r=s.executeQuery("select * from  "+J_Denglu.m_strbanji);
			r.beforeFirst();
			while(r.next())
		   {
				vectrow=new Vector();
				vectrow.addElement(r.getString("姓名"));
				vectrow.addElement(r.getString("学号"));
				vectrow.addElement(r.getString("年龄"));
				vectrow.addElement(r.getString("性别"));
				vectrow.addElement(r.getString("家庭住址"));
				vectrow.addElement(r.getString("电话"));
				vectrow.addElement(r.getString("照片"));
				vectclum.addElement(vectrow);
				
			}			
			s.close();
			c.close();
		} catch (Exception e) 
		{
			System.err.println("异常"+e.getMessage()+"sadfa");
		}
	}

    public  void mb_showstudentmessage(ResultSet r)
    {
    	try
    	{
		    	   jtfname.setText(r.getString("姓名").toString().trim());
		    	   
	        		jtfnumber.setText(r.getString("学号").toString().trim());
	        		
	        	    jtfage.setText(r.getString("年龄"));
	        	    
	        		if(String.valueOf(r.getString("性别").trim()).equals("男"))
	        			jrbman.setSelected(true);
	        		else jrbwoman.setSelected(true);
	        			        	
	        		jtfaddress.setText(r.getString("家庭住址").toString().trim()); 
	        		
	        		
	        		
	        		jtftelphone.setText(r.getString("电话").toString().trim()); 
	        		try
	        		{
	        		   if(r.getString("照片").toString()!=null)
	        		   {
	        			jLabel7.setVisible(true);	   
	        			ImageIcon mc=new ImageIcon(r.getString("照片"));
	        			mc.setImage(mc.getImage().getScaledInstance(jLabel7.getSize().width, jLabel7.getSize().height, Image.SCALE_DEFAULT));
	        			jLabel7.setIcon(mc);
	        		   }
	        		}
	        		catch (Exception e) {}
	        		
	        		finally{}
	        		    		
    	}
    	catch(Exception e)
    	{System.err.println("异常"+e.getMessage()+"2332443");}
   
    }
	private JTextField getJtfname() {
		if (jtfname == null) {
			jtfname = new JTextField();
			jtfname.setBounds(new Rectangle(117, 67, 195, 32));
			jtfname.setEditable(false);
		}
		return jtfname;
	}
	private JTextField getJtfnumber() {
		if (jtfnumber == null) {
			jtfnumber = new JTextField();
			jtfnumber.setBounds(new Rectangle(116, 111, 192, 32));
			jtfnumber.setEditable(false);
			
		}
		return jtfnumber;
	}
	private JTextField getJtfage() {
		if (jtfage == null) {
			jtfage = new JTextField();
			jtfage.setBounds(new Rectangle(116, 155, 191, 35));
			jtfage.setEditable(false);
		}
		return jtfage;
	}

	private JTextField getJtfaddress() {
		if (jtfaddress == null) {
			jtfaddress = new JTextField();
			jtfaddress.setBounds(new Rectangle(116, 246, 192, 33));
			jtfaddress.setEditable(false);
		}
		return jtfaddress;
	}
	private JTextField getJtftelphone() {
		if (jtftelphone == null) {
			jtftelphone = new JTextField();
			jtftelphone.setBounds(new Rectangle(119, 291, 190, 30));
			jtftelphone.setEditable(false);
		}
		return jtftelphone;
	}

	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(378, 217, 77, 31));
			jButton.setText("浏览");
			jButton.setEnabled(false);
			jButton.addActionListener(new java.awt.event.ActionListener() 
			{
				public void actionPerformed(java.awt.event.ActionEvent e) 
				{
					try
					{
					  JFileChooser jchose = new JFileChooser();
					  int n=jchose.showOpenDialog(null);
					   m_photo = jchose.getSelectedFile().getName();
					  if(!m_photo.isEmpty())
				      {
					      jLabel7.setIcon(new ImageIcon(m_photo));
                          jLabel7.setVisible(true);
				      }
					  else