denylist.java

2．打开“命令行提示符”； 3．输入mysql –u root - p命令

package com.ch9;

import java.sql.*;

public class denylist extends Execute_DB
{
	//定义类成员变量
	private long DenyID;
	private long UserID;  
	private long BoardID;   
	private String DenyTime; 
	private String strSql;
   
    //构造函数，对成员变量进行初始化赋值
	public denylist()
	{       
		this.DenyID=0;
		this.BoardID=0;
		this.UserID=0;    
		java.util.Date NowTime = new java.util.Date();
		this.DenyTime = NowTime.toLocaleString();    
		this.strSql="";
	}
   
	//添加新文章，往denylist数据表中添加一条新记录
	public boolean add_deny()
	{	
		this.strSql="insert into denylist ";
		this.strSql=this.strSql + "(UserID,BoardID,DenyTime) ";		
		this.strSql=this.strSql + "values('" + this.UserID + "','" + this.BoardID + "','" + this.DenyTime + "')";		
		boolean isAdd = super.exeSql(this.strSql);
		
		return isAdd;
	}

 	//获得根据UserID和BoardID获取对应的信息
	public boolean init()
	{
		this.strSql="select DenyTime from `denylist`";
        this.strSql=this.strSql + " where UserID = '" + this.UserID + "'";        
        this.strSql=this.strSql + " and BoardID = '" + this.BoardID + "' order by BoardID desc";        
	
		try
		{
			ResultSet rs = super.exeSqlQuery(this.strSql);
			if (rs.next())
			{
				this.DenyTime = rs.getString("DenyTime");
				return true;
			}	
			return false;	
		}
		catch(Exception ex)
		{
			System.out.println(ex.toString()); 
			return false;
		}     
	}
	
	//判断用户能否在某个讨论区发表文章
	public boolean isValid()
	{
		this.strSql="select DenyTime from `denylist`";
        this.strSql=this.strSql + " where UserID = '" + this.UserID + "'";        
        this.strSql=this.strSql + " and BoardID = '" + this.BoardID + "'";        
        this.strSql=this.strSql + " and DenyTime >'" + this.DenyTime + "'";        
		System.out.println(this.strSql); 
		try
		{
			ResultSet rs = super.exeSqlQuery(this.strSql);
			if (rs.next())
			{
				this.DenyTime = rs.getString("DenyTime");
				return true;
			}	
			return false;	
		}
		catch(Exception ex)
		{
			System.out.println(ex.toString()); 
			return false;
		}     
	}



  	//设置类成员变量DenyID的值
	public void setDenyID(long DenyID)
	{
		this.DenyID = DenyID;	
	}
   
	//获取类成员变量DenyID的值  
	public long getDenyID()
	{
		return this.DenyID;	
	}

	//设置类成员变量UserID的值 
	public void setUserID(long UserID)
	{
		this.UserID = UserID;	
	}

	//获取类成员变量UserID的值  
	public long getUserID()
	{
		return this.UserID;	
	}

	//设置类成员变量BoardID的值  
 	public void setBoardID(long BoardID)
	{
		this.BoardID = BoardID;	
	}
   
	//获取类成员变量BoardID的值  
	public long getBoardID()
	{
		return this.BoardID;	
	}

	//设置类成员变量DenyTime的值  
 	public void setDenyTime(String DenyTime)
	{
		this.DenyTime = DenyTime;	
	}
   
	//获取类成员变量DenyTime的值  
	public String getDenyTime()
	{
		return this.DenyTime;	
	}	
}