如:
选择部门的时候,就是查询表部门里面所有的名称;
在这个页面加载的时候就应该出现;
package cn.com.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import cn.com.lf.JdbcUtils;
public class All_Part extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//查询所有部门的名称
String sql="SELECT DISTINCT part FROM person_info" ;
ResultSet rs=JdbcUtils.select(sql, null);
List<String> list=new ArrayList<String>();
try {
while(rs.next()){
list.add(rs.getString(1));
}
request.setAttribute("alllist", list);
request.getRequestDispatcher("/SearchPosition.jsp").forward(request, response);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
相关jsp代码
<span class="peo_left">所属机构:
<select>
<option>请选择</option>
<c:forEach items="${alllist}" var="i" varStatus="status">
<option>${i}</option>
</c:forEach>
</select>
</span>