inforinsertjpanel.java

学生成绩管理系统

package myjava.javaSeries.java.compoent;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class InforInsertJpanel 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 JBsubmit=new JButton("插入");
	private JButton JBreset=new JButton("重置");

	//声明面板
	private JPanel JPLabels =new JPanel();
    private JPanel JPinputArea=new JPanel();
	private JPanel JPbutton =new JPanel();
    private JPanel JPconbine=new JPanel();    
	public InforInsertJpanel()
	{
      //建立放置标签的面板
	  JPLabels.setLayout(new GridLayout(5,1));
      JLnum.setHorizontalAlignment(SwingConstants.CENTER);
      JLname.setHorizontalAlignment(SwingConstants.CENTER);
      JLscore.setHorizontalAlignment(SwingConstants.CENTER);

      JPLabels.add(JLnum);
	  JPLabels.add(JLname);
	  JPLabels.add(JLscore);

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

      //建立组合放置标签和文本框的面板
	  JPconbine.setLayout(new GridLayout(1,2));
      JPconbine.add(JPLabels);
      JPconbine.add(JPinputArea);
	  
	  //建立放置按钮的面板
	  JPbutton.setLayout(new FlowLayout(FlowLayout.CENTER));
      JPbutton.add(JBsubmit);
      JPbutton.add(JBreset);

  
     //把面板放置到框架中
	  this.setLayout(new GridLayout(2,1));
	  this.add(JPconbine);
	  this.add(JPbutton);

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

	}
    public void actionPerformed(ActionEvent e)
	{
        
		if(e.getSource()==JBsubmit)
		{
			insertDB();//把数据插入数据库
		}
		else if(e.getSource()==JBreset)
			{
		    reset();
		    }
			
	}
	


	private void insertDB()
	{
		String num=JTnum.getText();
		String name=JTname.getText();
        float score=Float.parseFloat(JTscore.getText());
        
		//往数据库表中插入数据
		try{
		InforModelDB mydata=new InforModelDB(num,name,score);
		mydata.Insert();
        JOptionPane.showMessageDialog(null,"插入成功","消息",JOptionPane.INFORMATION_MESSAGE);
		}catch(SQLException e)
		{
           System.out.println("数据库操作出现问题");
		}
		catch(ClassNotFoundException e)
		{
			System.out.println("连接数据库操作的组件出现问题");
		}
	}

   private void reset()
	{
     JTnum.setText("");
	 JTname.setText("");
	 JTscore.setText("");
   }
}