你用firebug看看 传过去没 是没传过去还是没接到
解决方案 »
- 缺少十六进制数字
- struts2怎样设置<s:select>默认选中项
- 求关于几条jsp操作oracle的SQL语句
- JSP添加记录的问题!~~~~~~小弟实在搞不懂~~在线等???
- 存储过程中的bit类型当用JDBC调用时怎么设置
- 用tomcat的datasource来连接mysql如何在控制台输出产生的sql语句啊?
- 请哪位高人给个url验证的解决方案!
- 用<s:doubleselect>的时候系统报错:FreeMarker template error!
- 关于textfile 的问题!急。。。。。。
- 为什么这样做不可以更新数据库呢?
- 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;
}
这是我重写的方法。但返回数据类型错误。不解!