首先我在数据库中根据查询条件是对的
select id,supplierid,type,shijian,data from a where supplierid=2 and type="获取";
但是Jsp页面返回的结果却是
id 服务提供商Id 数据类型 时间 数据
12 2 获取 2010-11-09 b
12 2 获取 2010-11-09 b
<%@ page language="java" import="java.util.Vector" pageEncoding="gb2312"%>
<jsp:useBean id="db_conn" class="cn.com.ctsi.util.DB_Conn" scope="session"/>
<jsp:useBean id="A" class="cn.com.ctsi.JavaBean.A" scope="session"/>
<%
String supplierId;
String Type;
int supplierid_int;
%>
<%
//获得传递过来的多个查询参数信息
supplierId = request.getParameter("supplierid");
supplierid_int = java.lang.Integer.parseInt(supplierId);
byte[] b= request.getParameter("type").getBytes("ISO8859_1");
Type = new String(b,"GBK");
System.err.println("type=" + Type);String sql = "select id,supplierid,type,shijian,data from a ";//拼接 id 条件
if(supplierId!="")
{ sql=sql+" where supplierid="+supplierid_int+" ";
}
%>
<%
if(Type!="")
{ if(sql.indexOf("where")==-1)
{
sql=sql+" where type='"+Type+"' ";
}
else
{
sql=sql+"and type='"+Type+"' ";
}
}
//执行拼接好的SQL,得到组合查询结果
db_conn.ConnectDB();
java.sql.ResultSet rs=db_conn.sm.executeQuery(sql);
Vector vector=new Vector();
while(rs.next())
{
cn.com.ctsi.JavaBean.A a = new cn.com.ctsi.JavaBean.A();
A.setId(rs.getInt("id"));
A.setSupplierid(rs.getInt("supplierid"));
A.setType(rs.getString("type"));
A.setShijian(rs.getDate("shijian"));
A.setData(rs.getString("data"));
vector.addElement(a);
}%>
<br>
<center>商品组合查询结果如下所示:</center>
<br>
<hr color="#000032" size=2 width=90%>
<br>
<table bgcolor="#ffecff" align=center border=1 cellspacing=0 width=88%>
<tr bgcolor="#cc99cc">
<td align=center>id</td><td align=center>服务提供商Id</td>
<td align=center>数据类型</td><td align=center>时间</td>
<td align=center>数据</td>
</tr>
<%
for(int i=0;i<vector.size();i++)
{
cn.com.ctsi.JavaBean.A a=(cn.com.ctsi.JavaBean.A)vector.elementAt(i);
%>
<tr>
<td align=center><font size=2>
<%out.print(A.getId()+"");%></font></td>
<td align=center><font size=2>
<%out.print(A.getSupplierid()+"");%></font></td>
<td align=center><font size=2>
<%out.print(A.getType());%></font></td>
<td align=center><font size=2>
<%out.print(A.getShijian().toString());%></font></td>
<td align=center><font size=2>
<%out.print(A.getData());%></font></td>
<%}%>
</table>
<br>
<center>
<a href="combo_query.jsp">继续查询</a>
</center>
是什么原因呢?请高手帮忙看看!好吧?跪谢了!就剩这点分了,都拿出来了!谢谢!
select id,supplierid,type,shijian,data from a where supplierid=2 and type="获取";
但是Jsp页面返回的结果却是
id 服务提供商Id 数据类型 时间 数据
12 2 获取 2010-11-09 b
12 2 获取 2010-11-09 b
<%@ page language="java" import="java.util.Vector" pageEncoding="gb2312"%>
<jsp:useBean id="db_conn" class="cn.com.ctsi.util.DB_Conn" scope="session"/>
<jsp:useBean id="A" class="cn.com.ctsi.JavaBean.A" scope="session"/>
<%
String supplierId;
String Type;
int supplierid_int;
%>
<%
//获得传递过来的多个查询参数信息
supplierId = request.getParameter("supplierid");
supplierid_int = java.lang.Integer.parseInt(supplierId);
byte[] b= request.getParameter("type").getBytes("ISO8859_1");
Type = new String(b,"GBK");
System.err.println("type=" + Type);String sql = "select id,supplierid,type,shijian,data from a ";//拼接 id 条件
if(supplierId!="")
{ sql=sql+" where supplierid="+supplierid_int+" ";
}
%>
<%
if(Type!="")
{ if(sql.indexOf("where")==-1)
{
sql=sql+" where type='"+Type+"' ";
}
else
{
sql=sql+"and type='"+Type+"' ";
}
}
//执行拼接好的SQL,得到组合查询结果
db_conn.ConnectDB();
java.sql.ResultSet rs=db_conn.sm.executeQuery(sql);
Vector vector=new Vector();
while(rs.next())
{
cn.com.ctsi.JavaBean.A a = new cn.com.ctsi.JavaBean.A();
A.setId(rs.getInt("id"));
A.setSupplierid(rs.getInt("supplierid"));
A.setType(rs.getString("type"));
A.setShijian(rs.getDate("shijian"));
A.setData(rs.getString("data"));
vector.addElement(a);
}%>
<br>
<center>商品组合查询结果如下所示:</center>
<br>
<hr color="#000032" size=2 width=90%>
<br>
<table bgcolor="#ffecff" align=center border=1 cellspacing=0 width=88%>
<tr bgcolor="#cc99cc">
<td align=center>id</td><td align=center>服务提供商Id</td>
<td align=center>数据类型</td><td align=center>时间</td>
<td align=center>数据</td>
</tr>
<%
for(int i=0;i<vector.size();i++)
{
cn.com.ctsi.JavaBean.A a=(cn.com.ctsi.JavaBean.A)vector.elementAt(i);
%>
<tr>
<td align=center><font size=2>
<%out.print(A.getId()+"");%></font></td>
<td align=center><font size=2>
<%out.print(A.getSupplierid()+"");%></font></td>
<td align=center><font size=2>
<%out.print(A.getType());%></font></td>
<td align=center><font size=2>
<%out.print(A.getShijian().toString());%></font></td>
<td align=center><font size=2>
<%out.print(A.getData());%></font></td>
<%}%>
</table>
<br>
<center>
<a href="combo_query.jsp">继续查询</a>
</center>
是什么原因呢?请高手帮忙看看!好吧?跪谢了!就剩这点分了,都拿出来了!谢谢!
解决方案 »
- ie7(8)改变弹出窗口大小
- jsp关于<%! %>和<% %>问题,急求解答!
- 获取session值的问题最新
- 购物车 支付
- strust validitor 的错误大家帮忙
- tomcat如何限制同一IP在一定时间段内对服务器的多次访问.
- struts2如何对oracle的long raw进行上传和下载呢
- 我收集了300M左右的Jbuilder文档,有兴趣的快来拉,请注明是那一方面的
- help!-- 如何得到数据集得列数
- applet接收来自Javabean的数据怎么办,各位老兄老弟请帮忙出个点子!我先谢谢了!!!
- dw框架、EXTJS框架如何搭建
- 大家有没有试过将返回的数据放入http头部的meta元素之中?
select id,supplierid,type,shijian,data from a where supplierid=2 and type="获取";
查出来的是
ID SUPPLIERID TYPE SHIJIAN DATA
--- ---------- -------------------- ------------------- -----------
2 2 获取 2010-11-10 13:40:00 b
12 2 获取 2010-11-09 13:40:00 b
是对的,但页面是
id 服务提供商Id 数据类型 时间 数据
12 2 获取 2010-11-09 b
12 2 获取 2010-11-09 b
具体是什么错误,还请帮忙看看上面jsp代码部分!跪谢!