当前位置:编程学习 > JAVA >>

[ARTEMIS7][SQLServer JDBC Driver]Object has been closed.

应该就是这段代码处的问题,还没找到方法修改

if(!accessSqlNotNeed) {
            if (lTeamList != null && lTeamList.size() > 0) {
                StringBuilder queryStmts = new StringBuilder(SQL_INITIALLENGTH);
                queryStmts.append("select a.teamaccessid, a.teamid, a.roleid, a.resourceid, ");
                queryStmts.append("a.accesstype, r.name, r.email, a.lastuser, a.lastedited, a.attachments ");
                queryStmts.append(" from tr_teamaccess a, tr_resource r ");
                queryStmts.append(" where a.resourceid=r.resourceid and a.teamid = ?");
                PreparedStatement stmts = null;
                try {
                    stmts = con.prepareStatement(queryStmts.toString());
                    TRTeamAccessSQL teamAccessSQL = new TRTeamAccessSQL();
                    for (TRTeam team : lTeamList) {
                        teamAccessSQL.getTeamAccessesByTeamKey(con, team
                            .TeamAccesses(), team.getKey(), null, stmts);
                    }
                    lTeamList = null; 
                } finally {
                    if (stmts != null) {
                        stmts.close();
                    }
                }
            }
        }
         --------------------编程问答-------------------- --------------------编程问答-------------------- teamAccessSQL.getTeamAccessesByTeamKey(con, team
  .TeamAccesses(), team.getKey(), null, stmts)中对con和stmts做了什么,有没有close
补充:Java ,  Java相关
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,