context.java

来自「类似于csdn的上传下载系统」· Java 代码 · 共 78 行

package org.adam.bean;

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

public class Context implements Serializable{
	private int context_id;
	private int download_id;
	private int usertable_id;
	private String context;
	private String username;
	public String getContext() {
		return context;
	}
	public void setContext(String context) {
		this.context = context;
	}
	public int getContext_id() {
		return context_id;
	}
	public void setContext_id(int context_id) {
		this.context_id = context_id;
	}
	public int getDownload_id() {
		return download_id;
	}
	public void setDownload_id(int download_id) {
		this.download_id = download_id;
	}
	public int getUsertable_id() {
		return usertable_id;
	}
	public void setUsertable_id(int usertable_id) {
		this.usertable_id = usertable_id;
	}
	public static Vector getContext(DB db,int download_id){
		String sql="select * from context c,download d,usertable u "+
					" where c.download_id=d.download_id and c.usertable_id=u.usertable_id"+
					" and c.download_id="+download_id;
		//System.out.println(sql);
		ResultSet rs=db.getData(sql);
		Context c;
		Vector v=new Vector();
		try {
			while(rs.next()){
				c=new Context();
				c.setContext(rs.getString("context"));
				c.setContext_id(rs.getInt("context_id"));
				c.setDownload_id(rs.getInt("download_id"));
				c.setUsertable_id(rs.getInt("usertable_id"));
				c.setUsername(rs.getString("username"));
				v.add(c);
			}
			db.closed();
			return v;
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return null;
		}
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public void addContext(DB db){
		String sql="insert into context(usertable_id,download_id,context) "+
					"values("+usertable_id+","+download_id+",'"+context+"')";
		//System.out.println(sql);
		db.Insert(sql);
		db.closed();
	}
}