product.jsp
<%
List all = null ;
all = (List)request.getAttribute("all") ;
%> Productservlet
try
{
request.setAttribute("all",Daofactory.getProductdaoimp().queryAll()) ;
} Productdaoimp
public List queryAll()
{
List all=new ArrayList();
String sql = "SELECT * FROM categories" ;
try
{
Connection conn = pool.getConnection();
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery() ;
while(rs.next())
{
Product p= new Product() ;
p.setProductid(rs.getInt(1)) ;
p.setCategoryid(rs.getInt(2));
p.setName(rs.getString(3));
p.setDescription(rs.getString(4));
p.setPrice(rs.getFloat(5));
all.add(p) ;
} rs.close() ;
pstmt.close() ;
conn.close() ;
}
catch (Exception e)
{
e.printStackTrace();
}
return all ; } org.apache.jasper.JasperException: Exception in JSP: /product.jsp:28 25: <th>删除 </th>
26: </tr>
27: <%
28: Iterator iter = all.iterator() ;
29: while(iter.hasNext())
30:…
我是初学者,请大家多多指教,请说的具体点,谢谢!
<%
List all = null ;
all = (List)request.getAttribute("all") ;
%> Productservlet
try
{
request.setAttribute("all",Daofactory.getProductdaoimp().queryAll()) ;
} Productdaoimp
public List queryAll()
{
List all=new ArrayList();
String sql = "SELECT * FROM categories" ;
try
{
Connection conn = pool.getConnection();
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery() ;
while(rs.next())
{
Product p= new Product() ;
p.setProductid(rs.getInt(1)) ;
p.setCategoryid(rs.getInt(2));
p.setName(rs.getString(3));
p.setDescription(rs.getString(4));
p.setPrice(rs.getFloat(5));
all.add(p) ;
} rs.close() ;
pstmt.close() ;
conn.close() ;
}
catch (Exception e)
{
e.printStackTrace();
}
return all ; } org.apache.jasper.JasperException: Exception in JSP: /product.jsp:28 25: <th>删除 </th>
26: </tr>
27: <%
28: Iterator iter = all.iterator() ;
29: while(iter.hasNext())
30:…
我是初学者,请大家多多指教,请说的具体点,谢谢!
解决方案 »
- 求一个java正则表达式
- 浏览器窗口关闭触发action
- 当http访问,跳转到https
- Ext Designer Preview怎么用
- HTML编辑器有复杂格式内容时,提交时总是造成信息不全,估计是html标签引起的,但又不可能去一一过滤,请问如何解决这种问题呀?
- 急求解决jsp新闻系统,阅读次数就加一
- 请问tomcat连接sql server是不是这样连?谢谢!
- 我想多学点技术,进大公司好还是小公司呢?请大家帮我分析一下
- http协议头包含那些内容?
- 请问在weblogic6.1上如何配置连接sqlserver2000的数据库连接
- 大家帮帮忙
- Struts动态验证框架不提交或不验证问题!在线等!分少,能帮忙回答下么?
1. List是否为null?
2. List可以用for直接循环输出.