faqdao.java

来自「这是一个‘常见问题’的功能」· Java 代码 · 共 61 行

package com.accp.xdj.faqload.server.dao;

import com.accp.xdj.faqload.server.entity.FAQ;
import java.sql.*;
import java.util.ArrayList;
import com.ConnectionManage;

public class FAQDAO {
  public FAQ getDetail(FAQ f) {
    FAQ faq = new FAQ();
    Connection conn = ConnectionManage.getConnection();
    String sql = "select detail from faq where id=?";
    PreparedStatement ps = null;
    ResultSet rs = null;
    try {
      ps = conn.prepareStatement(sql);
      ps.setInt(1, f.getId());

      rs = ps.executeQuery();

      if (rs.next())
        faq.setDetail(rs.getString(1));
    }
    catch (SQLException ex) {
    }
    finally {
      ConnectionManage.close(rs);
      ConnectionManage.close(ps);
      ConnectionManage.close(conn);
    }
    return faq;
  }

  public ArrayList getFAQ() {
    ArrayList list = new ArrayList();
    Connection conn = ConnectionManage.getConnection();
    String sql = "select id, faq from faq order by id asc";
    Statement ps = null;
    ResultSet rs = null;
    try {
      ps = conn.createStatement();
      rs = ps.executeQuery(sql);
      while (rs.next()) {
        FAQ faq = new FAQ();
        faq.setId(rs.getInt(1));
        faq.setFaq(rs.getString(2));
        list.add(faq);
      }
    }
    catch (SQLException ex) {
      ex.printStackTrace();
    }
    finally {
      ConnectionManage.close(rs);
      ConnectionManage.close(ps);
      ConnectionManage.close(conn);
    }
    return list;
  }
}