if (sqlRst != null)
{
int i = 0;
while (sqlRst.next()){
String[] sList = new String[2];
product_kind=sqlRst.getString ("product_kind");
product_kind_name=sqlRst.getString ("product_kind_name");
sList[0]=product_kind;
sList[1]=product_kind_name;
//out.print(sList[0]+sList[1]);
list.add(sList);//ArrayList:小类
}
}
%>
<%sqlRst=sqls.executeQuery(sql);
if (sqlRst != null)
{
int i = 0;
while (sqlRst.next()){
String[] sList = new String[2];
product_kind=sqlRst.getString ("product_kind");
product_kind_name=sqlRst.getString ("product_kind_name");
sList[0]=product_kind;
sList[1]=product_kind_name;
//out.print(sList[0]+sList[1]);
list1.add(sList);//ArrayList:大类
function OnScnyStyleChange(scnyValue)
{
switch(scnyValue)
{
case '0':
var labels = new Array("请选择");
var values = new Array("0");
tableCell1.innerHTML='';
tableCell2.innerHTML='';
break;
case '1':
var labels = new Array("请选择");
var values = new Array("0");
tableCell1.innerHTML='';
tableCell2.innerHTML='';
break;
case '2':
var labels = new Array("请选择");
var values = new Array("0");
tableCell1.bgcolor='#f4f7fa';
tableRow1.style.display="block";
tableCell1.innerHTML=' 会议结束日期:';
tableCell2.innerHTML='<input type="text" name="COM_MEETING.END_DATE" id=endDate size="13" maxlength=10>';
break;
case '3':
var labels = new Array("请选择","星期一","星期二","星期三","星期四","星期五","星期六","星期天");
var values = new Array("0","1","2","3","4","5","6","7");
tableRow1.style.display="block";
tableCell1.bgcolor='#f4f7fa';
tableCell1.innerHTML=' 会议结束日期:';
tableCell2.innerHTML='<input type="text" name="enddate1" id=endDate size="13" maxlength=10>';
break;
case '4':
var labels = new Array("请选择","1号","2号","3号","4号","5号","6号","7号","8号","9号","10号","11号","12号","13号","14号","15号","16号","17号","18号","19号","20号","21号","22号","23号","24号","25号","26号","27号","28号","29号","30号","31号");
var values = new Array("0","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31");
tableRow1.style.display="block";
tableCell1.bgcolor='#f4f7fa';
tableCell1.innerHTML=' 会议结束日期:';
tableCell2.innerHTML='<input type="text" name="enddate1" id=endDate size="13" maxlength=10>';
break;
}
// 清空市列表选择框的内容
document.meetingAdd.scnyTime.options.length = 0;
// 从数组中添加内容
for(var i = 0; i < labels.length; i++)
{
document.meetingAdd.scnyTime.add(document.createElement("OPTION"));
document.meetingAdd.scnyTime.options[i].text=labels[i];
document.meetingAdd.scnyTime.options[i].value=values[i];
}
document.meetingAdd.scnyTime.selectedIndex = 0;