import java.awt.*;

import javax.swing.*;
import javax.swing.event.*;
import java.awt.event.*;
import java.sql.*;

class B_update extends JFrame implements ActionListener
{
	JLabel l1,l2,l3,l4,l,l1_1,l2_2,l3_3,l4_4;
	
	JButton b1,b2,b3;
	JTextField t1,t2,t3,t4,t;
	Connection con;
	Statement sta;
	String conURL="jdbc:mysql://localhost/login?user=root&password=root";
	B_update()
	{
		super("學(xué)生信息修改");
		setBounds(200,200,400,300);
		JPanel p=new JPanel();
		p.setBounds(230,230,340,240);
		JPanel p1=new JPanel();
		l=new JLabel("輸入學(xué)生學(xué)號(hào):");
		t=new JTextField();
		l1=new JLabel("姓名:");
		l2=new JLabel("學(xué)號(hào):");
		l3=new JLabel("性別:");
		l4=new JLabel("所在宿舍:");
		b3=new JButton("查詢");
		l1_1=new JLabel("注意:1~20個(gè)字符");
		l2_2=new JLabel("現(xiàn)在使用的學(xué)號(hào)");
		l3_3=new JLabel("填寫男或者女");
		l4_4=new JLabel("真實(shí)宿舍");
		t1=new JTextField();
		t2=new JTextField();
		t3=new JTextField();
		t4=new JTextField();
		p1.setLayout(new GridLayout(5,3));
		p1.add(l);p1.add(t);p1.add(b3);
		p1.add(l1);p1.add(t1);p1.add(l1_1);
		p1.add(l2);p1.add(t2);p1.add(l2_2);
		p1.add(l3);p1.add(t3);p1.add(l3_3);
		p1.add(l4);p1.add(t4);p1.add(l4_4);
		JPanel p2=new JPanel();
		b1=new JButton("提交");
		b2=new JButton("重置");
		p2.setLayout(new GridLayout(1,2));
		p2.add(b1);p2.add(b2);
		p.setLayout(new BorderLayout());
		p.add(p1,"Center");
		p.add(p2,"South");
		setLayout(new BorderLayout());
		add(p,"Center");
		this.setResizable(false);
		ConSql();
		b1.addActionListener(this);
		b2.addActionListener(this);
		b3.addActionListener(this);
		setVisible(true);
	}
	public void actionPerformed(ActionEvent e) {
		if(e.getSource()==b1)
		{
			Update();
		}
		else if(e.getSource()==b2)
		{
			t1.setText("");
			t2.setText("");
			t3.setText("");
			t4.setText("");
		}
		else if(e.getSource()==b3)
		{
			Select();
		}
	
	}
	public void Update()
	{
		String s1=t1.getText().trim();
		String s2=t2.getText().trim();
		String s3=t3.getText().trim();
		String s4=t4.getText().trim();
		String s=t.getText().trim();
		try{
			ResultSet rs=sta.executeQuery("select student.d_number,s_number,d_count,d_true from student,dormitory where student.d_number=dormitory.d_number");
			while(rs.next())
			{
				String sr=rs.getString("s_number");
				String sd=rs.getString("d_number");
				int sc=rs.getInt("d_count");
				boolean st=rs.getBoolean("d_true");
				if(sr.equals(s))
				{
					if(sd.equals(s4))
					{
						
					
					PreparedStatement ps=con.prepareStatement("update student set name=? where s_number=?");
					ps.setString(1, ""+s1+"");
					ps.setString(2, ""+s2+"");
					ps.executeUpdate();
					ps=con.prepareStatement("update student set s_number=? where name=?");
					ps.setString(1, ""+s2+"");
					ps.setString(2, ""+s1+"");
					ps.executeUpdate();
					ps=con.prepareStatement("update student set sex=? where s_number=?");
					ps.setString(1, ""+s3+"");
					ps.setString(2, ""+s2+"");
					ps.executeUpdate();
					ps=con.prepareStatement("update student set d_number=? where s_number=?");
					ps.setString(1, ""+s4+"");
					ps.setString(2, ""+s2+"");
					ps.executeUpdate();
					this.dispose();
					new JOptionPane().showMessageDialog(null, "修改成功");
					break;
					}
					else
					{
						
					}
				}
				else
				{
					t.setText("學(xué)號(hào)不存在或者學(xué)號(hào)錯(cuò)誤");
				}
			}
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
	}
	public void Select()
	{
		String s1=t.getText().trim();
		try
		{
			ResultSet rs=sta.executeQuery("select * from student");
			while(rs.next())
			{
				String s2=rs.getString("s_number");
				if(s2.equals(s1))
				{
					String s3=rs.getString("name");
					t1.setText(s3);
					t2.setText(s2);
					String s4=rs.getString("sex");
					t3.setText(s4);
					String s5=rs.getString("d_number");
					t4.setText(s5);
					t.setText(s2);
					break;
				}
				else
				{
					t.setText("沒(méi)有該學(xué)號(hào)");
				}
			}
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
	}
	public void ConSql()
	{
		try{
			Class.forName("com.mysql.jdbc.Driver");
			con=DriverManager.getConnection(conURL);
			sta=con.createStatement();
		}
		catch(ClassNotFoundException e){
			e.printStackTrace();
		}
		catch(SQLException e){
			e.printStackTrace();
		}
	}
}