blog.java

简易通用Blog

package org.adam.bean;

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

import org.db.DB;

public class Blog {
	public static boolean flag=false;
	public static int Blog_ID;
	private int blog_id;
	private String blogname;
	private String username;
	private String password;
	private String email;
	private int visitcount;
	public int getBlog_id() {
		return blog_id;
	}
	public void setBlog_id(int blog_id) {
		this.blog_id = blog_id;
	}
	public String getBlogname() {
		return blogname;
	}
	public void setBlogname(String blogname) {
		this.blogname = blogname;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public int getVisitcount() {
		return visitcount;
	}
	public void setVisitcount(int visitcount) {
		this.visitcount = visitcount;
	}
	public static Vector getBlogs(DB db){
		Blog blog;
		ResultSet rs=null;
		Vector v=new Vector();		
		try{
			String sql="select * from blog order by visitcount desc limit 10 ";
			rs=db.getData(sql);
			while(rs.next()){
				blog=new Blog();
				blog.setBlog_id(rs.getInt("blog_id"));
				blog.setBlogname(rs.getString("blogname"));
				blog.setEmail(rs.getString("email"));
				blog.setPassword(rs.getString("password"));
				blog.setUsername(rs.getString("username"));
				blog.setVisitcount(rs.getInt("visitcount"));
				v.add(blog);
			}
			db.closed();
			return v;
		}catch(Exception e){
			return null;
		}
	}
	public void Regist(DB db){
		String sql="insert into blog(blogname,username,password,email,visitcount) value('"+blogname+"','"+username+"','"+password+"','"+email+"'"+visitcount+")";
		db.Insert(sql);
		db.closed();
	}
	public static void login(String username,String password,DB db){
		String sql="select * from blog where username='"+username+"'and password='"+password+"'";
		//System.out.println(sql);
		ResultSet rs=db.getData(sql);
		try {
			if(rs.next()){
				flag=true;
				Blog_ID=rs.getInt("blog_id");
			}
			db.closed();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			db.closed();
		}
	}
	public static Vector getBlog(int blogid,DB db){
		Blog blog;
		ResultSet rs=null;
		Vector v=new Vector();		
		try{
			String sql="select * from blog where blog_id="+blogid;
			rs=db.getData(sql);
			while(rs.next()){
				blog=new Blog();
				blog.setBlog_id(rs.getInt("blog_id"));
				blog.setBlogname(rs.getString("blogname"));
				blog.setEmail(rs.getString("email"));
				blog.setPassword(rs.getString("password"));
				blog.setUsername(rs.getString("username"));
				blog.setVisitcount(rs.getInt("visitcount"));
				v.add(blog);
			}
			db.closed();
			return v;
		}catch(Exception e){
			return null;
		}
	}
}