stunocournoaction.java

java(Swing) access做的成绩管理系统

package edu.xscj.action;

import java.sql.*;
import java.util.*;

import edu.xscj.conn.*;

public class StuNoCourNoAction {
    Connection conn = null;
    Collection StuNoCollect;
    Collection CourNoCollect;

    public StuNoCourNoAction() {
        if (conn == null) {
            conn = ConnectDataBase.getConn();
        }
    }

    public void setConn() {
        if (conn == null) {
            conn = ConnectDataBase.getConn();
        }
    }

    public Collection getCourNoCollect() {
        return CourNoCollect;
    }

    public Collection getStuNoCollect() {
        return StuNoCollect;
    }

    public void setCourNoCollect(Collection CourNoCollect) {
        this.CourNoCollect = CourNoCollect;
    }

    public void setStuNoCollect(Collection StuNoCollect) {
        this.StuNoCollect = StuNoCollect;
    }

    public void stuNoCourNo() {
        Statement stmt = null;
        ResultSet rst = null;
        String sql = "select stuNo from student";
        String sql2 = "select courNo from course";
        Vector stuNo = new Vector();
        Vector courNo = new Vector();

        try {
            if (conn == null) {
                this.setConn();
            }
            stmt = conn.createStatement();
            rst = stmt.executeQuery(sql);
            while (rst.next()) {
                stuNo.add(rst.getString("stuNo"));
            }

            rst = stmt.executeQuery(sql2);
            while (rst.next()) {
                courNo.add(rst.getString("courNo"));
            }

            this.setStuNoCollect(stuNo);
            this.setCourNoCollect(courNo);

        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (rst != null) {
                    rst.close();
                }
                if (stmt != null) {
                    stmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }

        }
    }
    /*
        public static void main(String[] args) {
            StuNoCourNoAction t = new StuNoCourNoAction();
            t.stuNoCourNo();
            Iterator stuNo = t.getStuNoCollect().iterator();
            Iterator courNo = t.getCourNoCollect().iterator();
            System.out.println("学号！！！！！！！！！！！！！");
            while (stuNo.hasNext()) {
                String str = (String) stuNo.next();
                System.out.println(str);
            }
            System.out.println("课程号！！！！！！！！！！！！！");
            while (courNo.hasNext()) {
                String str = (String) courNo.next();
                System.out.println(str);
            }
            System.out.println("--------------------------");
        }*/
}