newsdaoimpl.java~29~

来自「新闻网(news) 带使用说明书 可以用作课程设计」· JAVA~29~ 代码 · 共 185 行

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