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

public class HandSearchFrame extends JFrame
{
	JTextArea text=new JTextArea();
	JScrollPane pane=new JScrollPane(text);
	JTextField number=new JTextField(15);
	JButton button1=new JButton("OK");
	JButton button2=new JButton("Search All Student Information");

	public HandSearchFrame()
	{
		final JFrame frame=this;
		Container con=getContentPane();
		JPanel p1=new JPanel();
        p1.add(new JLabel("Input the phone number:"));
		p1.add(number);
		p1.add(button1);
        con.add(p1,BorderLayout.NORTH);
		con.add(pane,BorderLayout.CENTER);
		con.add(button2,BorderLayout.SOUTH);
		//text.setEditable(false);
		button1.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				if(e.getSource()==button1)
		       {
					text.setText("Result:"+'\n');
					try
				   {
						Liststudent1();
				   }
			       catch(SQLException ee)
				   {
				   }
			   }
			}
		});
		button2.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				if(e.getSource()==button2)
		       {
					text.setText("Result:"+'\n');
					try
				   {
						Liststudent2();
				   }
			       catch(SQLException ee)
				   {
				   }
			   }
			}
		});
		this.setBounds(150,150,400,300);
		this.setResizable(false);
		this.setTitle("HandSearch");
		this.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);
		this.show();
	}

	public void Liststudent1() throws SQLException
	{
		String stu_number,name,sex,age,department,classes,pho_number,qinshi,remark;
		int total=0;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e)
		{
		}
		Connection con=DriverManager.getConnection("jdbc:odbc:asan","","");
		Statement sql=con.createStatement();
		ResultSet rs=sql.executeQuery("SELECT * FROM student");
		total=rs.getRow();
		while(rs.next())
		{
			stu_number=rs.getString("stu_number");
			name=rs.getString("name");
			sex=rs.getString("sex");
			age=rs.getString("age");
			department=rs.getString("department");
			classes=rs.getString("class");
			pho_number=rs.getString("pho_number");
			qinshi=rs.getString("qinshi");
			remark=rs.getString("remark");
			if((pho_number.trim()).equals(number.getText().trim()))
			{
				text.append("******"+'\n'+"學號："+stu_number+'\n'+"姓名："+name+'\n'+"性別："+sex+'\n'+"年齡："+age+'\n'+"系別："+department+'\n'+"班級："+classes+'\n'+"電話："+pho_number+'\n'+"寢室："+qinshi+'\n'+"備注："+remark+'\n');
			}
		}
	}
    public void Liststudent2() throws SQLException
	{
		String stu_number,name,sex,age,department,classes,pho_number,qinshi,remark;
		int total=0;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e)
		{
		}
		Connection con=DriverManager.getConnection("jdbc:odbc:asan","","");
		Statement sql=con.createStatement();
		ResultSet rs=sql.executeQuery("SELECT * FROM student");
		while(rs.next())
		{
			stu_number=rs.getString("stu_number");
			name=rs.getString("name");
			sex=rs.getString("sex");
			age=rs.getString("age");
			department=rs.getString("department");
			classes=rs.getString("class");
			pho_number=rs.getString("pho_number");
			qinshi=rs.getString("qinshi");
			remark=rs.getString("remark");
			text.append("******"+'\n'+"學號："+stu_number+'\n'+"姓名："+name+'\n'+"性別："+sex+'\n'+"年齡："+age+'\n'+"系別："+department+'\n'+"班級："+classes+'\n'+"電話："+pho_number+'\n'+"寢室："+qinshi+'\n'+"備注："+remark+'\n');
			total++;
		}
		text.append("共查到學生："+total+"人"+"\n");
	}

	//public static void main(String args[])
	//{
		//HandSearchFrame f=new HandSearchFrame();
	//}			
}