package xscjgl;
import javax.swing.JOptionPane;
import java.awt.*;
import xscjgl.*;
import javax.swing.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import com.borland.dbswing.JdbTable;
import com.borland.dbswing.JdbTextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dx.sql.dataset.Load;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dx.sql.dataset.ConnectionDescriptor;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import java.sql.ResultSet;
import javax.swing.BorderFactory;
import com.borland.dbswing.TableScrollPane;

/**
 * <p>Title: java course design</p>
 *
 * <p>Description:學生選課、查成績，教師輸成績。管理員管理。三種權限的教務管理系統 </p>
 *
 * <p>Copyright: lzquan (c) 2006</p>
 *
 * <p>Company:lzquan </p>
 *
 * @author 04級計算機教育班 李政權
 * @version 1.0
 */
public class Query_Grade_Frame extends JFrame {
    XYLayout xYLayout1 = new XYLayout();
    JPanel jPanel1 = new JPanel();
    XYLayout xYLayout2 = new XYLayout();
    Database database1 = new Database();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField jTextField2 = new JTextField();
    JdbTextField jdbTextField1 = new JdbTextField();
    JdbTextField jdbTextField2 = new JdbTextField();
    JButton jButton1 = new JButton();
    JPanel jPanel2 = new JPanel();
    XYLayout xYLayout3 = new XYLayout();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    public String SNO;
    public String countAvg;
    public String countSum;
    public int countStudent;
    JLabel jLabel9 = new JLabel();
    JdbTextField jdbTextField3 = new JdbTextField();
    TableScrollPane tableScrollPane1 = new TableScrollPane();
    JdbTable jdbTable1 = new JdbTable();
    public Query_Grade_Frame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(xYLayout1);
        this.setSize(new Dimension(540,450));
        setTitle("學生成績查詢窗體");
        xYLayout1.setWidth(561);
        xYLayout1.setHeight(469);
        jPanel1.setBackground(new Color(227, 241, 255));
        jPanel1.setBorder(BorderFactory.createLoweredBevelBorder());
        jPanel1.setLayout(xYLayout2);
        this.getContentPane().setBackground(new Color(248, 249, 244));

        database1.setConnection(new ConnectionDescriptor("jdbc:odbc:mydb",
                "tqti", "111111", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
         database1.setDatabaseName("");
         queryDataSet1.setQuery(new QueryDescriptor(database1,
                "select * from gradeQuery where Sno='200440914115'", null, true, Load.ALL));
        jLabel1.setText("您的成績如下：");
        jLabel2.setToolTipText("");
        jLabel2.setText("總分為：");
        jTextField1.setText("jTextField1");
        jLabel3.setText("平均分：");
        jLabel4.setText("單科信息：");
        jTextField2.setText("jTextField2");
        jdbTextField1.setText("jdbTextField1");
        jdbTextField1.setColumnName("Cname");
        jdbTextField1.setDataSet(queryDataSet1);
        jdbTextField2.setText("jdbTextField2");
        jdbTextField2.setColumnName("Cgrade");
        jdbTextField2.setDataSet(queryDataSet1);
        jButton1.setText("單科排名");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(ActionEvent e) {
                jButton1_actionPerformed(e);
            }
        });

        jPanel2.setLayout(xYLayout3);
        jLabel5.setText("課 程 名：");
        jLabel6.setText("課程分數：");
        jLabel7.setText("統計信息：");
        jLabel9.setText("課 程 號：");
        jdbTextField3.setText("jdbTextField3");
        jdbTextField3.setColumnName("Cno");
        jdbTextField3.setDataSet(queryDataSet1);
        jPanel2.setBackground(new Color(236, 241, 255));
        jPanel2.setBorder(BorderFactory.createEtchedBorder());
        jdbTable1.setDataSet(queryDataSet1);

        this.getContentPane().add(jLabel1, new XYConstraints(20, 20, -1, -1));
        jPanel2.add(jdbTextField1, new XYConstraints(84, 67, 108, -1));
        jPanel2.add(jLabel6, new XYConstraints(18, 100, -1, -1));
        jPanel2.add(jLabel5, new XYConstraints(18, 70, -1, -1));
        jPanel2.add(jdbTextField2, new XYConstraints(84, 97, 107, -1));
        jPanel2.add(jLabel9, new XYConstraints(18, 43, -1, -1));
        jPanel2.add(jdbTextField3, new XYConstraints(84, 40, 107, -1));
        jPanel2.add(jButton1, new XYConstraints(103, 9, -1, -1));
        jPanel2.add(jLabel4, new XYConstraints(18, 13, -1, -1));
        jPanel2.add(jLabel7, new XYConstraints(300, 17, -1, -1));
        jPanel2.add(jTextField2, new XYConstraints(366, 64, 107, -1));
        jPanel2.add(jTextField1, new XYConstraints(366, 35, 107, -1));
        jPanel2.add(jLabel3, new XYConstraints(300, 67, -1, -1));
        jPanel2.add(jLabel2, new XYConstraints(300, 38, -1, -1));
        tableScrollPane1.getViewport().add(jdbTable1);

        this.getContentPane().add(jPanel2, new XYConstraints(14, 41, 545, 136));
        jPanel1.add(tableScrollPane1, new XYConstraints(3, 7, 535, 233));
        this.getContentPane().add(jPanel1, new XYConstraints(14, 188, 545, 260));

    }



       public static void main(String args[]){
        Query_Grade_Frame queryGrade=new Query_Grade_Frame();
        queryGrade.setVisible(true);
        queryGrade.setLocationRelativeTo(null);
        //queryGrade.setSize(new Dimension(560,450));


    }
      //******************求平均分****************
       public  void setStudentAvg(String Snumber){
           try{
           Jdbcconn  getRow= new Jdbcconn();
           getRow.OpenConn("course_design","sa","zjxy2006");
           String countSQL="select * from SC where Cno=''";
           ResultSet gs=getRow.getResults(countSQL);
           gs.last();
           countStudent=gs.getRow();
          }catch(Exception ex){
          System.out.println(ex.getMessage());
          countStudent=0;
          }




       }

    public void jButton1_actionPerformed(ActionEvent e) {
        String CNO=jdbTextField3.getText().trim().toString();
        Grade_CountInformation order = new Grade_CountInformation();
        order.setSubjectOrder(CNO,SNO);
        //排名
        int subjectOrder=order.getsubjectOrder();
        //該門課程的學生數目
        int sutdentCount=order.getCountStudent();
        JOptionPane.showMessageDialog(null,"共有"+sutdentCount+"名學生學習了該課程，\n你是第"+subjectOrder+"名！");
    }




}