/*
 * AddModel.java
 *
 * Created on 2007年3月17日, 下午12:17
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package News.ProcessData;


import java.sql.*;

import News.Common.DBManager;
/**
 *
 * @author 吳西博
 */
public class AddModel {
    private Connection conn=null;
    private PreparedStatement ps=null;
    /** Creates a new instance of AddModel */
    public AddModel() {
    }
    
    public boolean AddNotice(String content)
    {
        int i=0;
        try{
        conn=DBManager.getConnection();
        ps=conn.prepareStatement("insert into Notice(Message) values(?)");
        ps.setString(1,content);
        i=ps.executeUpdate();
        }catch(SQLException e){System.out.println(e.getMessage());return false;}
        finally{
            try{
        if(ps!=null){ps.close();}
        if(conn!=null){conn.close();}
            }catch(SQLException e1){System.out.println(e1.getMessage());}
        }
        if(i>0)
            return true;
        else return false;
    }
    
    public boolean AddCatalog(String content,String logoURL)
    {
        int i=0;
        try{
        conn=DBManager.getConnection();
        ps=conn.prepareStatement("insert into Catalogs(Title,LogoURL) values(?,?)");
        ps.setString(1,content);
        ps.setString(2,logoURL);
        i=ps.executeUpdate();
        }catch(SQLException e){System.out.println(e.getMessage());return false;}
        finally{
            try{
        if(ps!=null){ps.close();}
        if(conn!=null){conn.close();}
            }catch(SQLException e1){System.out.println(e1.getMessage());}
        }
        if(i>0)
            return true;
        else return false;
    }
    
    public boolean AddLink(String Name,String URL,String Logo)
    {
        int i=0;
        try{
        conn=DBManager.getConnection();
        ps=conn.prepareStatement("insert into Links(Name,URL,Logo) values(?,?,?)");
        ps.setString(1,Name);
        ps.setString(2,URL);
        ps.setString(3,Logo);
        i=ps.executeUpdate();
        }catch(SQLException e){System.out.println(e.getMessage());return false;}
        finally{
            try{
        if(ps!=null){ps.close();}
        if(conn!=null){conn.close();}
            }catch(SQLException e1){System.out.println(e1.getMessage());}
        }
        if(i>0)
            return true;
        else return false;
    }
    
    public boolean AddNews(int id,String author,String title,String content)
    {
        int i=0;
        try{
        conn=DBManager.getConnection();
        ps=conn.prepareStatement("insert into News(Parentid,Author,Title,Content) values(?,?,?,?)");
        ps.setInt(1,id);
        ps.setString(2,author);
        ps.setString(3,title);
        ps.setString(4,content);
        i=ps.executeUpdate();
        }catch(SQLException e){System.out.println(e.getMessage());return false;}
        finally{
            try{
        if(ps!=null){ps.close();}
        if(conn!=null){conn.close();}
            }catch(SQLException e1){System.out.println(e1.getMessage());}
        }
        if(i>0)
            return true;
        else return false;
    }
     
}