boards.java

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

package com.ch9;

import java.sql.*;

public class boards extends Execute_DB
{
	//定义类成员变量
	private long BoardID;
	private String BoardName;
	private String BoardMaster1; 
	private String BoardMaster2;  
	private String BoardMaster3;      
	private String strSql;
    
    //构造函数，对成员变量进行初始化赋值
	public boards()
	{       
		this.BoardID=0;
		this.BoardName="";
		this.BoardMaster1=""; 
		this.BoardMaster2="";		       
		this.BoardMaster3="";
		this.strSql="";
	}   
  
	//添加新讨论区，往boards数据表中添加一条新记录
	public boolean add_board()
	{
	    
		this.strSql="insert into boards ";
		this.strSql=this.strSql + "(BoardName,BoardMaster1,BoardMaster2,BoardMaster3) ";        
		this.strSql=this.strSql + "values('" + this.BoardName + "','" + this.BoardMaster1 + "','" + this.BoardMaster2 + "','" + this.BoardMaster3 + "')";
		boolean isAdd = super.exeSql(this.strSql);
		
		return isAdd;
	}
   
	//修改BoardID对应的讨论区的信息
	public boolean modify_board()
	{
		this.strSql="update boards set";
		this.strSql=this.strSql + " BoardName=" + "'" + this.BoardName + "',";	
		this.strSql=this.strSql + " BoardMaster1=" + "'" + this.BoardMaster1 + "',";
		this.strSql=this.strSql + " BoardMaster2=" + "'" + this.BoardMaster2 + "',";
		this.strSql=this.strSql + " BoardMaster3=" + "'" + this.BoardMaster3 + "'";
		this.strSql=this.strSql + " where BoardID='" + this.BoardID + "'";
		boolean isUpdate = super.exeSql(this.strSql);
		
		return isUpdate;
	}
	
	//删除属于某个集合中的讨论区信息
	public boolean delete_board(String s_BoardID)
	{
		this.strSql="delete from boards";
		this.strSql=this.strSql + "  where BoardID in ("+s_BoardID+")";
		
		boolean isDelete = super.exeSql(this.strSql);      
		return isDelete;	
	}

	
   
 	//获得BoardID对应的讨论区的信息，将这些信息赋值给相应的类变量
	public boolean init()
	{
		this.strSql="select * from `boards` where BoardID=";
		this.strSql=this.strSql + "'" + this.BoardID + "'";        
		try
		{
			ResultSet rs = super.exeSqlQuery(this.strSql);
			if (rs.next())
			{
				this.BoardID=rs.getLong("BoardID");
				this.BoardName=rs.getString("BoardName");
				this.BoardMaster1=rs.getString("BoardMaster1");
				this.BoardMaster2=rs.getString("BoardMaster2"); 				
				this.BoardMaster3=rs.getString("BoardMaster3");
				return true;
			}
			else
			{
				return false;
			}
		}
		catch(Exception ex)
		{
			System.out.println(ex.toString());            
			return false;
		}        
	}

 	//判断讨论区名是否存在
	public boolean is_exist()
	{
		this.strSql="select * from `boards` ";
		this.strSql=this.strSql + " where BoardName='" + this.BoardName + "'";	
		System.out.println(strSql);  
		try
		{
			ResultSet rs = super.exeSqlQuery(this.strSql); 
			if (rs.next())
			{
				return true;
			}
			else
			{		        
				return false;		
			}		
		}
		catch(Exception ex)
		{		    
			return false;
		}
	
	}
 
	//获得所有讨论区信息，返回一个ResultSet对象
	public ResultSet show_all_boards()
	{
		this.strSql="select * from `boards` order by BoardName asc";
		ResultSet rs = null;              
		try
		{
			rs = super.exeSqlQuery(this.strSql); 
		}
		catch(Exception ex)
		{
			System.out.println(ex.toString()); 
		}
		return rs;	    
	}
	
	//获得所有讨论区信息，返回一个ResultSet对象
	public ResultSet search_boards(String BoardName)
	{
		this.strSql="select * from `boards` where BoardName like '%"+BoardName+"%'";
		System.out.println(this.strSql);
		ResultSet rs = null;              
		try
		{
			rs = super.exeSqlQuery(this.strSql); 
		}
		catch(Exception ex)
		{
			System.out.println(ex.toString()); 
		}
		return rs;	    
	}
	
	//设置类成员变量BoardID的值
	public void setBoardID(long BoardID)
	{
		this.BoardID = BoardID;	
	}
   
	//获取类成员变量BoardID的值  
	public long getBoardID()
	{
		return this.BoardID;	
	}

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

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

	//设置类成员变量BoardMaster2的值 
	public void setBoardMaster2(String BoardMaster2)
	{
		this.BoardMaster2 = BoardMaster2;	
	}

	//获取类成员变量BoardMaster2的值  
	public String getBoardMaster2()
	{
		return this.BoardMaster2;	
	}

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