faqdao.java~11~

这是一个‘常见问题’的功能

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

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

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

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