newsstyledaoimpl.java~5~

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

package com.victor.dao;

import java.util.List;
import com.victor.domain.NewsStyleActionForm;
import com.victor.tool.JDBConnection;
import java.sql.ResultSet;
import java.sql.*;
import java.util.ArrayList;

public class NewsStyleDaoImpl
    implements NewsStyleDao {
//查询所有的详细类别
  public List watchStyle() {
    List list = new ArrayList();
    NewsStyleActionForm style = null;
    JDBConnection connection = new JDBConnection();
    String sql = "select * from tb_style";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        style = new NewsStyleActionForm();
        style.setStyleID(Integer.valueOf(rs.getString(1)));
        style.setStyleName(rs.getString(2));
        style.setSTName(rs.getString(3));
        style.setStyleDate(rs.getString(4));
        list.add(style);
      }
    }
    catch (SQLException ex) {
    }
    connection.close();
    return list;
  }

//插入的操作
  public void insertStyle(NewsStyleActionForm newsStyleActionForm) {
    JDBConnection connection = new JDBConnection();
    String sql = "insert into tb_style values('" +
        newsStyleActionForm.getStyleName() + "','" +
        newsStyleActionForm.getSTName() + "',getDate())";
    connection.executeUpdate(sql);
    connection.close();
  }

//删除的操作
  public void deleteStyle(NewsStyleActionForm newsStyleActionForm) {
    JDBConnection connection = new JDBConnection();
    String sql = "delete from tb_style where ID='" +
        newsStyleActionForm.getStyleID() + "'";
    connection.executeUpdate(sql);
    connection.close();
  }

//修改的操作
  public void updateStyle(NewsStyleActionForm newsStyleActionForm) {
    JDBConnection connection = new JDBConnection();
    String sql = "update tb_style set StyleName='" +
        newsStyleActionForm.getStyleName() + "',STName='" +
        newsStyleActionForm.getSTName() + "' where ID='" +
        newsStyleActionForm.getStyleID() + "'";
    connection.executeUpdate(sql);
    String sql1 = "update tb_news set style='" + newsStyleActionForm.getSTName() +
        "' where style='" + newsStyleActionForm.getSTName() + "'";
    connection.close();
  }

//单独查找的操作
  public List selectOneStyle(NewsStyleActionForm newsStyleActionForm) {
    List list = new ArrayList();
    NewsStyleActionForm style = null;
    JDBConnection connection = new JDBConnection();
    String sql = "select * from tb_style where ID='" +
        newsStyleActionForm.getStyleID() + "'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        style = new NewsStyleActionForm();
        style.setStyleID(Integer.valueOf(rs.getString(1)));
        style.setStyleName(rs.getString(2));
        style.setSTName(rs.getString(3));
        style.setStyleDate(rs.getString(4));
        list.add(style);

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

//单独查找的操作，查找类别中的详细类别
  public List style(NewsStyleActionForm newsStyleActionForm) {
    List list = new ArrayList();
    NewsStyleActionForm style = null;
    JDBConnection connection = new JDBConnection();
    String sql = "select * from tb_style where STName='" +
        newsStyleActionForm.getSTName() + "'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        style = new NewsStyleActionForm();
        style.setStyleID(Integer.valueOf(rs.getString(1)));
        style.setStyleName(rs.getString(2));
        style.setSTName(rs.getString(3));
        style.setStyleDate(rs.getString(4));
        list.add(style);
      }
    }
    catch (NumberFormatException ex) {
    }
    catch (SQLException ex) {
    }
    return list;
  }
}