indexdaobean.java

基于Spring2.5的精品课程网站

package org.adam.dao.impl;

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

import org.adam.DataSource.DBControl;
import org.adam.bean.MessageBean;
import org.adam.bean.NewsBean;
import org.adam.bean.SubjectBean;
import org.adam.bean.UploadBean;
import org.adam.dao.IndexDAO;
@SuppressWarnings("unchecked")
public class IndexDAOBean implements IndexDAO {

	private DBControl db;
	
	public List<MessageBean> getIndexMessages() {
		String sql="select * from message order by message_id desc limit 5";
		ResultSet rs=db.getDataInfo(sql);
		MessageBean msg;
		List<MessageBean> list=new ArrayList<MessageBean>();
		try {
			while(rs.next()){
				msg=new MessageBean();
				msg.setMessage_id(rs.getInt("message_id"));
				msg.setStudent_id(rs.getInt("student_id"));
				msg.setTeacher_id(rs.getInt("teacher_id"));
				msg.setTitle(rs.getString("title"));
				msg.setMessage(rs.getString("message"));
				msg.setTime(rs.getString("time"));
				msg.setRemessage(rs.getString("remessage"));
				list.add(msg);
			}
			return list;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		}
	}

	public List<NewsBean> getIndexNews() {
		String sql="select * from news order by news_id desc limit 5";
		ResultSet rs=db.getDataInfo(sql);
		NewsBean news;
		List<NewsBean> list=new ArrayList<NewsBean>();
		try {
			while(rs.next()){
				news=new NewsBean();
				news.setNews_id(rs.getInt("news_id"));
				news.setNewstitle(rs.getString("newstitle"));
				news.setNews(rs.getString("news"));
				news.setNewstime(rs.getString("newstime"));
				list.add(news);
			}
			return list;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			return null;
		}finally{
			db.closeConnection();
		}		
	}

	public List<SubjectBean> getIndexSubjects() {
		String sql="select * from subject order by subject_id desc limit 5";
		ResultSet rs=db.getDataInfo(sql);
		SubjectBean subject;
		List<SubjectBean> list=new ArrayList<SubjectBean>();
		try {
			while(rs.next()){
				subject=new SubjectBean();
				subject.setSubject_id(rs.getInt("subject_id"));
				subject.setTeacher_id(rs.getInt("teacher_id"));
				subject.setSubjectname(rs.getString("subjectname"));
				subject.setSubjectcontext(rs.getString("subjectcontext"));
				list.add(subject);
			}
			return list;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		}
	}

	public List<UploadBean> getIndexUploads() {
		String sql="select * from upload order by upload_id desc limit 5";
		ResultSet rs=db.getDataInfo(sql);
		List<UploadBean> list=new ArrayList<UploadBean>();
		UploadBean upload;
		try {
			while(rs.next()){
				upload=new UploadBean();
				upload.setUpload_id(rs.getInt("upload_id"));
				upload.setSubject_id(rs.getInt("subject_id"));
				upload.setTeacher_id(rs.getInt("teacher_id"));
				String uploadname1=rs.getString("uploadname");
				upload.setUploadname(uploadname1.substring(17,uploadname1.length() ));
				upload.setUploadtime(rs.getString("uploadtime"));
				upload.setUploadlocation(rs.getString("uploadlocation"));
				list.add(upload);
			}
			return list;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		}
	}

	public DBControl getDb() {
		return db;
	}

	public void setDb(DBControl db) {
		this.db = db;
	}

	public List getAll() {
		List list=new ArrayList();
		
//		list.add(getIndexNews());
//		list.add(getIndexSubjects());
//		list.add(getIndexUploads());
		
		String sql="select * from news order by news_id desc limit 5";
		ResultSet rs=db.getDataInfo(sql);
		NewsBean news;
		List<NewsBean> listnews=new ArrayList<NewsBean>();
		try {
			while(rs.next()){
				news=new NewsBean();
				news.setNews_id(rs.getInt("news_id"));
				news.setNewstitle(rs.getString("newstitle"));
				news.setNews(rs.getString("news"));
				news.setNewstime(rs.getString("newstime"));
				listnews.add(news);
			}			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			
		}
		
		String sql1="select * from subject order by subject_id desc limit 5";
		ResultSet rs1=db.getDataInfo(sql1);
		SubjectBean subject;
		List<SubjectBean> listsubject=new ArrayList<SubjectBean>();
		try {
			while(rs1.next()){
				subject=new SubjectBean();
				subject.setSubject_id(rs1.getInt("subject_id"));
				subject.setTeacher_id(rs1.getInt("teacher_id"));
				subject.setSubjectname(rs1.getString("subjectname"));
				subject.setSubjectcontext(rs1.getString("subjectcontext"));
				listsubject.add(subject);
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			
		}
		String sql2="select * from upload order by upload_id desc limit 5";
		ResultSet rs2=db.getDataInfo(sql2);
		List<UploadBean> listupload=new ArrayList<UploadBean>();
		UploadBean upload;
		try {
			while(rs2.next()){
				upload=new UploadBean();
				upload.setUpload_id(rs2.getInt("upload_id"));
				upload.setSubject_id(rs2.getInt("subject_id"));
				upload.setTeacher_id(rs2.getInt("teacher_id"));
				String uploadname1=rs2.getString("uploadname");
				upload.setUploadname(uploadname1.substring(17,uploadname1.length() ));
				upload.setUploadtime(rs2.getString("uploadtime"));
				upload.setUploadlocation(rs2.getString("uploadlocation"));
				listupload.add(upload);
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		list.add(listnews);
		list.add(listsubject);
		list.add(listupload);
		db.closeConnection();
		return list;
	}

}