updata.java

一个简单的选课系统的源代码,本人的数据库课程的作品.数据库用的是db2

package Student;
import java.awt.*;

import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
public class Updata extends JFrame{
	String ID;
	JLabel j=new JLabel();
	JLabel j1=new JLabel();
	JLabel j2=new JLabel();
	JLabel j3=new JLabel();
	JLabel j4=new JLabel();
	JLabel j5=new JLabel();
	JTextField jtf1=new JTextField(15);
	JTextField jtf2=new JTextField(15);
	JTextField jtf3=new JTextField(15);
	JTextField jtf4=new JTextField(15);
	JTextField jtf5=new JTextField(15);
	Container cp=this.getContentPane();
	JPanel p1=new JPanel();
	JPanel p2=new JPanel();
	JPanel p3=new JPanel();
	JButton b1=new JButton();
	JButton b2=new JButton();
	
	public Updata(String IDt)
	{
		ID=IDt;
		try{
			jbinit();
		}catch(Exception o){o.printStackTrace();}
	}
	private void jbinit()
	{
		j.setText("请填入以下信息");
		j.setForeground(Color.RED);
		j.setFont(new Font("SansSerif", Font.PLAIN, 16));
		p1.add(j);
		j1.setText("姓名(中文名)       ");
		j1.setForeground(Color.GREEN);
		j2.setText("年龄(数字)          ");
		j2.setForeground(Color.GREEN);
		j3.setText("性别(F(女)|M(男)))");
		j3.setForeground(Color.GREEN);
		j4.setText("院系编号(数字)     ");
		j4.setForeground(Color.GREEN);
		j5.setText("密码修改为           ");
		j5.setForeground(Color.GREEN);
		p2.setLayout(new FlowLayout());
		p2.add(j1);
		p2.add(jtf1);
		p2.add(j2);
		p2.add(jtf2);
		p2.add(j3);
		p2.add(jtf3);
		p2.add(j4);
		p2.add(jtf4);
		p2.add(j5);
		p2.add(jtf5);
		b1.setText("确认并提交");
		class UpdataCommit implements ActionListener
		{
			String ID;
			public UpdataCommit(String IDt)
			{
				ID=IDt;
			}
			public void actionPerformed(ActionEvent e)
			{
				int then;
				String sql;
				try{
					MyJDBC k=new MyJDBC();
					sql="update wengxinzhi.student set name='"+jtf1.getText()+"'"+
					",age="+jtf2.getText()+
					",sex='"+jtf3.getText()+"'"+
					",dep="+jtf4.getText()+
					",key='"+jtf5.getText()+"'"+
					"where sid='"+ID+"'";
					then=k.insert(sql);
					if(then>0)
					{
						JOptionPane.showMessageDialog(null,"数据提交成功");
					}
				}catch(Exception o){o.printStackTrace();
				JOptionPane.showMessageDialog(null,"数据提交失败");}
				
			}
		}
		b1.addActionListener(new UpdataCommit(ID));
		b2.setText("取消");
		b2.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				dispose();
			}
		});
		p3.add(b1);
		p3.add(b2);
		cp.setLayout(new BorderLayout());
		
		cp.add(p1,BorderLayout.NORTH);
		cp.add(p2,BorderLayout.CENTER);
		cp.add(p3,BorderLayout.SOUTH);
		this.setSize(300,300);
		this.setLocation(250,200);
		this.setVisible(true);
		this.setTitle("更新数据");
	}
}