sort.java

简易通用Blog

package org.adam.bean;

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

import org.db.DB;

public class Sort {
	private int sort_id;
	private String sortname;
	private int blog_id;
	public int getBlog_id() {
		return blog_id;
	}
	public void setBlog_id(int blog_id) {
		this.blog_id = blog_id;
	}
	public int getSort_id() {
		return sort_id;
	}
	public void setSort_id(int sort_id) {
		this.sort_id = sort_id;
	}
	public String getSortname() {
		return sortname;
	}
	public void setSortname(String sortname) {
		this.sortname = sortname;
	}
	public static Vector getSorts(DB db,int blogid){
		Sort sort;
		Vector v=new Vector();
		String sql="select * from sort where blog_id="+blogid;
		//System.out.println(sql);
		try{
			ResultSet rs=db.getData(sql);
			while(rs.next()){
				sort=new Sort();
				sort.setBlog_id(rs.getInt("blog_id"));
				sort.setSort_id(rs.getInt("sort_id"));
				sort.setSortname(rs.getString("sortname"));
				v.add(sort);
			}
			db.closed();
			return v;
		}catch(Exception e){
			return null;
		}
	}
	public static Vector getSort(DB db,int blogid){
		Sort s;
		Vector v=new Vector();
		String sql="select * from sort where blog_id="+blogid;
		try{
			ResultSet rs=db.getData(sql);
			while(rs.next()){
				s=new Sort();
				s.setBlog_id(rs.getInt("blog_id"));
				s.setSort_id(rs.getInt("sort_id"));
				s.setSortname(rs.getString("sortname"));
				v.add(s);
			}
			db.closed();
			return v;
		}catch(SQLException e){
			return null;
		}
	}
}