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

class BD_update extends JFrame implements ActionListener
{
	JLabel l=new JLabel("輸入宿舍ID:");
	JTextField tf=new JTextField();
	JButton b=new JButton("查詢");
	JTextArea ta=new JTextArea();
	Connection con;
	Statement sta;
	String conURL="jdbc:mysql://localhost/login?user=root&password=root";
	ResultSet r;
	
	BD_update()
	{
		super("宿舍信息查詢");
		setBounds(200,200,400,300);
		JPanel p=new JPanel();
		p.setLayout(new GridLayout(1,3));
		p.add(l);p.add(tf);p.add(b);
		setLayout(new BorderLayout());
		add(p,"North");
		add(ta,"Center");
		ConSql();
		b.addActionListener(this);
		setVisible(true);
	}
	public void actionPerformed(ActionEvent e) {
		ta.setText("");
		boolean_true();
		Select();
	}
	public void Select()
	{
		String s=tf.getText().trim();
		try{
			con=DriverManager.getConnection(conURL);
			r=sta.executeQuery("select * from dormitory");
			while(r.next())
			{
				String s1=r.getString("d_number");
			    int s2=r.getInt("d_count");
				int s3=r.getInt("d_all");
				boolean s4=r.getBoolean("d_true");
				
				if(s1.equals(s))
				{
					if(s2==4)
					{
						 PreparedStatement ps=con.prepareStatement("update dormitory set d_true=? where d_number=?");
						 ps.setBoolean(1, true);
						 ps.setString(2,""+s1+"");
						 ps.executeUpdate();
					}
					ta.setText("宿舍號"+"   "+"已住幾人"+"   "+"最多幾人"+"   "+"是否住滿");
				    ta.append("\n");
					ta.append( s1+"              "+s2+"               "+s3+"              "+s4);
					
				    break;
				}
			}
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
	}
	public void boolean_true()
	{
		String s=tf.getText().trim();
		try{
			con=DriverManager.getConnection(conURL);
			r=sta.executeQuery("select * from dormitory");
			while(r.next())
			{
				String s1=r.getString("d_number");
				int s2=r.getInt("d_count");
				int s3=r.getInt("d_all");
				boolean s4=r.getBoolean("d_true");
				if(s1.equals(s))
				{
					if(s2==4)
					{
						 PreparedStatement ps=con.prepareStatement("update dormitory set d_true=? where d_number=?");
						 ps.setBoolean(1, true);
						 ps.setString(2,""+s1+"");
						 ps.executeUpdate();
					}
				}
			}
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
	}
	public void ConSql()
	{
		try{
			Class.forName("com.mysql.jdbc.Driver");
			con=DriverManager.getConnection(conURL);
			sta=con.createStatement();
			r=sta.executeQuery("select * from dormitory");
		}
		catch(ClassNotFoundException e){
			e.printStackTrace();
		}
		catch(SQLException e){
			e.printStackTrace();
		}
	}
}