Java开发网 Java开发网
注册 | 登录 | 帮助 | 搜索 | 排行榜 | 发帖统计  

您没有登录

» Java开发网 » Java SE 综合讨论区  

按打印兼容模式打印这个话题 打印话题    把这个话题寄给朋友 寄给朋友    该主题的所有更新都将Email到你的邮箱 订阅主题
flat modethreaded modego to previous topicgo to next topicgo to back
作者 请高手指教!(Collections.sort 错误)
lobing109





发贴: 5
积分: 0
于 2004-09-03 00:36 user profilesend a private message to usersearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
import java.sql.*;
import javax.naming.*;
import javax.sql.*;
import java.util.*;

public class DiscDB
{
    
  public DiscDB() throws Exception
  {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
  
  public Connection getConn() throws Exception
  {
    return DriverManager.getConnection("jdbc:odbc:disc","","");
    }
    
  public void closeConn(Connection conn)
  {
    try
    {
      if(conn!=null) conn.close();
      }catch(Exception e){}
    }
    
  public void closeStmt(PreparedStatement stmt)
  {
    try
    {
      if(stmt!=null) stmt.close();
      }catch(Exception e){}
    }
    
  public void closeRs(ResultSet rs)
  {
    try
    {
      if(rs!=null) rs.close();
      }catch(Exception e){}
    }
    
  public Collection getDisc() throws Exception
  {
    Connection conn=null;
    PreparedStatement stmt=null;
    ResultSet rs=null;
    ArrayList disc=new ArrayList();
    try
    {
      conn=getConn();
      String selectStatement="select *"+"from disces";
      stmt=conn.prepareStatement(selectStatement);
      rs=stmt.executeQuery();
      
      while(rs.next())
      {
        DiscDetail dd=new DiscDetail(rs.getString(1),rs.getString(2),rs.getString(3),rs.getInt(4),rs.getString(5),rs.getInt(6));
        disc.add(dd);
        }
      }finally
       {
         closeRs(rs);
         closeStmt(stmt);
         closeConn(conn);
         }
      
       Collections.sort(disc);
       return disc;
    }
  
  public static void main(String args[]) throws Exception
  {
    DiscDB db=new DiscDB();
    Collection c=db.getDisc();
    Iterator i=c.iterator();
    while(i.hasNext())
    {
      DiscDetail dis=(DiscDetail)i.next();
      System.out.println(dis.getId());
      }
    }
  }

这段代码编译已经通过了,但是在执行的时候却提示   Collections.sort(disc);
这句有错误,请高手指点一下,谢谢!


{ 请尽量用准确的文字描述作为标题 }


why edited on 2004-09-03 01:02


致JAVA初学者+如何下手学JAVA

话题树型展开
人气 标题 作者 字数 发贴时间
2716 请高手指教!(Collections.sort 错误) lobing109 3636 2004-09-03 00:36
2125 Re:请高手指教!(Collections.sort 错误) why 497 2004-09-03 04:45

flat modethreaded modego to previous topicgo to next topicgo to back
  已读帖子
  新的帖子
  被删除的帖子
Jump to the top of page

   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923