easyUI中DataGrid的queryParams 你用firebug看看 传过去没 是没传过去还是没接到 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你是在 onload事件以后再去定义的参数么.... 看代码是没有问题的,是这么写。你看一下发送请求的时候是不是把这些参数传过去了,用浏览器的调试工具看,如chrome的network、firefox中的firebug 他是参数是在加载的时候一次性的值,你需要重写DATAGRID的加载数据方法 public List<Transfer> getAllTransferPageByCondition(int start, int number, String transferName, String beginTime, String endTime) { Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; HttpServletRequest re = ServletActionContext.getRequest(); // HttpServletResponse response = ServletActionContext.getResponse(); String page = re.getParameter("page"); String rows = re.getParameter("rows"); // 条件查询 // ��ǰҳ int intPage = Integer.parseInt((page == null || page == "0") ? "1" : page); // ÿҳ��ʾ���� number = Integer.parseInt((rows == null || rows == "0") ? "10" : rows); // ÿҳ�Ŀ�ʼ��¼ ��һҳΪ1 �ڶ�ҳΪnumber +1 start = (intPage - 1) * number; int reg = 1; StringBuffer sql = new StringBuffer( "select id,transfername,birthland,destination,time,comments from transfer "); SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");// 设置日期格式 if (transferName != null && !"".equals(transferName)) { sql.append(" where transferName='" + transferName + "'"); } if (beginTime != null && !"".equals(beginTime)) { if (endTime != null && !"".equals(endTime)) { sql.append(" and time between '" + beginTime + "'" + " and '" + endTime + "'"); } else { sql.append(" and time between '" + beginTime + "'" + " and '" + df.format(new Date()) + "'"); } } System.out.println("sql=" + sql); List<Transfer> dataList = new ArrayList<Transfer>(); try { conn = DataBaseManager.getConn(); ps = conn.prepareStatement(sql.toString()); ps.setString(1, transferName); ps.setString(2, beginTime); ps.setString(3, endTime); rs = ps.executeQuery(); while (rs.next() && reg <= (start + number)) { if (reg > start) { Transfer transfer = new Transfer(); transfer.setId(rs.getInt("id")); transfer.setTransferName(rs.getString("transfername")); transfer.setBirthLand(rs.getString("birthland")); transfer.setDestination(rs.getString("destination")); transfer.setTime(rs.getString("time")); transfer.setComments(rs.getString("comments")); dataList.add(transfer); } reg++; } DataBaseManager.close(rs); DataBaseManager.close(ps); } catch (SQLException e) { e.printStackTrace(); } finally { DataBaseManager.closeConn(); } return dataList; }这是我重写的方法。但返回数据类型错误。不解! 你这是给我贴的后台啊,我是基于你的问题回答你,只要后台接收到任务你传递过去的参数就说明你这次请求是成功了,如果是返回数据出的错,说明是你后台处理的时候出了问题。easyui datagrid接收的参数是json的数据。可以去官网参考一下文档 ajaxfileupload问题 hibernate 对象三种状态的疑问 请教! jsp页面显示MySQL数据库保存的二进制图片问题 跳转页面出错 找个东西 传志播客的那个巴巴运动的静态页面... 如何区别主机名、服务器名、域名、IP地址?晕 那里有JSP的免费空间 请教tomcat配置问题! 如何实现控件间的满位跳转 在用smartupload上处的时候如何改文件的名字呀 Jfreechart如何向页面输出HTML格式的报表,并带有打印按钮,可打印 @CookieValue如何使用?
String transferName, String beginTime, String endTime) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null; HttpServletRequest re = ServletActionContext.getRequest();
// HttpServletResponse response = ServletActionContext.getResponse();
String page = re.getParameter("page");
String rows = re.getParameter("rows"); // 条件查询 // ��ǰҳ
int intPage = Integer.parseInt((page == null || page == "0") ? "1"
: page);
// ÿҳ��ʾ����
number = Integer.parseInt((rows == null || rows == "0") ? "10" : rows);
// ÿҳ�Ŀ�ʼ��¼ ��һҳΪ1 �ڶ�ҳΪnumber +1
start = (intPage - 1) * number;
int reg = 1;
StringBuffer sql = new StringBuffer(
"select id,transfername,birthland,destination,time,comments from transfer "); SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");// 设置日期格式
if (transferName != null && !"".equals(transferName)) {
sql.append(" where transferName='" + transferName + "'");
} if (beginTime != null && !"".equals(beginTime)) {
if (endTime != null && !"".equals(endTime)) {
sql.append(" and time between '" + beginTime + "'" + " and '"
+ endTime + "'");
} else {
sql.append(" and time between '" + beginTime + "'" + " and '"
+ df.format(new Date()) + "'");
}
}
System.out.println("sql=" + sql);
List<Transfer> dataList = new ArrayList<Transfer>();
try {
conn = DataBaseManager.getConn();
ps = conn.prepareStatement(sql.toString());
ps.setString(1, transferName);
ps.setString(2, beginTime);
ps.setString(3, endTime);
rs = ps.executeQuery(); while (rs.next() && reg <= (start + number)) {
if (reg > start) {
Transfer transfer = new Transfer();
transfer.setId(rs.getInt("id"));
transfer.setTransferName(rs.getString("transfername"));
transfer.setBirthLand(rs.getString("birthland"));
transfer.setDestination(rs.getString("destination"));
transfer.setTime(rs.getString("time"));
transfer.setComments(rs.getString("comments"));
dataList.add(transfer);
}
reg++;
} DataBaseManager.close(rs);
DataBaseManager.close(ps);
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataBaseManager.closeConn();
}
return dataList;
}
这是我重写的方法。但返回数据类型错误。不解!