String sql="select * from tablename";
while(rs.next())
{
id=rs.getInt("id");
if(id%100==0){
String name=rs.getString("name");
out.print("<li><a href='#' onmouseover='cssdropdown.dropit(this,event,'dropmenu"+id+"')'>"+name+"</a></li>");
}//if
}//while rs.close();
rs=null;
rs = op.getdb(sql);
while(rs.next())
{
int id=rs.getInt("id");
if(id%100==0){
String sql1="select * from mainlmgl where id>"+id+" and id<"+(id+100);
ResultSet rs2=op.getdb(sql1);
if(rs2.next()){
out.print("<div id='dropmenu"+id+"' class='dropmenudiv'>");
out.print("<a href='#'>"+rs2.getString("name")+"</a>");
while(rs2.next()){
out.print("<a href='#'>"+rs2.getString("name")+"</a>");
}
out.print("</div>");
}
rs2.close();
rs2=null;
}
}
while(rs.next())
{
id=rs.getInt("id");
if(id%100==0){
String name=rs.getString("name");
out.print("<li><a href='#' onmouseover='cssdropdown.dropit(this,event,'dropmenu"+id+"')'>"+name+"</a></li>");
}//if
}//while rs.close();
rs=null;
rs = op.getdb(sql);
while(rs.next())
{
int id=rs.getInt("id");
if(id%100==0){
String sql1="select * from mainlmgl where id>"+id+" and id<"+(id+100);
ResultSet rs2=op.getdb(sql1);
if(rs2.next()){
out.print("<div id='dropmenu"+id+"' class='dropmenudiv'>");
out.print("<a href='#'>"+rs2.getString("name")+"</a>");
while(rs2.next()){
out.print("<a href='#'>"+rs2.getString("name")+"</a>");
}
out.print("</div>");
}
rs2.close();
rs2=null;
}
}
单引号里面 嵌 单引号,当然不行,里面改为双引号('dropmenu"+id+"'部分)
用\"转意一下,应该可以
--------------------------------------------------------------------------------
国内第一款“无端网游”,不用下客户端点击链接立即开始玩网游。http://pet.mop.com/?u=8094002来了找精灵之森(网通)的小麦兜儿,就是我!用Mop的ID就能玩的
--------------------------------------------------------------------------------