uploaddaobean.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.UploadBean;
import org.adam.dao.UploadDAO;

public class UploadDAOBean implements UploadDAO {

	private DBControl db;
	
	public void delete(int upload_id) {
		String sql="delete from upload where upload_id="+upload_id;
		db.setDataInfo(sql);
	}

	public UploadBean getUploadResource(int upload_id) {
		String sql="select * from upload where upload_id="+upload_id;
		ResultSet rs=db.getDataInfo(sql);
		UploadBean upload=new UploadBean();
		try {
			while(rs.next()){
				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"));				
			}
			return upload;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		}
	}

	public List<UploadBean> getUploadResources() {
		String sql="select * from upload";
		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"));
				upload.setUploadname(rs.getString("uploadname"));
				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 void upload(UploadBean upload) {
		String sql="insert into upload(subject_id,teacher_id,uploadname,uploadtime,uploadlocation) values("+
					upload.getSubject_id()+","+upload.getTeacher_id()+",'"+upload.getUploadname()+"','"+upload.getUploadtime()+"','"+upload.getUploadlocation()+"')";
		//System.out.println(sql);
		db.setDataInfo(sql);
	}

	public DBControl getDb() {
		return db;
	}

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

	public List<UploadBean> getUploadResourcesByName(String uploadname) {
		String sql="select * from upload where uploadname like '%"+uploadname+"%'";
		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 List<UploadBean> getUploadResourcesByTeacher(String teachername) {
		String sql="select * from upload,teacher where upload.teacher_id=teacher.teacher_id and teacher.teachername like '%"+teachername+"%'";
		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 List<UploadBean> getUploadResourcesBySubject(int subject_id) {
		String sql="select * from upload where subject_id="+subject_id;
		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 UploadBean getDownloadResource(int upload_id) {
		String sql="select * from upload where upload_id="+upload_id;
		ResultSet rs=db.getDataInfo(sql);
		UploadBean upload=new UploadBean();
		try {
			while(rs.next()){
				upload.setUpload_id(rs.getInt("upload_id"));
				upload.setSubject_id(rs.getInt("subject_id"));
				upload.setTeacher_id(rs.getInt("teacher_id"));
				upload.setUploadname(rs.getString("uploadname"));
				upload.setUploadtime(rs.getString("uploadtime"));
				upload.setUploadlocation(rs.getString("uploadlocation"));				
			}
			return upload;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		}
	}

	public List<UploadBean> getUploadResources(int nowpage, int pagecount) {
		String sql="select * from upload limit "+(nowpage-1)*pagecount+","+pagecount;
		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 int uploadCount() {
		String sql="select count(upload_id) as id from upload";
		ResultSet rs=db.getDataInfo(sql);
		int number=0;
		try {
			while(rs.next()){
				number=rs.getInt("id");
			}
			return number;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return 0;
		}finally{
			db.closeConnection();
		}
	}

	public List<UploadBean> getUploadResourcesBySubject(String subjectname) {
		String sql="select * from upload,subject where upload.subject_id=subject.subject_id and subject.subjectname like '%"+subjectname+"%'";
		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();
		}
	}

}