以下是我的代码(实际字段和商品名、购买日期、数量不同): <script language = "JavaScript"> var onecount; onecount=0; subcat = new Array(); <% //省略取系统当前日期int count = 0; rsym = conn.executeQuery("select jh,to_char(csrq,'YYYY/MM/DD') as time,jym,dym from dca02 where (to_date('"+now+"','yyyy/mm/dd')-200)<=csrq order by jh");//读取数据 while(rsym.next()) { String sname=new String(rsym.getString("jh").getBytes("GBK"),"ISO8859_1");//转换字符类型 %> subcat[<%=count%>] = new Array("<%=sname%>","<%=rsym.getString("time")%>","<%=rsym.getFloat("jym")%>","<%=rsym.getFloat("dym")%>");//产生数组 <% count = count + 1; } %> onecount=<%=count%>;
function changelocation1(id) { document.myform.jym.length = 0;
var id=id; var i; var hj; document.myform.jym.options[0] = new Option('请选择***',''); for (i=0;i < onecount; i++) { if (subcat[i][0] == id) { hj=subcat[i][0]+"|"+subcat[i][1]+"|"+subcat[i][2]; document.myform.jym.options[document.myform.jym.length] = new Option(hj,subcat[i][2]); } } } function changelocation2(id) { document.myform.dym.length = 0;
var id=id; var i; document.myform.dym.options[0] = new Option('请选择***',''); for (i=0;i < onecount; i++) { if (subcat[i][1] == id) { document.myform.dym.options[document.myform.dym.length] = new Option(subcat[i][0], subcat[i][0]); } } } </script>
是不是一起显示成一行
可以这样你做成一个javabean用来连数据库,那个String sql="select concat("商品名","日期","变量") from tablename;
<%while(rs.next())
{
%>
<select name=select>
<option value=rs.getString("xx")><%=rs.getString("XX")%></option>
呵呵,写得乱自己参考一下
把 下拉列表框作为Editor加进去
<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<%
//省略取系统当前日期int count = 0;
rsym = conn.executeQuery("select jh,to_char(csrq,'YYYY/MM/DD') as time,jym,dym from dca02 where (to_date('"+now+"','yyyy/mm/dd')-200)<=csrq order by jh");//读取数据
while(rsym.next())
{
String sname=new String(rsym.getString("jh").getBytes("GBK"),"ISO8859_1");//转换字符类型
%>
subcat[<%=count%>] = new Array("<%=sname%>","<%=rsym.getString("time")%>","<%=rsym.getFloat("jym")%>","<%=rsym.getFloat("dym")%>");//产生数组
<%
count = count + 1;
}
%>
onecount=<%=count%>;
function changelocation1(id)
{
document.myform.jym.length = 0;
var id=id;
var i;
var hj;
document.myform.jym.options[0] = new Option('请选择***','');
for (i=0;i < onecount; i++)
{
if (subcat[i][0] == id)
{
hj=subcat[i][0]+"|"+subcat[i][1]+"|"+subcat[i][2];
document.myform.jym.options[document.myform.jym.length] = new Option(hj,subcat[i][2]);
}
}
}
function changelocation2(id)
{
document.myform.dym.length = 0;
var id=id;
var i;
document.myform.dym.options[0] = new Option('请选择***','');
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == id)
{
document.myform.dym.options[document.myform.dym.length] = new Option(subcat[i][0], subcat[i][0]);
}
}
} </script>