package com.victor.dao;

import java.util.List;
import com.victor.domain.NewsActionForm;
import com.victor.tool.JDBConnection;
import java.util.ArrayList;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.victor.domain.NewsTypeActionForm;

public class NewsDaoImpl
    implements NewsDao {
//查看所有的鏈接的記錄
  public List newsWarch() {
    JDBConnection connection = new JDBConnection();
    NewsActionForm newsForm = null;
    List list = new ArrayList();
    String sql = "select * from tb_news ";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        newsForm = new NewsActionForm();
        newsForm.setNewID(Integer.valueOf(rs.getString(1)));
        newsForm.setNewTitle(rs.getString(2));
        newsForm.setNewContent(rs.getString(3));
        newsForm.setNewsType(rs.getString(4));
        newsForm.setNewsStyle(rs.getString(5));
        newsForm.setNewIssueDate(rs.getString(6));
        list.add(newsForm);
      }
    }
    catch (NumberFormatException ex) {
    }
    catch (SQLException ex) {
    }
    connection.close();
    return list;

  }

//對新聞的插入
  public void insertNews(NewsActionForm newsActionForm) {
    JDBConnection connection = new JDBConnection();
    String sql = "insert into tb_news values('" + newsActionForm.getNewTitle() +
        "','" + newsActionForm.getNewContent() + "','" +
        newsActionForm.getNewsType() + "','" + newsActionForm.getNewsStyle() +
        "',getDate())";
    connection.executeUpdate(sql);
    connection.close();
  }

//對新聞的刪除功能
  public void deleteNews(NewsActionForm newsActionForm) {
    JDBConnection connection = new JDBConnection();
    String sql = "delete from tb_news where ID='" + newsActionForm.getNewID() +
        "'";
    connection.executeUpdate(sql);
    connection.close();
  }

//對新聞的單獨查找，并查處一組數(shù)據(jù)
  public List selectOneNews(NewsActionForm newsActionForm) {
    JDBConnection connection = new JDBConnection();
    NewsActionForm newsForm = null;
    List list = new ArrayList();
    String sql = "select * from tb_news where ID='" + newsActionForm.getNewID() +
        "'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        newsForm = new NewsActionForm();
        newsForm.setNewID(Integer.valueOf(rs.getString(1)));
        newsForm.setNewTitle(rs.getString(2));
        newsForm.setNewContent(rs.getString(3));
        newsForm.setNewsType(rs.getString(4));
        newsForm.setNewsStyle(rs.getString(5));
        newsForm.setNewIssueDate(rs.getString(6));
        list.add(newsForm);
      }
    }
    catch (SQLException ex) {
    }
    connection.close();
    return list;
  }

//修改新聞的屬性
  public void updateNews(NewsActionForm newsActionForm) {
    JDBConnection connection = new JDBConnection();
    String sql = "update tb_news set Title='" + newsActionForm.getNewTitle() +
        "',Content='" + newsActionForm.getNewContent() + "',Type='" +
        newsActionForm.getNewsType() + "',Style='" +
        newsActionForm.getNewsStyle() + "' where ID='" +
        newsActionForm.getNewID() + "'";
    connection.executeUpdate(sql);
    connection.close();
  }

//以新聞的類別進行查找
  public List mainNews(NewsActionForm newsActionForm) {
    JDBConnection connection = new JDBConnection();
    NewsActionForm newsForm = null;
    List list = new ArrayList();
    String sql = "select * from tb_news where Type='" +
        newsActionForm.getNewsType() + "' ";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        newsForm = new NewsActionForm();
        newsForm.setNewID(Integer.valueOf(rs.getString(1)));
        newsForm.setNewTitle(rs.getString(2));
        newsForm.setNewContent(rs.getString(3));
        newsForm.setNewsType(rs.getString(4));
        newsForm.setNewsStyle(rs.getString(5));
        newsForm.setNewIssueDate(rs.getString(6));
        list.add(newsForm);

      }
    }
    catch (NumberFormatException ex) {
    }
    catch (SQLException ex) {
    }
    connection.close();
    return list;
  }

//以新聞類型和內(nèi)容的模糊查詢進行的前臺操作
  public List keyNewsWatch(String key, NewsActionForm newsActionForm) {
    JDBConnection connection = new JDBConnection();
    NewsActionForm newsForm = null;
    List list = new ArrayList();
    String sql = "select * from tb_news where Content like'%" + key +
        "%' and Type='" + newsActionForm.getNewsType() + "'";
    ResultSet rs = connection.executeQuery(sql);

    try {
      while (rs.next()) {
        newsForm = new NewsActionForm();
        newsForm.setNewID(Integer.valueOf(rs.getString(1)));
        newsForm.setNewTitle(rs.getString(2));
        newsForm.setNewContent(rs.getString(3));
        newsForm.setNewsType(rs.getString(4));
        newsForm.setNewsStyle(rs.getString(5));
        newsForm.setNewIssueDate(rs.getString(6));
        list.add(newsForm);
      }
    }
    catch (NumberFormatException ex) {
    }
    catch (SQLException ex) {
    }

    connection.close();
    return list;
  }

//當天新聞的查找
  public List dateNews() {
    JDBConnection connection = new JDBConnection();
    NewsActionForm newsForm = null;
    List list = new ArrayList();
    java.util.Date datetime = new java.util.Date();
    int year=datetime.getYear()+1900;
    int month=datetime.getMonth() +1;

    String date = "" + year + "-" + month+
        "-" + datetime.getDate() + " "+00+":"+00+":"+00+"";

    String sql = "select * from tb_news where IssDate between '"+date+"' and getDate()";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        newsForm = new NewsActionForm();
        newsForm.setNewID(Integer.valueOf(rs.getString(1)));
        newsForm.setNewTitle(rs.getString(2));
        newsForm.setNewContent(rs.getString(3));
        newsForm.setNewsType(rs.getString(4));
        newsForm.setNewsStyle(rs.getString(5));
        newsForm.setNewIssueDate(rs.getString(6));
        list.add(newsForm);
      }
    }
    catch (NumberFormatException ex) {
    }
    catch (SQLException ex) {
    }
    return list;
  }
}