|
本帖最后由 linai486 于 2015-12-24 11:11 编辑
前台四个output与data关联,现在想从数据库把这四个数据查出来,但是没成功
js页面只有一个这个
Model.prototype.btnCheckUserLogin = function(event) {
var self = this;
var mainData = this.comp("mainData");
var params = {
/*"sqruser" : this.sqruser,
"createtime" : this.createtime,
"title" : this.title,
"clzt" : this.clzt,*/
};
// 请求成功后的回调方法
var success = function(resultData) {
mainData.loadData(resultData);
mainData.refreshData();
};
// 发送请求
Baas.sendRequest({
"url" : "/gzrwServlet", // servlet请求地址
"action" : "queryUser", // action
"params" : params, // action对应的参数
"success" : success
// 请求成功后的回调方法
});
};
servletprivate static void saveUser(ServletRequest request, ServletResponse response) throws ParseException, SQLException, NamingException {
JSONObject params = (JSONObject) JSONObject.parse(request.getParameter("params"));
// 获取参数
/*String username=params.getString("username");
String pass=params.getString("pass");
String role=params.getString("role");
String userid=params.getString("userid");*/
JSONObject mainData = params.getJSONObject("mainData");
Connection conn = Util.getConnection(DATASOURCE_NANYUAN);
try {
conn.setAutoCommit(false);
try {
Table userTable = Transform.jsonToTable(mainData);
//Table userTable = Transform.resultSetToTable();
Util.saveData(conn, userTable,TABLE_NANYUAN_GZRW);
System.out.println("----------userTable----------");
conn.commit();
} catch (SQLException e) {
conn.rollback();//回调
throw e;
}
} finally {
conn.close();
}
}private static void queryUser(ServletRequest request , ServletResponse response) throws SQLException,IOException,NamingException {
JSONObject params=(JSONObject) JSONObject.parse(request.getParameter("params"));
//String sqruser = params.getString("sqruser");
//String createtime = params.getString("createtime");
//String title = params.getString("title");
//String clzt = params.getString("clzt");
List<Object> sqlParams = new ArrayList<Object>();
//sqlParams.add(sqruser);
// sqlParams.add(createtime);
// sqlParams.add(title);
//sqlParams.add(clzt);
String sql = " select * from tb_nanyuan_gzrw a " ;
Table table = null;
Connection conn = Util.getConnection(DATASOURCE_NANYUAN);
try {
table = Util.queryData(conn, sql, sqlParams, null, null, null);
} finally {
conn.close();
}
Util.writeTableToResponse(response, table);
}
求指导
|
|