www.pudn.com > students.rar > 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; 
	} 
}