package com.ntsky.news;
/**
 * <p>Title: NTsky新聞發布v1.0正式版</p>
 * <p>Description: 用戶文章發表</p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: NTsky</p>
 * @authory 姚君林
 * @version 1.0
 */
import java.sql.*;
import java.util.*;

import com.ntsky.common.*;
import com.ntsky.database.*;
import com.ntsky.persistence.*;

public class UserNews {
    private SQLDBOperator sdbo=null;
    /**
     * 添加文章
     */
    public void insUserNews(int classId,int kindId,String headTitle,String content,String user,String newsFrom){
        if (sdbo==null)
            sdbo = SQLDBOperator.getInstance("Connection");
        String strSql="insert into news(classId,kindId,myOther,headTitle,content,newsFrom,author,top,newsTime,state,tag) values(?,?,0,?,?,?,?,0,?,0,0)";
        try{
            sdbo.prepareStatement(strSql);
            sdbo.setInt(1,classId);
            sdbo.setInt(2,kindId);
            sdbo.setString(3,CodeFilter.toHtml(headTitle));
            sdbo.setString(4,CodeFilter.toHtml(content));
            sdbo.setString(5,CodeFilter.toHtml(newsFrom));
            sdbo.setString(6,user);
            sdbo.setString(7,DateUtil.getNowDate());
            sdbo.executeUpdate();
        }
        catch(Exception e){
            System.out.println("UserNews insUserNews() :" + e.getMessage());
            Debug.writeLog("UserNews insUserNews(), Exception Occured ! Info :" + e.getLocalizedMessage());
        }
        finally{
            sdbo.Close();
        }
    }
    /**
     * 刪除用戶個人文章
     */
    public void delUserNews(int newsId){
        if (sdbo==null)
            sdbo = SQLDBOperator.getInstance("Connection");
        String strSql = "delete from news where newsId='"+newsId+"';";
        try{
            sdbo.executeUpdate(strSql);
        }
        catch(Exception e){
            System.out.print("UserNews delUserNews() :" + e.getMessage());
            Debug.writeLog("UserNews delUserNews(), Exception Occured ! Info :" + e.getLocalizedMessage());
        }
        finally{
            sdbo.Close();
        }
    }
    /**
     * 修改用戶發表的新聞
     * @param newsId
     * @return
     */
    public Iterator editUserNews(int newsId){
        Vector vector=new Vector();
        if (sdbo==null)
            sdbo = SQLDBOperator.getInstance("Connection");
        String sql = "select * from news where newsId=?;";
        try{
            sdbo.prepareStatement(sql);
            sdbo.setInt(1,newsId);
            ResultSet rs = sdbo.executeQuery();
            try{
                while (rs.next()) {
                    NEWSTable tableNews = new NEWSTable();
                    tableNews.setClassId(rs.getInt("classId"));
                    tableNews.setKindId(rs.getInt("kindId"));
                    tableNews.setHeadTitle(rs.getString("headTitle"));
                    tableNews.setContent(rs.getString("content"));
                    tableNews.setNewsFrom(rs.getString("newsFrom"));
                    vector.add(tableNews);
                }
                rs.close();
            }
            catch(NullPointerException nullE){
                System.out.print("News editUserNews() " + nullE.getMessage());
                Debug.writeLog("News editUserNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
            }
        }
        catch(SQLException sqlE){
            System.out.print("News editUserNews() " + sqlE.getMessage());
            Debug.writeLog("News editUserNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
        }
        finally{
            sdbo.Close();
        }
        return vector.iterator();
    }
    /**
     * 更新用戶發表的文章
     */
    public void upUserNews(int classId,int kindId,String headTitle,String content,String newsFrom,int newsId){
        if (sdbo==null)
            sdbo = SQLDBOperator.getInstance("Connection");
        String strSql = "update news set classId=?,kindId=?,headTitle=?,content=?,newsFrom=?,newsTime='"+DateUtil.getNowDate()+"' where newsId=?;";
        try{
            sdbo.prepareStatement(strSql);
            sdbo.setInt(1,classId);
            sdbo.setInt(2,kindId);
            sdbo.setString(3,CodeFilter.toHtml(headTitle));
            sdbo.setString(4,CodeFilter.toHtml(content));
            sdbo.setString(5,CodeFilter.toHtml(newsFrom));
            //sdbo.setString(6,DateUtil.getNowDate());
            sdbo.setInt(6,newsId);
            sdbo.executeUpdate();
        }
        catch(Exception e){
            System.out.print("News upUserNews() " + e.getMessage());
            Debug.writeLog("News upUserNews(), Exception Occured ! Info :" + e.getLocalizedMessage());
        }
        finally{
            sdbo.Close();
        }
    }
}