classallmarkblogicclass.java

关于学校管理

package student.manage.classAllMark;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import student.manage.course.CourseBean;
import student.manage.javaConnction.connectionDB;
import student.manage.mark.MarkBean;
import student.manage.mark.SuperBean;

public class ClassAllMarkBlogicClass {

	connectionDB db = new connectionDB();

	Statement state = null;

	ResultSet result = null;

	int insertNum = 0;

	public Statement getConn() {

		state = db.getConnectionDB();
		return state;
	}

	public ArrayList getAllInfo(SuperBean superBean) {

		String sql = "select * from RIKO_MARK where GRADE_ID = '"
				+ superBean.getMarkBean().getGRADE_ID() + "'";
		System.out.println(sql);
		
		String classnum = "";
		ArrayList list = new ArrayList();
		try {

			ResultSet rs = this.getConn().executeQuery(sql);
			while (rs.next()) {
				MarkBean bean = new MarkBean();
				bean.setCLASS_ID(rs.getString("CLASS_ID"));
				bean.setCOURSE_ID(rs.getString("COURSE_ID"));
				bean.setMARK(rs.getInt("MARK"));
				bean.setSECOND_MARK(rs.getInt("SECOND_MARK"));
				
				list.add(bean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public ArrayList getCourseNumInfo(SuperBean superBean) {

		String sql = "select * from RIKO_COURSE where GRADE_ID = '"
				+ superBean.getMarkBean().getGRADE_ID() + "'";
		System.out.println(sql);
		
		String classnum = "";
		ArrayList list = new ArrayList();
		try {

			ResultSet rs = this.getConn().executeQuery(sql);
			while (rs.next()) {
				CourseBean bean = new CourseBean();
				bean.setCOURSE_NAME(rs.getString("COURSE_NAME"));
				list.add(bean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public int getGradeId(SuperBean superBean) {

		String sql = "select CLASS_NUM from RIKO_GRADE where GRADE_ID = '"
				+ superBean.getMarkBean().getGRADE_ID() + "'";
		System.out.println(sql);
		int k = 0;
		String classnum = "";
		ArrayList list = new ArrayList();
		try {

			ResultSet rs = this.getConn().executeQuery(sql);
			while (rs.next()) {
				k = rs.getInt(1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return k;
	}
}