[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相关