infoupdatejpanel2.java

学生信息管理系统 java + access

/**
 *文件；InfoInsertJPanel.java
 *说明：学生信息插入面版
 **/
 
 package com.javaseries.java.component;
 import java.awt.*;
 import java.awt.event.*;
 import javax.swing.*;
 import java.sql.*;
 import java.text.*;

 
 public class InfoDeleteJPanel extends JPanel
     implements ActionListener{
     	//声明标签
     	private JLabel JLsno=new JLabel("学    号:");
     	private JLabel JLname=new JLabel("姓    名:");
     	private JLabel JLsex=new JLabel("性    别:");
     	private JLabel JLbirthday=new JLabel("出生日期:");
     	private JLabel JLmophone=new JLabel("移动电话:");
     	private JLabel JLphone=new JLabel("固定电话:");
     	private JLabel JLdepartment=new JLabel("院系名称:");
     	private JLabel JLaddress=new JLabel("家庭住址:");
     	//声明文本输入框
     	private JTextField JTFsno = new JTextField(10);
     	private JTextField JTFsname = new JTextField(10);
     	private JTextField JTFsex = new JTextField(10);
     	private JTextField JTFsbirthday = new JTextField(10);
     	private JTextField JTFsmophone = new JTextField(10);
     	private JTextField JTFsphone = new JTextField(10);
     	private JTextField JTFsdepartment = new JTextField(10);
     	private JTextField JTFsaddress = new JTextField(50);     	
     	//
        private JButton JBlocator = new JButton("查询");
     	private JButton JBsubmit = new JButton("删除");
     	private JButton JBreset = new JButton("重置");
     	//
     	private JPanel JPlocator = new JPanel();
     	private JPanel JPLabels = new JPanel();
     	private JPanel JPsex = new JPanel();
     	private JPanel JPlistArea = new JPanel();
     	private JPanel JPechoArea = new JPanel();
     	private JPanel JPbuttons = new JPanel();
     	//
     	public InfoDeleteJPanel(){
     		//
     	init();
     	}
     	
     	private void init(){
     	
     		JPlocator.setLayout(new FlowLayout());
     		JPlocator.add(JLsno);
     		JPlocator.add(JTFsno);
     		JPlocator.add(JBlocator);
     		//
     		JPLabels.setLayout(new GridLayout(8,1));
     	//	JPLabels.setSize(10,20);
     		JLsno.setHorizontalAlignment(SwingConstants.CENTER);
     		JLname.setHorizontalAlignment(SwingConstants.CENTER);
     		JLsex.setHorizontalAlignment(SwingConstants.CENTER);
     		JLbirthday.setHorizontalAlignment(SwingConstants.CENTER);
     		JLmophone.setHorizontalAlignment(SwingConstants.CENTER);
     		JLphone.setHorizontalAlignment(SwingConstants.CENTER);
     		JLdepartment.setHorizontalAlignment(SwingConstants.CENTER);
     		JLaddress.setHorizontalAlignment(SwingConstants.CENTER);
     		
     		JPLabels.add(JLname);
     		JPLabels.add(JLsex);
     		JPLabels.add(JLbirthday);
     		JPLabels.add(JLmophone);
     		JPLabels.add(JLphone);
     		JPLabels.add(JLdepartment);
     		JPLabels.add(JLaddress);
     		
     	
     		JPechoArea.setLayout(new GridLayout(8,1));
     		JPechoArea.add(JTFsname);
     		JPechoArea.add(JTFsex);
     		JPechoArea.add(JTFsbirthday);
     		JPechoArea.add(JTFsmophone);
     		JPechoArea.add(JTFsphone);
     		JPechoArea.add(JTFsdepartment);
     		JPechoArea.add(JTFsaddress);
     		
     		
     		JPlistArea.setLayout(new GridLayout(1,2));
     		JPlistArea.add(JPLabels);
     		JPlistArea.add(JPechoArea);
     		//
     		JPbuttons.setLayout(new FlowLayout(FlowLayout.CENTER));
     
            JBsubmit.setEnabled(false);
            JBreset.setEnabled(false);
            JPbuttons.add(JBsubmit);
            JPbuttons.add(JBreset);	
     		//
     		this.setLayout(new GridLayout(3,1));
     		this.add(JPlocator);
     		this.add(JPlistArea);
     		this.add(JPbuttons);
     		//
     		JBlocator.addActionListener(this);
     		JBsubmit.addActionListener(this);
     		JBreset.addActionListener(this);
         	}
     public void actionPerformed(ActionEvent e){
     	String Command=e.getActionCommand();
     	String sno=JTFsno.getText();
     	InfoModelDB mydata=null;
     	try{
     		mydata=new InfoModelDB(sno,null,null,null,null,null,null,null);
     	}catch (SQLException ex){
     		ex.printStackTrace();
     	}catch (ClassNotFoundException ex){
     		ex.printStackTrace();
     	}
     	
     	
     	if(Command.equals("查询"))
     	{//到数据库中查询数据
     		try{
     			String sqlst="select * from students where sno='"+sno+"'";
     			ResultSet rs=mydata.executeSelect(sqlst);
     			if(rs.next()){
     				//放置数据
     				SimpleDateFormat fmt= new SimpleDateFormat("yyyy-MM-dd");
     				JTFsname.setText(rs.getString("name"));
     				JTFsex.setText(rs.getString("sex"));
     				JTFsbirthday.setText(fmt.format(rs.getDate("birthday")));
       				JTFsmophone.setText(rs.getString("mophone"));
     				JTFsphone.setText(rs.getString("phone"));
     				JTFsdepartment.setText(rs.getString("department"));
     				JTFsaddress.setText(rs.getString("address"));
     				//设置数据保护
     				JTFsname.setEnabled(false);
     				JTFsex.setEnabled(true);
     				JTFsbirthday.setEnabled(true);
     				JTFsmophone.setEnabled(true);
     				JTFsphone.setEnabled(true);
     				JTFsdepartment.setEnabled(true);
     				JTFsaddress.setEnabled(true);
     				
     				//激活删除和重置按钮
     				JBlocator.setEnabled(false);
     				JBsubmit.setEnabled(true);
     				JBreset.setEnabled(true);
     			}else{
     				JOptionPane.showMessageDialog(null,"输入的学生记录不存在","输入的学生记录不存在",JOptionPane.INFORMATION_MESSAGE);
     			}
     		}catch (SQLException ex){
     			ex.printStackTrace();
     		}
     	}
     	//获得文本框内容
     	String name=JTFsname.getText();
     	String sex=JTFsex.getText();
     	String birthday=JTFsbirthday.getText();
     	String mophone=JTFsmophone.getText();
     	String phone=JTFsphone.getText();
     	String department=JTFsdepartment.getText();
     	String address=JTFsaddress.getText();
     	if(Command.equals("修改")){
     		//到数据库中修改数据
		String sqlup="update student set name='"+name+"',sex='"+sex+"',birthday='"+birthday+"',department='"+department+"'"+"where sno='"+sno+"'";
     		try{
     			mydata.executeUpdate(sqlup);
     		}catch(SQLException ex){
     			ex.printStackTrace();
     		}
     		reset();
     	}
     	if(Command.equals("重置")){
     		reset();
     	}
     }	
     	
     private void reset(){
     		JTFsno.setText("");
     		JTFsname.setText("");
     		JTFsex.setText("");
     		JTFsbirthday.setText("");
     		JTFsmophone.setText("");
     		JTFsphone.setText("");
     		JTFsdepartment.setText("");
     		JTFsaddress.setText("");

     		//设置按钮初始状态
     	    JBlocator.setEnabled(true);
     	    JBsubmit.setEnabled(false);
     	    JBreset.setEnabled(false);
     	}
     	}