sel_crouses.java

本网站为学生管理网站

package students;

import java.sql.ResultSet;
import java.sql.SQLException;

public class Sel_crouses {
	public String enrollyear(String str){
		String ss1=null;
		String sql="select enrollyear from students where ID='"+str+"'";
		ResultSet rs=UserDAO.select(sql);
		try {
			if(rs.next()){
				ss1=rs.getString("enrollyear");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return ss1;
	}
	public String[] cro_grade(){
		String[] ss2=new String [5];
		String sql="select cro_grade from crouses ";
		ResultSet rs=UserDAO.select(sql);
		try {
			int i=0;
			while(rs.next()){
				ss2[i]=rs.getString("cro_grade");
				i++;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return ss2;
	}
	public int[] cro_dropyear(){
		int[] ss3=new int [5];
		for(int m=0;m<5;m++){
			ss3[m]=3000;
		}
		String sql="select cro_dropyear from crouses ";
		ResultSet rs=UserDAO.select(sql);
		try {
			int i=0;
			while(rs.next()){
				String a;
				a=rs.getString("cro_dropyear");
				if(!a.equals("")){
					ss3[i]=Integer.parseInt(a);
				}
				i++;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return ss3;
	}
}