62,615
社区成员
发帖
与我相关
我的任务
分享
/**
* 查询库名
*
* @return
*/
public List<String> GetLibList() {
List<String> result = new ArrayList();
try {
String sql = "select SCHEMA_NAME from information_schema.schemata";
// 创建sql语句执行器
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
// ResultSetMetaData rs_metaData = rs.getMetaData();
while (rs.next()) {
String a = new String();
a = rs.getString("SCHEMA_NAME");
result.add(a);
}
return result;
} catch (Exception e) {
return result;
}
}
List<String> list= GetLibList();
for (int i = 0; i < list.size(); i++) {
jC.addItem(list.remove(i));
}
这样循环就没事了
list.forEach(s -> jC.addItem(s));
} catch (Exception e) {
e.printStackTrace();
return result;
}
再就是看下是否连错数据库