package tools;

/*
 * 創建日期 2006-5-23
 * 作者： 褚廷軍
 * 項目名稱：學生考試系統；
 * 項目要求：畢業設計；
 * 模塊名稱：服務器端用戶管理模塊
 * 模塊功能：考試系統的服務端用戶管理界面,
 *           從數據庫中獲得用戶表，用JTable顯示，
 *           可以完成查看，刪除等基本操作
 *           
 * 更改所生成文件模板為
 * 窗口 > 首選項 > Java > 代碼生成 > 代碼和注釋
 */

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

class UserManage extends JPanel implements ActionListener
{
	
	private static final long serialVersionUID = -4236780873619163467L;
	Object a[][];          //創建二維數組對象，用來顯示表中的數據，因為表是二維的
	Object columnName[] = {"準考證號","考生姓名","考生密碼","考生班級","數學成績","英語成績","考試標記"};//用來顯示列名
	JTable table;
	JButton query,delete,advanced;
	JProgressBar p_bar;
	JLabel lab;
	JOptionPane op=new JOptionPane();
	String name,number,pass,sclass;
	Connection con;
	Statement stmt;
	ResultSet rs;
       
  //     String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=serverDB.mdb";//指定JDBC驅動程序
//	String url="sun.jdbc.odbc.JdbcOdbcDriver";
//	String strurl="jdbc:odbc:stutest";
	
	
	
	JPanel pan;
	int i;
	private String escore;
	private String mscore;
	private String flag;
	private String driver;
	private String url;
	private String user;
	private String password;
	
	UserManage()
	{
		lab=new JLabel("學生信息顯示",JLabel.CENTER);
		lab.setFont(new Font("楷體_GB2312",Font.PLAIN,18));
		lab.setForeground(Color.blue);
		a = new Object[30][8];
		table = new JTable(a,columnName);
		setSize(300,300);
		setVisible(true);
		try {
			Properties ps = new Properties();
			ps.load(getClass().getResourceAsStream("/db.properties"));
			this.driver = ps.getProperty("driver");
			this.url = ps.getProperty("url");
			this.user = ps.getProperty("user");
			this.password = ps.getProperty("password");
			System.out.println(driver);
			System.out.println(url);
			System.out.println(user);
			System.out.println(password);

		} catch (Exception e) {
			System.out.println(e);
		}
		
		
		try{
			  Class.forName(driver);
		   }
		catch(ClassNotFoundException e){}
		try{
			  con = DriverManager.getConnection(url,user,password);
			  stmt = con.createStatement();
		   }
		catch(SQLException ee){}
		
		query = new JButton("查看");query.addActionListener(this);
		delete=new JButton("刪除");delete.addActionListener(this);
		advanced=new JButton("高級");advanced.addActionListener(this);
		
	    pan=new JPanel();
		pan.setLayout(new FlowLayout());
		pan.add(query);
		pan.add(delete);
		pan.add(advanced);
		
		p_bar=new JProgressBar(JProgressBar.VERTICAL,0,10000);
		p_bar.setStringPainted(true);
		p_bar.setFont(new Font("宋體",Font.PLAIN,14));
		setLayout(new BorderLayout());
		add(lab,"North");
		add(pan,"South");
		add(new JScrollPane(table),"Center");
		add(p_bar,"West");
	}
    	
	public void update()
	{
        i=0;
		try 
		{
	        rs=stmt.executeQuery("select * from stuinfo");
	        while(rs.next())
	        {
	        	number=rs.getString(1);
	        	name=rs.getString(2);
	        	pass=rs.getString(3);
	        	sclass=rs.getString(4);
	        	escore=rs.getString(5);
	        	mscore=rs.getString(6);
	        	flag=rs.getString(7);
	        	a[i][0]=number;
	        	a[i][1]=name;
	        	a[i][2]=pass;
	        	a[i][3]=sclass;
	        	a[i][4]=escore;
	        	a[i][5]=mscore;
	        	a[i][6]=flag;
	        	i++;
	        	p_bar.setValue(i);
				p_bar.setString("共有"+i+"位考生");
	        }
			table.repaint();
	    }
	    catch (Exception ex) {}
	    table.repaint();
	}
	
	public void actionPerformed(ActionEvent e)
	{	
		if(e.getSource()==query)//選擇查看按紐
		{
            for (int i = 0; i<30; i++)
            {
	           for (int j = 0; j<6; j++)
	          	{
	          		a[i][j]=null;
	          	}
            }
            table.repaint();
		    update();
		}
		else if(e.getSource()==advanced)
		{
			new EditUser().setVisible(true);
		}
		else if(e.getSource()==delete)//選中刪除按紐
		{
			table.repaint();
	        if(table.getSelectedRow()==-1)
            {
               JOptionPane.showMessageDialog(this,"請先選中要刪除的考生!","信息提示",JOptionPane.INFORMATION_MESSAGE);
            }
			else if(table.getSelectedRow()<i)//返回首個選定行的索引，如果沒有選定的行，則返回 -1。
			{
		    String s=(String)table.getValueAt(table.getSelectedRow(),table.getSelectedColumnCount()-1);
			int m=JOptionPane.showConfirmDialog(this,"你確定刪除？","警告對話框",JOptionPane.YES_NO_OPTION);
			if(m==JOptionPane.YES_OPTION)
			{
				 try 
				 {  
			        Class.forName(driver); //加載指定的驅動程序
		            con=DriverManager.getConnection(url,"",""); //建立連接
		            stmt=con.createStatement();//發送SQL語句
			        stmt.executeUpdate("delete from stuinfo where sno='"+s+"'");
				 }
				 catch (Exception ex) { System.out.println(ex);}
	             for (int i = 0; i<30; i++)
	              {
	              	for (int j = 0; j<6; j++)
	              	{
	              		a[i][j]=null;
	              	}
	              }
				  table.repaint();
				  update();
				  JOptionPane.showMessageDialog(this,"刪除成功!","信息提示",JOptionPane.INFORMATION_MESSAGE);
			}
			else
			{
				op.setVisible(false);//設置警告框不可用
			}
		   }
		}	
	}
	
}