|
楼主 |
发表于 2018-3-19 16:28:13
|
显示全部楼层
服务端代码如图// 获取目录结构
public static JSONObject getList(JSONObject params, ActionContext context) throws ServletException, IOException, AddressException, MessagingException {
String parent_node = params.getString("Strparent_node"); // 获取父级目录ID
String node = params.getString("Strnode");// 获取本(子)级目录ID
String id = params.getString("Strid"); // 获取图纸ID
System.out.println("*****************************");
PreparedStatement pstmt = null;
Connection conn = null;
String sql = "";
JSONObject result = new JSONObject();
try {
conn = context.getConnection("txxt");
if (node != parent_node) {
sql = "SELECT ID,NODE,NODE_NAME,PARENT_NODE FROM NODE_TREE WHERE PARENT_NODE ='" + node + "' ORDER BY NODE ASC;";
pstmt = conn.prepareStatement(sql);
System.out.println(sql);
int count = Integer.parseInt(DataUtils.getValueBySQL(conn, sql, null).toString());
result.put("count", count);
System.out.println(count);
} else {
sql = "SELECT * FROM ENTITY_000 WHERE ID = '" + id + "' AND USED = 1; ";
pstmt = conn.prepareStatement(sql);
System.out.println(sql);
int count = 0;
result.put("count", count);
System.out.println(count);
}
// return result;
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
return result;
} |
|