sort.java

类似于csdn的上传下载系统

package org.adam.bean;

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

public class Sort implements Serializable{
	private int sort_id;
	private String sortname;
	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 getSort(DB db){
		Vector v=new Vector();
		String sql="select* from sort";
		Sort s;
		ResultSet rs=db.getData(sql);
		try {
			while(rs.next()){
				s=new Sort();
				s.setSort_id(rs.getInt("sort_id"));
				s.setSortname(rs.getString("sortname"));
				v.add(s);				
			}
			db.closed();
			return v;
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return null;
		}		
	}
	public void addSort(DB db){
		String sql="insert into sort(sortname) values('"+sortname+"')";
		db.Insert(sql);
		db.closed();
	}
	public void updateSort(DB db){
		String sql="update sort set sortname='"+sortname+"' where sort_id="+sort_id;
		db.Insert(sql);
		db.closed();
	}
}