【Java开源代码栏目提醒】:网学会员为广大网友收集整理了,CategoryDM.java,希望对大家有所帮助!
package com.abc.store.dm;
import com.abc.store.pd.*;
import com.mortbay.Base.*;
import java.sql.*;
import java.util.*;
public class CategoryDM
{
public static void loadByName(Category category)
{
String name = category.getName();
String sqlStr = "select * from category where name='" + name + "'";
if(Code.verbose(30)) Code.debug("sqlStr=" + sqlStr);
Statement stmt = null;
ResultSet rs = null;
try
{
Connection conn = DMHelper.getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery(sqlStr);
if(rs==null) return ;
while(rs.next())
{
category.setId(rs.getInt("id"));
}
DMHelper.closeStatement(stmt);
}
catch(Exception ex)
{
System.out.println("CategotyDM.loadByName(): " + ex);
}
}
public static Vector loadAllItemsById(int categoryId)
{
Vector items = new Vector();
Statement stmt = null;
ResultSet rs = null;
try
{
Connection conn = DMHelper.getConnection();
stmt = conn.createStatement();
String sqlStr = "select * from item where categoryId=" + categoryId;
if(Code.verbose(30)) Code.debug("sqlStr=" + sqlStr);
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("CategotyDM.loadAllItemsById(): " + ex);
}
return items;
}
public static void main(String arg[])
{
Vector items = loadAllItemsById(1);
Enumeration enum = items.elements();
while (enum.hasMoreElements())
{
Item item = (Item)enum.nextElement();
System.out.println(item.getName());
}
}
}
上一篇:
CategoryDaoHibernate.java
下一篇:
计算机仿真论文1