linkdaoimpl.java~7~

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

package com.victor.dao;

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

public class LinkDaoImpl
    implements LinkDao {

  //对链接的全部查找
  public List linkSelect() {
    List list = new ArrayList();
    JDBConnection connection = new JDBConnection();
    LinkActionForm linkActionForm = null;
    String sql = "select * from tb_Link";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        linkActionForm = new LinkActionForm();
        linkActionForm.setLinkID(Integer.valueOf(rs.getString(1)));

        linkActionForm.setLinkName(rs.getString(3));
        linkActionForm.setLinkAddress(rs.getString(4));
        linkActionForm.setLinkIssueDate(rs.getString(5));
        linkActionForm.setLinkPicture(rs.getString(2));
        list.add(linkActionForm);
      }
    }
    catch (SQLException ex) {
    }
    connection.close();
    return list;
  }

//删除链接
  public void linkDelete(LinkActionForm linkActionForm) {
    JDBConnection connection = new JDBConnection();
    String sql = "delete from tb_Link where ID='" + linkActionForm.getLinkID() +
        "'";
    connection.executeUpdate(sql);
    connection.close();
  }

//插入链接
  public void linkInsert(LinkActionForm linkActionForm) {
    JDBConnection connection = new JDBConnection();
    String sql = "insert into tb_Link values('" + linkActionForm.getLinkPicture() +
        "','" + linkActionForm.getLinkName() + "','" +
        linkActionForm.getLinkAddress() + "',getDate())";
    connection.executeUpdate(sql);
    connection.close();
  }

//单独查询
  public List linkSelectOne(LinkActionForm linkActionForm) {
    List list = new ArrayList();
    JDBConnection connection = new JDBConnection();
    LinkActionForm link = null;
    String sql = "select * from tb_Link where ID='" + linkActionForm.getLinkID() +
        "'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        linkActionForm = new LinkActionForm();
        linkActionForm.setLinkID(Integer.valueOf(rs.getString(1)));
        linkActionForm.setLinkPicture(rs.getString(2));
        linkActionForm.setLinkName(rs.getString(3));
        linkActionForm.setLinkAddress(rs.getString(4));
        linkActionForm.setLinkIssueDate(rs.getString(5));
        list.add(linkActionForm);

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

//修改属性
  public void linkUpdate(LinkActionForm linkActionForm) {
    JDBConnection connection = new JDBConnection();
    String sql = "update tb_Link set Picture='" + linkActionForm.getLinkPicture() +
        "',Name='" + linkActionForm.getLinkName() + "',Address='" +
        linkActionForm.getLinkAddress() + "' where ID='" +
        linkActionForm.getLinkID() + "'";
    connection.executeUpdate(sql);
    connection.close();
  }
}