managercoursefengye.java

选课系统,基于SSH2的选课系统,欢迎下载

package xiong.gang.student.bean;

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

import xiong.gang.dao.DataDAO;

public class ManagerCourseFengYe {
		private ResultSet re;
		private int alllpage;
		private int allrow;
		private int rowperpage=5;
		private int curpage=1;
		public int getAlllpage() {
			return alllpage;
		}
		public void setAlllpage(int alllpage) {
			this.alllpage = alllpage;
		}
		public int getAllrow() {
			return allrow;
		}
		public void setAllrow(int allrow) {
			this.allrow = allrow;
		}
		public int getCurpage() {
			return curpage;
		}
		public void setCurpage(int curpage) {
			this.curpage = curpage;
		}
		public int getRowperpage() {
			return rowperpage;
		}
		public void setRowperpage(int rowperpage) {
			this.rowperpage = rowperpage;
		}
		@SuppressWarnings("unchecked")
		public List managerCourse() throws SQLException{
			List list=new ArrayList();
			re=new DataDAO().managerCourse();
			re.last();
			allrow=re.getRow();
			if(allrow%rowperpage==0){
				alllpage=allrow/rowperpage;
			}else{
				alllpage=allrow/rowperpage+1;
			}
			if(curpage==1){
				re.beforeFirst();
			}else{
				re.absolute((curpage-1)*rowperpage);
			}
			int i=0;
//			cno;cname;ctno;ctname;cxibu;cjieshao;ctime;caddress;cxianxuanshu;cxianxuannianji;cselectednum;
			while(i<this.rowperpage&&re.next()){
				ManagerCourse databean=new ManagerCourse();
				databean.setCno(re.getString("c.cno"));
				databean.setCname(re.getString("c.cname"));
				databean.setCtno(re.getString("c.ctno"));
				databean.setCtname(re.getString("c.ctname"));
				databean.setCxibu(re.getString("c.cxibu"));
				databean.setCjieshao(re.getString("c.cjieshao"));
				databean.setCtime(re.getString("c.ctime"));
				databean.setCaddress(re.getString("c.caddress"));
				databean.setCxianxuanshu(re.getString("c.cxianxuanshu"));
				databean.setCxianxuannianji(re.getString("c.cxianxuannianji"));
				databean.setCselectednum(re.getString("c.cselectednum"));
				list.add(databean);
				++i;
			}
			//System.out.println(list.size());	
			return list;
		}
	}