【Java开源代码栏目提醒】:网学会员为广大网友收集整理了,CatalogDM.java,希望对大家有所帮助!
package com.abc.store.dm;
import com.abc.store.pd.*;
import java.sql.*;
import java.util.*;
public class CatalogDM
{
public static Vector loadAllById(int catalogId)
{
Vector items = new Vector();
Statement stmt = null;
ResultSet rs = null;
try
{
Connection conn = DMHelper.getConnection();
stmt = conn.createStatement();
String sqlStr = "select * from item where catalogId=" + catalogId;
rs = stmt.executeQuery(sqlStr);
if(rs==null) return new Vector();
while(rs.next())
{
Item item = new Item(rs.getInt("id"));
item.setName(rs.getString("name"));
item.setDescription(rs.getString("description"));
items.addElement(item);
}
DMHelper.closeStatement(stmt);
}
catch(Exception ex)
{
System.out.println("ItemDM.loadAll(): " + ex);
}
return items;
}
public static void main(String arg[])
{
Vector items = loadAllById(1);
Enumeration enum = items.elements();
while (enum.hasMoreElements())
{
Item item = (Item)enum.nextElement();
System.out.println(item.getName());
}
}
}
上一篇:
CatalogDAOImpl.java
下一篇:
英语论文网([网学网]):英语专业本科生毕业论文写作