list 问题，

Question

public class SearchDAO {
public List select(String searchName)
{
Connection conn=null;
    Statement stmt = null;
    ResultSet rs=null;
    String sql = null;
    List list=new ArrayList();
              
        try {
conn=DBConnection.getConnection();
sql = "select * from T_BASE_ENTERPRISE where ee_name like '%" + searchName + "%' ";
stmt=conn.createStatement();
//stmt.setString(1,searchName);
//stmt.executeQuery();
System.out.print(sql);

//stmt.executeQuery(sql);
rs=stmt.executeQuery(sql);

                while(rs.next()) {
                 rs.getInt("ee_id");  //ee_id 是数据库的int型
                 rs.getString("EE_NAME");  //ee_name是数据库的char型
                }
怎样才能把这些这传给list呢。

Answer 1

你是想把查询结果存在list里吗？
你说的“这些”，指的是那些啊？

Answer 2

对我是想把查询结果存在list里
怎么做才行。因为我没有用过list

Answer 3

list.add();
建议用vector，线程安全。

Answer 4

现在用list.add（）这个方法了。那我怎么才能用到它呢search.setSearchName(rs.getString("ee_name"));
search.setId(rs.getInt("ee_id"));
list.add(search);
我把它封装成search对象了。我到另一个页面怎么使用它呢。
这样怎么不行呢
for(int i=0;i<searchDAO.list.size();i++)  //searchDAO是封装search的那个类。
    {
System.out.print(searchDAO.list.get(i));
    request.setAttribute("name",searchDAO.list.get(i));
    }

Answer 5

要加上强制类型转换：（search的类名）searchDAO.list.get(i);

Answer 6

为什么改成这request.setAttribute("name",（SearchVO）searchDAO.list.get(i));
打印出来还是null呢？
另一个页面我用这个<%=request.getAttribute("name")%>   //.jsp
怎么样才能把我查询的东西打印出来呢？

Answer 7

http://www.blogjava.net/jfy3d/archive/2005/05/12/4185.html
rs的list封装

Answer 8

楼主你把你所有程序都贴出来看看吧
这样看起来好乱阿
包括jsp

Answer 9

package cn.cqit.enterprise.dao;import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;import cn.cqit.enterprise.db.DBConnection;
import cn.cqit.enterprise.vo.SearchVO;/**
 * @author zlhuang
 *
 */
public class SearchDAO {
/**
 * 
 */
public List list=new ArrayList();
/**
 * 
 */
public SearchVO search= new SearchVO();

  /**
 * @param searchName
 * @return SearchVO
 */
public List select(String searchName)
{
Connection conn=null;
    //PreparedStatement ptm=null;
    Statement stmt = null;
    ResultSet rs=null;
    String sql = null;
    
              
        try {
conn=DBConnection.getConnection();
sql = "select * from T_BASE_ENTERPRISE where ee_name like '%" + searchName + "%' ";
stmt=conn.createStatement();
//stmt.setString(1,searchName);
//stmt.executeQuery();
System.out.print(sql);

//stmt.executeQuery(sql);
rs=stmt.executeQuery(sql);

                while(rs.next()) {
                 search.setSearchName(rs.getString("ee_name"));
                 search.setId(rs.getInt("ee_id"));
                 list.add(search);
                
                }
            } catch (SQLException e) {
e.printStackTrace();
} finally { 
if(rs!=null)
{
try {
rs.close();
} catch (SQLException e) {

e.printStackTrace();
}
}
if(stmt!=null)
{
try {
stmt.close();
} catch (SQLException e) {

e.printStackTrace();
}
}
if(conn!=null)
{
try {
conn.close();
} catch (SQLException e) {

e.printStackTrace();
}
}
}
return list;        }}

Answer 10

package cn.cqit.enterprise.action;import java.util.List;import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;import cn.cqit.enterprise.dao.SearchDAO;
import cn.cqit.enterprise.form.SearchForm;
import cn.cqit.enterprise.vo.SearchVO;/**
 * @author zlhuang
 *
 */
public class SearchAction extends Action{
/**
 * @see org.apache.struts.action.Action#execute(org.apache.struts.action.ActionMapping, org.apache.struts.action.ActionForm, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
 */
public ActionForward execute(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response)throws Exception{
SearchForm Sform=(SearchForm)form;
    SearchVO   search=(SearchVO)Sform.getSearch();
    SearchDAO   searchDAO =new SearchDAO();
for(int i=0;i<searchDAO.list.size();i++)
    {
System.out.print(((SearchVO)searchDAO.list.get(i)).getSearchName());
    request.setAttribute("name",((SearchVO)searchDAO.list.get(i)).getSearchName());
    }
    
    
    return (mapping.findForward("editorsearch"));
}
}

Answer 11

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
  
    
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>editorsearch</title>
</head>
<body>
<form name="form1" method="post" action="">
  <table width="750" border="1" align="center">
    <tr>
      <td><table width="750" height="2" border="1">
        <tr bgcolor="#CCFFFF">
          <td height="2" colspan="2" align="center">搜索结果</td>
        </tr>
        <tr>
          <td width="60" height="17"><%=request.getAttribute("name")%></td>
          <td width="674">&nbsp;</td>
        </tr>
        <tr>
          <td width="60">&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
      </table></td>
    </tr>
  </table>
</form></body>
</html>

Answer 12

搂主：你看看你的代码 你在SearchDAO在写得从数据库获取LIST的select方法好像你根本没有调用呀 ，看这里 
    SearchDAO   searchDAO =new SearchDAO();
for(int i=0;i<searchDAO.list.size();i++)
    {
System.out.print(((SearchVO)searchDAO.list.get(i)).getSearchName());
    request.setAttribute("name",((SearchVO)searchDAO.list.get(i)).getSearchName());
    }你的searchDAO.list这里得到的值肯定是空的呀，你自己检查一下，

Answer 13

                while(rs.next()) {
                            // 下面这句是必要的
                           search = new SearchVO();
                 search.setSearchName(rs.getString("ee_name"));
                 search.setId(rs.getInt("ee_id"));
                 list.add(search);
                
                }

Answer 14

你象这样改看看调一下：
package cn.cqit.enterprise.action;import java.util.List;import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;import cn.cqit.enterprise.dao.SearchDAO;
import cn.cqit.enterprise.form.SearchForm;
import cn.cqit.enterprise.vo.SearchVO;/**
 * @author zlhuang
 *
 */
public class SearchAction extends Action{
/**
 * @see org.apache.struts.action.Action#execute(org.apache.struts.action.ActionMapping, org.apache.struts.action.ActionForm, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
 */
public ActionForward execute(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response)throws Exception{
SearchForm Sform=(SearchForm)form;
    SearchVO   search=(SearchVO)Sform.getSearch();
    SearchDAO   searchDAO =new SearchDAO();
    List searchList = new ArrayList();
    searchList = searchDAO.select("your parameter");
for(int i=0;i<searchList.size();i++)
    {
System.out.print(((SearchVO)searchList.get(i)).getSearchName());
    request.setAttribute("name",((SearchVO)searchList.get(i)).getSearchName());
    }
    
    
    return (mapping.findForward("editorsearch"));
}
}