【Java开源代码栏目提醒】:网学会员在Java开源代码频道为大家收集整理了boards.java提供大家参考,希望对大家有所帮助!
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