StringBuffer sGetCategorySQL=new StringBuffer();
sGetCategorySQL.append("select category_cd,category_name from category");
sGetCategorySQL.append("order by category_cd");
rs=stmt.executeQuery(sGetCategorySQL.toString());
StringBuffer sCategoryBuffer=new StringBuffer();
if(rs.next())
{
sCategoryBuffer=sCategoryBuffer.append("'"+rs.getString(1));
sCategoryBuffer=sCategoryBuffer.append("','"+rs.getString(2)+"'");
while(rs.next())
{
sCategoryBuffer=sCategoryBuffer.append(",'"+rs.getString(1));
sCategoryBuffer=sCategoryBuffer.append("','"+rs.getString(2)+"'");
}
}
意思就是从数据库中查询出来category_cd和category_name然后排序,那是不是只有个while(rs.next())就行了,不用那个if(rs.next())行不行
sGetCategorySQL.append("select category_cd,category_name from category");
sGetCategorySQL.append("order by category_cd");
rs=stmt.executeQuery(sGetCategorySQL.toString());
StringBuffer sCategoryBuffer=new StringBuffer();
if(rs.next())
{
sCategoryBuffer=sCategoryBuffer.append("'"+rs.getString(1));
sCategoryBuffer=sCategoryBuffer.append("','"+rs.getString(2)+"'");
while(rs.next())
{
sCategoryBuffer=sCategoryBuffer.append(",'"+rs.getString(1));
sCategoryBuffer=sCategoryBuffer.append("','"+rs.getString(2)+"'");
}
}
意思就是从数据库中查询出来category_cd和category_name然后排序,那是不是只有个while(rs.next())就行了,不用那个if(rs.next())行不行
用while 是循环 当然打出所有匹配的查询结果了sGetCategorySQL.append("select category_cd,category_name from category");
sGetCategorySQL.append("order by category_cd"); 你怎么那么麻烦呢 写在一起不就好了