<%@ page contentType="text/html;charset=gb2312" %>
<%@ include  file="check.jsp" %>
<%@ page import="java.util.*" %>        
<%

   if(!sqlbean.isOk()) out.println("沒有可用的連接");
                String key1="";
                if(request.getParameter("key1")!=null){
                        key1 = request.getParameter("key1");
                }
                String tb1 = this.col;
                if(request.getParameter("tb1")!=null){
                        tb1=request.getParameter("tb1");
                }
                int curpage=1;
                if(request.getParameter("curpage")!=null){
                        curpage=Integer.parseInt(request.getParameter("curpage"));
                }
                
                out.println ("<table width=100% border=1 cellspacing=0 cellpadding=0 bordercolorlight=#666666 bordercolordark=#ffffff bgcolor=#d6d3ce>");
                out.println ("<TBODY><TR><TD bgColor=#eaeaea>");
                out.println ("<table width=100% border=0 cellspacing=0 cellpadding=0 bordercolorlight=#666666 bordercolordark=#ffffff bgcolor=#d6d3ce> ");
                out.println ("<TBODY><TR bgcolor=#222222><TD class=heading>");
                out.println ("<FONT color=#ffffff><B>"+title+"</B></FONT></td>");
                out.println ("<td align=right>");
                if(url.indexOf ("learn")==-1&& grade==dgrade){ 
                        out.println ("<a href=\"#\" onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('Image11','','images/add_on.gif',1)\" onClick=\"MM_openBrWindow('"+eurl+"?op=1','','width=500,height=400')\"><img border=0  name=Image11 src='images/add_off.gif'></a>");
                }
                out.println ("</td></tr></table>");

                //data header
            out.println("<table width=100% border=1 cellspacing=0 cellpadding=0 bordercolorlight=#666666 bordercolordark=#ffffff bgcolor=#d6d3ce>");
                out.println("<tr bgcolor=#bfbfbf>");            
                
                String sql = "select * from colname where tbname=\""+this.table+"\" order by ID";       
                sqlbean.executeQuery (sql);
                int total1 = sqlbean.getTotalNum();
                int total = 0;
                String[] colname = new String [total1];
                //out.println (sql+" total1="+total1);          

                if(total1>0){                   
                        do{             
                                if(sqlbean.getInt ("isindex")==1){
                                        out.println ("<TD ><b>"+sqlbean.getString ("gb2312")+"</b></TD>");
                                        colname[total]=sqlbean.getString ("tbcol");
                                        total ++;
                                }       
                                if(total>5)break;
                        }while(sqlbean.next ());
                }               
                
                out.println ("<TD ><b>編 輯</b></TD></TR>");
                
                if(extend.length ()>1){
                        sql ="select * from "+table+" where "+tb1+" like \"%"+sqlbean.to_8859_1(key1)+"%\" and "+extend+" ORDER BY ID desc";
                }else{
                        sql ="select * from "+table+" where "+tb1+" like \"%"+sqlbean.to_8859_1(key1)+"%\" ORDER BY ID desc";
                }
                sqlbean.executeQuery(sql);
                totalnum = sqlbean.getTotalNum();
                mypage.Init(curpage,totalnum,pagesize);
                
                //out.println ("<tr><td colspan="+(total+1)+">");
                
                int pagecount = mypage.getTotalpage();
                int first = mypage.getFirst();
                //out.println("sql="+sql+"pcont="+pagecount);
                //out.println(" lstart="+mypage.getFirst());
                //out.println(" total="+total);
                //for(int q=0;q<total;q++) out.println (colname[q]);
                //out.println("</td></tr>");
                
                int count =1;
                
                if(totalnum>0){
                        //sqlbean.absolute(first);
                        count = 1;
                        
                        String ttmp,tmp ="",ID;
                        boolean isUrl=false;
                        
                        while(sqlbean.next()){
                                ID = sqlbean.getString("ID");
                                out.println ("<TR>");
                                for(int t =0;t<total;t++){
                                        out.println ("<td bgColor=#efefef  align=left>");
                                        ttmp = sqlbean.getString(colname[t]); 
                                        if(ttmp.startsWith("http://")){
                                                tmp = "<a href='"+ttmp+"' target=blank>";       
                                                isUrl = true;
                                        }
                                        if(t<1 && !isUrl){
                                                tmp = "<a href='#' onClick='MM_openBrWindow(\""+eurl+"?op=4&id="+ID+"\",\"\",\"width=400,height=300\")'>"; 
                                        }       
                                                
                                        if(ttmp.length()> 20) ttmp = ttmp.substring (0,20);                                     
                                        out.println (tmp+ttmp+(tmp.length()<2?"":"</a>")+"</td>");      
                                        tmp ="";
                                        if(t>5) break;
                                }       
                                
                                out.println ("<td align='center' bgColor=#efefef width=66>");
                                if(grade == dgrade){
                                        ttmp = eurl+"?op=5&id="+ ID;
                                        out.println("<a href='#' onClick='MM_openBrWindow(\""+ttmp+"\",\"\",\"width=400,height=300\")'>"); 
                                        out.println ("<img src='images/note1.gif' alt='查看詳細(xì)信息！' align=middle border=0></a>");
                                        out.println("<a href='"+eurl+"?op=3&id="+sqlbean.getInt("ID")+"' onclick='return cform();'>");
                                        out.println("<img border=0 src='images/dele_1.gif' alt='刪除此條信息！' align='absmiddle' width=15 height=15>");
                                        out.println("</td>");
                                }else{
                                        out.println ("&nbsp;&nbsp;");
                                }
                                if(url.compareTo ("userchk.jsp")==0){
                                        out.println ("<TD><b>用戶操作</b></TD>");                       
                                }

                                out.println ("</td>");                          
                                
                        }
                        
                }else{
                        out.println ("<tr><td colspan="+(total+1)+"><font color=red>里面沒有數(shù)據(jù)</font></td></tr>");
                }               

                out.println ("</TBODY></TABLE>");
                //page          
                out.println(mypage.printTable(url,tb1,key1));
                
                sqlbean.close();
                out.println(search.Init(url,table));
                out.println("</td></tr></table>");
%>