newsdaoimpl.java~36~

明日新闻网络中心是由吉林省明日科技有限公司开发的一个信息管理系统

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();
  }

//对新闻的单独查找，并查处一组数据
  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;
  }

//以新闻类型和内容的模糊查询进行的前台操作
  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() + "'";

    System.out.println(sql);
    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;
   System.out.println(year);
   System.out.println(month);
    String date = "" + year + "-" + month+
        "-" + datetime.getDate() + " "+00+":"+00+":"+00+"";
    System.out.println("date=" + date);
    String sql = "select * from tb_news where IssDate between '2005-12-26 00:00:00' 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;
  }
}