appendantmanagement.java

一个关于商业的网站

/**
 * $ file: AppendantManagement.java
 * $ Revision: 1.0
 * $ Modified Record:
                   $2003.4.6: Created.

 * Copyright (C) 2003 www.studyjava.com All rights reserved.
 *
*/

package com.everstar.bbs;

import java.sql.*;
import com.everstar.database.*;

public class AppendantManagement
{
   private Database database = null;
   private String sqlStr = null;

   public void AppendantManagement()
   {
   	 database = new Database();
   }

   public void AppendantManagement( Database tempDB)
   {
      database = tempDB;
   }

   //Save icon number to database
   public int saveForumIcon(int messageID,int icon)
   {
     sqlStr = "select messageID from jiveMsgCount where messageID ="
              + Integer.toString(messageID);
     if (database.count(sqlStr)==0)
     {
       sqlStr = "insert into jiveMsgCount values("
              + Integer.toString(messageID)+",0,"+Integer.toString(icon)+",0)";
       if(database.insert(sqlStr)==-1)
         return -1;
     }
     else
     {
       sqlStr = "update jiveMsgCount set icon="
                +Integer.toString(icon)+" where messageID ="+Integer.toString(messageID);
       if(database.update(sqlStr)==-1)
        return -1;
     }
     return 1;
   }

    //read icon from database
   public int loadFroumIcon(int messageID)
   {
     sqlStr = "select icon from jiveMsgCount where messageID="
              +Integer.toString(messageID);
     try
     {
           ResultSet rs = database.select(sqlStr);
           if (rs.next())
           {
             return rs.getInt(1) ;
           }
           else
           {
             return -1;
           }
     }
     catch (SQLException ex)
     {
       return -1;
     }
   }

    //Save message length
   public int saveMessageLength(int messageID,int length)
   {
     sqlStr = "select messageID from jiveMsgCount where messageID ="
              + Integer.toString(messageID);
     if (database.count(sqlStr)==0)
     {
       sqlStr = "insert into jiveMsgCount values("
                + Integer.toString(messageID)+",0,0，"+Integer.toString(length)+")";
       if(database.insert(sqlStr)==-1)
        return -1;
     }
     else
     {
       sqlStr = "update jiveMsgCount set length="
                +Integer.toString(length)+" where messageID ="+Integer.toString(messageID);
       if(database.update(sqlStr)==-1)
        return -1;
     }
     return 1;
   }

   //load message length
   public int loadMessageLength(int messageID)
   {
     sqlStr = "select length from jiveMsgCount where messageID="
              +Integer.toString(messageID);
     try {
           ResultSet rs = database.select(sqlStr);
           if (rs.next())
           {
             return rs.getInt(1) ;
           }
           else
           {
             return -1;
           }
     }
     catch (SQLException ex)
     {
       return -1;
     }
   }
}