|
目前在做一个门户网站,因为bizAction是要登录取到sessionId才能调用的,所以就只能换一种方式,在.j文件中用普通的servlet来处理业务。
现在遇到的问题是.j文件中无法引用到KSQL还有相关的类如table等。请问是不是还有其他的方法在.j文件中做数据库交互?
以下是.j中的业务处理源码:
private void getArticleList(HttpServletRequest request, HttpServletResponse response) {
try {
String typeId = request.getParameter("typeId");
System.out.println(typeId);
Map<String, Object> params = new HashMap<String, Object>();
params.put("typeId", typeId);
Table table = KSQL.select("select Z_ARTICLE.ID, Z_ARTICLE.FTITLE, Z_ARTICLE.CREATE_TIME" +
" FROM Z_ARTICLE Z_ARTICLE WHERE Z_ARTICLE.TYPE_ID = :typeId" +
" ORDER BY Z_ARTICLE.CREATE_TIME desc LIMIT 0,10 ",
params, "/kswq/cms/data", null);
String content = Transform.tableToJson(table).toString();
System.out.println(content.toString());
response.setCharacterEncoding("UTF-8");
response.setContentType(ActionUtils.JSON_CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.write(content);
out.flush();
out.close();
} catch (Exception e) {
// TODO: handle exception
}
}
|
|