pane3.java

通过数据库录入学生数据信息

package pane_delete;

import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;

import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;

import pane_dxdialog.Dxdialog;
import stu.Stu;


@SuppressWarnings("serial")
public class Pane3 extends JPanel implements ActionListener
{
	JPanel p1=new JPanel();
	JPanel p2=new JPanel();
	JPanel p3=new JPanel();
	JPanel p4=new JPanel();
	JPanel p5=new JPanel();
	JLabel al1=new JLabel("学号：");
	JLabel al2=new JLabel("姓名：");
	JLabel al3=new JLabel("性别：");
	JLabel al4=new JLabel("班级：");
	JLabel al5=new JLabel("出生日期：");
	JLabel al6=new JLabel("民族：");
	JLabel al7=new JLabel("籍贯：");
	JLabel al8=new JLabel("学号不可更改，其他内容均可更改。");
	Object items[]=new Object[Stu.N1];
	Object ite[]={"男","女"};
	JTextField atf1=new JTextField(10);
	JTextField atf2=new JTextField(10);
	JComboBox atf3=new JComboBox(ite);
	JComboBox atf4;
	JTextField atf5=new JTextField(10);
	JTextField atf6=new JTextField(10);
	JTextField atf7=new JTextField(28);
	JButton b1=new JButton("保存");
	JButton b2=new JButton("继续");
	JButton b3=new JButton("退出");
	
    public Pane3(String s1,String s2,String s3,String s4,String s5,String s6,String s7)
	
	{
		//修改信息界面
		setLayout(new GridLayout(9,1));
		b2.setEnabled(false);
		b1.addActionListener(this);
		b2.addActionListener(this);
		b3.addActionListener(this);
		for(int i=0;i<Stu.N1;i++)
		{
			items[i]=(i+1)+"班            ";
			
			
		}
		atf4=new JComboBox(items);
		atf1.setText(s3);
		atf1.setEditable(false);
		atf2.setText(s1);
		int index;
		if(s4.trim().equals("男"))
		{
			index=0;
		}
		else
		{
			index=1;
		}
		atf3.setSelectedIndex(index);
		atf4.setSelectedIndex(Integer.parseInt(s2.substring(0,1))-1);
		atf5.setText(s6);
		atf6.setText(s5);
		atf7.setText(s7);
		p1.add(al1);
		p1.add(atf1);
		p1.add(al2);
		p1.add(atf2);
		p2.add(al3);
		p2.add(atf3);
		p2.add(al4);
		p2.add(atf4);
		p3.add(al5);
		p3.add(atf5);
		p3.add(al6);
		p3.add(atf6);
		p4.add(al7);
		p4.add(atf7);
		p5.add(b1);
		p5.add(b2);
		p5.add(b3);
		add(al8);
		add(new JPanel());
		add(p1);
		add(p2);
		add(p3);
		add(p4);
		add(p5);
	    add(new JPanel());
	    add(new JPanel());
	}

	public Pane3() {
		// TODO 自动生成构造函数存根
	}

	public void actionPerformed(ActionEvent e)
	
	{
		//添加信息的处理
		if(e.getSource()==b1)
		{
			if((!atf2.getText().trim().equals(""))&&(!atf3.getSelectedItem().equals(""))
					&& (!atf4.getSelectedItem().equals(""))&&(!atf5.getText().trim().equals(""))&&(!atf6.getText().trim().equals(""))
					&&(!atf7.getText().trim().equals("")))
			{
				String temp3="update 学生管理系统.dbo.学生基本信息 SETName='"+atf2.getText().trim()+"',Sex="
				+atf3.getSelectedItem().toString().trim()+"',Ethnic='"+atf6.getText().trim()+"',Class='"
				+atf4.getSelectedItem().toString().trim()+"',Brithday='"+atf5.getText().trim()
				+"',Home='"+atf7.getText().trim()+"'where Num='"+Integer.parseInt(atf1.getText().trim())+"'";
				try
				{
					Stu.pstmt = Stu.conn.prepareStatement(temp3);
					Stu.pstmt.executeUpdate();
				    al8.setText("修改成功，已更新数据库中的该记录！");
				    //Stu.conn.close();
				    b1.setEnabled(false);
				    b2.setEnabled(true);
				    b3.setEnabled(true);
				    
				    
				
				}catch(SQLException ee)
				{
					System.out.println(ee.toString());
					
				}
			}
				else
				{
					al8.setText("所有内容都不能为空！请重新输入....");
					
				}
		}
		if(e.getSource()==b2)
		{
			@SuppressWarnings("unused")
			Dxdialog dx=new Dxdialog(Stu.st,"修改信息");
						
		}
		if(e.getSource()==b3)
		{
			Stu.car.show(Stu.p, "1");
	
		}
	}	
}