import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.table.*;
import java.sql.ResultSet;
import java.io.*; 
 //查詢窗體
     /////////////////////////////////////////////////////////////////////////////
     ////////////////////////////////////////////////////////////////////////////////
     class chaxun extends JFrame implements ActionListener,ItemListener{

	JLabel lb1=new JLabel("獎學金信息查詢");
   	JLabel lb2=new JLabel("學    號：");
   	JLabel lb3=new JLabel("姓    名：");
   	JLabel lb4=new JLabel("專業班級：");
   	JTextField setxtid=new JTextField(10);
   	JComboBox setxtclass=new JComboBox();
   	JTextField setxtname=new JTextField(10);
   	JTextField getclass=new JTextField(10);
   	JButton btn1=new JButton("查詢");

   	JTable table;
	DefaultTableModel dtm;
	String columns[] = {"學號","姓名","專業班級","智育成績","綜合測評","獎學金等級"};
	Object body[][]=new Object[50][6];
	
	Connection con;
    Statement stmt;
    ResultSet rs;
	public chaxun(){
		setTitle("信 息 查 詢");
		table = new JTable(body,columns);
        JScrollPane sl = new JScrollPane(table);
		
		getContentPane().setLayout(null);
		lb1.setBounds(280,10,300,30);
		lb1.setFont(new Font("宋體",Font.BOLD,30));
                lb1.setForeground(new Color(255, 0, 0));
		getContentPane().add(lb1);

		Font f=new Font("宋體",Font.PLAIN,12);
		lb2.setBounds(10,60,80,25);
		lb2.setFont(f);
		getContentPane().add(lb2);
		setxtid.setBounds(80,60,85,23);
		setxtid.setFont(f);
		getContentPane().add(setxtid);
		lb3.setBounds(10,90,80,25);
		lb3.setFont(f);
   	    getContentPane().add(lb3);
   	    lb4.setBounds(10,120,80,25);
		lb4.setFont(f);
   	    getContentPane().add(lb4);
   	    setxtname.setBounds(80,90,85,23);
   	    setxtname.setFont(f);
   	    getContentPane().add(setxtname);
    	setxtclass.addItem("計算機1班");
		setxtclass.addItem("計算機2班");
		setxtclass.addItem("計算機3班");
		setxtclass.addItem("計算機4班");
		setxtclass.addItemListener(this);
		setxtclass.setBounds(80,120,85,23);
		setxtclass.setFont(f);
		getContentPane().add(setxtclass);
		getclass.setBounds(80,150,85,23);
   	    getclass.setFont(f);
   	    getContentPane().add(getclass);
   	    btn1.setBounds(90,210,60,25);
   	    btn1.setFont(f);
   	    getContentPane().add(btn1);
   	    btn1.addActionListener(this);

		sl.setBounds(180,60,600,350);
		getContentPane().add(sl);

//設置邊框
		setxtid.setBorder(BorderFactory.createLineBorder(Color.black));
   	    setxtname.setBorder(BorderFactory.createLineBorder(Color.black));
   	    setxtclass.setBorder(BorderFactory.createLineBorder(Color.black));
   	    btn1.setBorder(BorderFactory.createRaisedBevelBorder());
		sl.setBorder(BorderFactory.createLineBorder(Color.black));
		Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        setBounds((screenSize.width-803)/2, (screenSize.height-629)/2, 800,480);
		//setSize(630,400);
		setVisible(true);
        //this.connection();
		}
public void itemStateChanged(ItemEvent e){
	String s=(setxtclass.getSelectedItem()).toString();
	getclass.setText(s);
	
	}			

public void actionPerformed(ActionEvent evt){
	if(evt.getSource()==btn1){
		if(setxtid.getText().equals("")&&setxtname.getText().equals("")&&setxtclass.getSelectedItem().equals(""))
		     new JOptionPane().showMessageDialog(null,"無效查詢條件！");
   try{ 
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        con=DriverManager.getConnection("jdbc:odbc:studentscore");
        stmt = con.createStatement();
    	rs=stmt.executeQuery("select * from studentscore where 學號 = '" + setxtid.getText() +"' or 姓名 = '" + setxtname.getText() +"' or 專業班級 = '" + getclass.getText() +"'");}
    	
    catch(Exception e){System.out.println(e.getMessage());}
    
		 try{for(int x=0;x<body.length;x++){
            body[x][0]=null;
            body[x][1]=null;
            body[x][2]=null;
            body[x][3]=null;
            body[x][4]=null;
            body[x][5]=null;

            
            }
           int i=0;
           while(rs.next()) 
  	        {   
	            
            body[i][0]=rs.getString(1);
            body[i][1]=rs.getString(2);
            body[i][2]=rs.getString(3);
            body[i][3]=rs.getString(12);
            body[i][4]=rs.getString(13);
            body[i][5]=rs.getString(14);
            
            i++;
	        }
	        table.validate(); 
            table.repaint();
            setxtid.setText("");
            setxtname.setText("");
            getclass.setText("");
	        con.close();
	        } 
	        catch(SQLException ex){System.out.println(ex.getMessage());}
	        	}
	       
}
		 
}