- 论坛徽章:
- 0
|
抛出的异常e1为:java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]连接占线导致另一个 hstmt.L
这代码是我从学校里COPY的,在学校就能用,在我家里就出错;
我把查询结果一个个的COPY到查询分析器里试了下,代码里的两条数据库语句没错,它们就是不生效!
代码:
public static void addTree(DefaultMutableTreeNode t) {
Connection con = null;
PreparedStatement pstCate = null;
PreparedStatement pstSubCate = null;
ResultSet rsCate = null;
ResultSet rsSubCate = null;
try {
con = DBManager.getCon();
pstCate = con.prepareStatement(
"select distinct cateid,catename from category");
rsCate = pstCate.executeQuery();
DefaultMutableTreeNode dmt = null;
DefaultMutableTreeNode dmtSub = null;
while (rsCate.next()) {
String abc1 = rsCate.getString(1);
String abc = rsCate.getString(2);
dmt = new DefaultMutableTreeNode(abc);
t.add(dmt);
pstSubCate = con.prepareStatement(
"select subcatename from category where cateid=?");
pstSubCate.setString(1, abc1);
try {
rsSubCate = pstSubCate.executeQuery();
while (rsSubCate.next()) {
String bcd = rsSubCate.getString(1);
dmtSub = new DefaultMutableTreeNode(bcd);
dmt.add(dmtSub);
}
} catch (Exception e1) {
System.out.println(e1);
}
}
rsCate.close();
rsSubCate.close();
pstCate.close();
pstSubCate.close();
con.close();
} catch (Exception e) {
System.out.println(e);
}
} |
|