download.java

类似于csdn的上传下载系统

package org.adam.bean;

import java.io.Serializable;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

public class Download implements Serializable{
	private int download_id;
	private String downname;
	private String introduction;
	private int sort_id;
	private int visitcount;
	private int usertable_id;
	private String sortname;
	private String username;
	private String uploadtime;
	public int getDownload_id() {
		return download_id;
	}
	public void setDownload_id(int download_id) {
		this.download_id = download_id;
	}
	public String getDownname() {
		return downname;
	}
	public void setDownname(String downname) {
		this.downname = downname;
	}
	public String getIntroduction() {
		return introduction;
	}
	public void setIntroduction(String introduction) {
		this.introduction = introduction;
	}
	public int getSort_id() {
		return sort_id;
	}
	public void setSort_id(int sort_id) {
		this.sort_id = sort_id;
	}
	public int getUsertable_id() {
		return usertable_id;
	}
	public void setUsertable_id(int usertable_id) {
		this.usertable_id = usertable_id;
	}
	public int getVisitcount() {
		return visitcount;
	}
	public void setVisitcount(int visitcount) {
		this.visitcount = visitcount;
	}
	public void insertdownload(DB db){
		String sql="insert into download(downname,introduction,sort_id,visitcount,usertable_id,uploadtime) values('"+
				   downname+"','"+introduction+"',"+sort_id+","+visitcount+","+usertable_id+",'"+uploadtime+"')";
		System.out.println(sql);
		db.Insert(sql);
		db.closed();
	}
	public static Vector getall(DB db){
		Vector v=new Vector();
		String sql="select * from download";
		Download down;
		ResultSet rs=db.getData(sql);
		try {
			while(rs.next()){
				down=new Download();
				down.setDownload_id(rs.getInt("download_id"));
				down.setDownname(rs.getString("downname"));
				down.setIntroduction(rs.getString("introduction"));
				down.setSort_id(rs.getInt("sort_id"));
				down.setUsertable_id(rs.getInt("usertable_id"));
				down.setVisitcount(rs.getInt("visitcount"));
				down.setUploadtime(rs.getString("uploadtime"));
				v.add(down);
			}
			db.closed();
			return v;
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			db.closed();
			System.out.println("aaaaa");
			return null;
		}
	}
	public static String getDownName(DB db,int download_id){
		String sql="select * from download where download_id="+download_id;
		String filename=null;
		ResultSet rs=db.getData(sql);
		try {
			while(rs.next()){
				filename=rs.getString("downname");
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		//System.out.println(filename);
		db.closed();
		return filename;
	}
	public String getSortname() {
		return sortname;
	}
	public void setSortname(String sortname) {
		this.sortname = sortname;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public static Download getDownload(DB db,int download_id){
		String sql="select* from download d,sort s, usertable u "+
					"where d.usertable_id=u.usertable_id and s.sort_id=d.sort_id "+
					"and d.download_id="+download_id;
		//System.out.println(sql);
		ResultSet rs=db.getData(sql);
		Download down=null;
		try {
			while(rs.next()){
				down=new Download();
				down.setDownload_id(rs.getInt("download_id"));
				down.setDownname(rs.getString("downname"));
				down.setIntroduction(rs.getString("introduction"));
				down.setSortname(rs.getString("sortname"));
				down.setUsername(rs.getString("username"));
				down.setVisitcount(rs.getInt("visitcount"));
				down.setUploadtime(rs.getString("uploadtime"));
			}
			db.closed();
			return down;
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			db.closed();
			return null;
		}
	}
	public static Vector getSelectResult(DB db,String selectname){
		String sql="select * from download where downname like '%"+selectname+"%'";
		//System.out.println(sql);
		Download down;
		Vector v=new Vector();
		ResultSet rs=db.getData(sql);
		try {
			while(rs.next()){
				down=new Download();
				down.setDownload_id(rs.getInt("download_id"));
				down.setDownname(rs.getString("downname"));
				down.setIntroduction(rs.getString("introduction"));
				//down.setSortname(rs.getString("sortname"));
				//down.setUsername(rs.getString("username"));
				v.add(down);
			}
			db.closed();
			return v;
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			db.closed();
			return null;
		}
	}
	public void updateVisitcount(DB db,int download_id){
		String sql="update download set visitcount="+visitcount+" where download_id="+download_id;
		//System.out.println(sql);
		db.Insert(sql);
		db.closed();
	}
	public static Vector getallDesc(DB db){
		Vector v=new Vector();
		String sql="select * from download order by visitcount desc limit 10";
		Download down;
		ResultSet rs=db.getData(sql);
		try {
			while(rs.next()){
				down=new Download();
				down.setDownload_id(rs.getInt("download_id"));
				down.setDownname(rs.getString("downname"));
				down.setIntroduction(rs.getString("introduction"));
				down.setSort_id(rs.getInt("sort_id"));
				down.setUsertable_id(rs.getInt("usertable_id"));
				down.setVisitcount(rs.getInt("visitcount"));
				down.setUploadtime(rs.getString("uploadtime"));
				v.add(down);
			}
			db.closed();
			return v;
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			db.closed();
			return null;
		}
	}
	public static Vector getDownListBySort(DB db,int sort_id){
		Vector v=new Vector();
		String sql="select * from download where sort_id="+sort_id;
		Download down;
		ResultSet rs=db.getData(sql);
		try {
			while(rs.next()){
				down=new Download();
				down.setDownload_id(rs.getInt("download_id"));
				down.setDownname(rs.getString("downname"));
				down.setIntroduction(rs.getString("introduction"));
				down.setSort_id(rs.getInt("sort_id"));
				down.setUsertable_id(rs.getInt("usertable_id"));
				down.setVisitcount(rs.getInt("visitcount"));
				down.setUploadtime(rs.getString("uploadtime"));
				v.add(down);
			}
			db.closed();
			return v;
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			db.closed();
			return null;
		}
	}
	public String getUploadtime() {
		return uploadtime;
	}
	public void setUploadtime(String uploadtime) {
		this.uploadtime = uploadtime;
	}
	public static Vector getNew(DB db){
		Vector v=new Vector();
		String sql="select * from download order by uploadtime desc limit 10";
		Download down;
		ResultSet rs=db.getData(sql);
		try {
			while(rs.next()){
				down=new Download();
				down.setDownload_id(rs.getInt("download_id"));
				down.setDownname(rs.getString("downname"));
				down.setIntroduction(rs.getString("introduction"));
				down.setSort_id(rs.getInt("sort_id"));
				down.setUsertable_id(rs.getInt("usertable_id"));
				down.setVisitcount(rs.getInt("visitcount"));
				down.setUploadtime(rs.getString("uploadtime"));
				v.add(down);
			}
			db.closed();
			return v;
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			db.closed();
			return null;
		}
	}
	public void delete(DB db,int download_id){
		String sql="delete from download where download_id="+download_id;
		String sql1="delete from context where download_id="+download_id;;
		db.Insert(sql);
		db.Insert(sql1);
		db.closed();
	}
}