infordeletejpanel.java

学生成绩管理系统

package myjava.javaSeries.java.compoent;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class InforDeleteJpanel extends JPanel implements ActionListener 
{
	//声明标签
	private JLabel JLnum=new JLabel("学    号");
	private JLabel JLname=new JLabel("姓    名");
	private JLabel JLscore=new JLabel("成    绩");

    //声明文本输入框
    private JTextField JTnum=new JTextField(10);
    private JTextField JTname=new JTextField(10);
	private JTextField JTscore=new JTextField(10);

	//声明按钮
    private JButton JBsearch=new JButton("查询");
	private JButton JBsubmit=new JButton("删除");
	private JButton JBreset=new JButton("重置");

	//声明面板
	private JPanel JPsearch =new JPanel();
	private JPanel JPlabels =new JPanel();
    private JPanel JPinputArea=new JPanel();
	private JPanel JPbutton =new JPanel();
    private JPanel JPconbine=new JPanel();

	public InforDeleteJpanel()
	{
		init();
	}
    public void init()
	{
	//建立放置定位信息的面版
	 JPsearch.setLayout(new FlowLayout());
	 JPsearch.add(JLnum);
     JPsearch.add(JTnum);
     JPsearch.add(JBsearch);

	  //建立放置标签的面板
	  JPlabels.setLayout(new GridLayout(2,1));
      JLname.setHorizontalAlignment(SwingConstants.CENTER);
      JLscore.setHorizontalAlignment(SwingConstants.CENTER);
	  JPlabels.add(JLname);
	  JPlabels.add(JLscore);

     //建立放置输入文本的面板
      JPinputArea.setLayout(new GridLayout(2,1));
	  JPinputArea.add(JTname);
      JPinputArea.add(JTscore);

      //建立组合放置标签和文本框的面板
	  JPconbine.setLayout(new GridLayout(1,2));
      JPconbine.add(JPlabels);
      JPconbine.add(JPinputArea);
	  
	  //建立放置按钮的面板
	  JPbutton.setLayout(new FlowLayout(FlowLayout.CENTER));
      JBsubmit.setEnabled(false);
	  JBreset.setEnabled(false);
      JPbutton.add(JBsubmit);
      JPbutton.add(JBreset);
  
     //把面板放置到框架中
	  this.setLayout(new GridLayout(3,1));
      this.add(JPsearch);
	  this.add(JPconbine);
	  this.add(JPbutton);

      //注册监听器
	  JBsearch.addActionListener(this);
	  JBsubmit.addActionListener(this);
      JBreset.addActionListener(this);
	}

    public void actionPerformed(ActionEvent e)
	{
		String num=JTnum.getText();
        String name=JTname.getText();
		InforModelDB mydata=null;
		try{
			mydata=new InforModelDB(num,name);
		}
		catch(SQLException ex)
		{
		ex.printStackTrace();
		}
		catch(ClassNotFoundException ex)
		{
		ex.printStackTrace();	
		}
        if(e.getSource()==JBsearch)
		{
			try{
				
				String sqlt="select * from students where num='"+num+"'";
				ResultSet rs=mydata.executeSelect(sqlt);
				if(rs.next())
				{
					JTname.setText(rs.getString("name"));
					JTname.setEnabled(false);
                    JTscore.setText(rs.getString("score"));
					JTscore.setEnabled(false);
					JBsearch.setEnabled(false);
	                JBsubmit.setEnabled(true);
                    JBreset.setEnabled(true);
				
				}
				else{
					JOptionPane.showMessageDialog(null,"输入的记录不存在","输入的记录不存在",JOptionPane.INFORMATION_MESSAGE);
				}
			}
			catch(SQLException ex)
			{
				ex.printStackTrace();
			}
		}
		if(e.getSource()==JBsubmit)
		{
			try{	
			float score=Float.parseFloat(JTscore.getText());
			mydata=new InforModelDB(num,name,score);
			mydata.Delete();
				JOptionPane.showMessageDialog(null,"删除成功","消息",JOptionPane.INFORMATION_MESSAGE);
			}catch(SQLException ex)
			{
				ex.printStackTrace();
			}
			catch(ClassNotFoundException ex)
		   {
		   ex.printStackTrace();	
		   }
			reset();
		}
	     if(e.getSource()==JBreset)
		{
		   reset();
		 }
	}

    private void reset()
    {
     JTnum.setText("");
	 JTname.setText("");
	 JTscore.setText("");
     JBsearch.setEnabled(true);
    JBsubmit.setEnabled(false);
    JBreset.setEnabled(false);
    }	
}