disvote.java

JSP论坛系统 数据库：mysql数据库； 技术平台：Tomcat 5.0服务器； 开发工具：Eclipse＋Lomboz、EditPlus开发工具； 操作系统：Windows XP Prof

package mybbs;
import java.sql.*;
import java.util.*;
public class DisVote{
 String postid;
 public void DisVote(){}
 public StringBuffer ShowVote(String postid){
     StringBuffer buffer=new StringBuffer();
     this.postid=postid;
     int total=0,iskey=0;
   try{
     DBConn conn=new DBConn();
     String sql1="SELECT * FROM vote WHERE iskey>0 AND postid="+postid;
     ResultSet rs1=conn.query(sql1);
       if(rs1.next()){
         iskey=rs1.getInt("iskey");
         total=rs1.getInt("result");
        }
       rs1.close();
       String sql2="SELECT * FROM vote WHERE iskey=0 AND postid="+postid;
       ResultSet rs2=conn.query(sql2);
       int j=1;
       while(rs2.next()){
         if(iskey<3){
            buffer.append("<TR><TD width='6%' align=right><INPUT type='radio' name='p' value='"+rs2.getString("keyid")+"'></TD>");
          }
         else{
            buffer.append("<TR><TD class=cbg><input type=checkbox name='checkb' value='"+rs2.getString("keyid")+"'></TD>");
          }
         buffer.append("<TD class=cbg width='34%'>"+rs2.getString("item")+"</TD>");
         int n1=0;
         float n2=0;
         if(rs2.getInt("result")!=0){
             n1=rs2.getInt("result")*100/total;
             n2=(float)rs2.getInt("result")*100/total;
          }
          buffer.append("<TD class=cbg width='60%'><IMG src='images/bar"+j+".gif' height=10 width='"+n1+"%'>"+n2+"%</TD>");
          if(iskey==2||iskey==4){
             StringTokenizer fenxi=new StringTokenizer(rs2.getString("voter"),"#");
             buffer.append("<TD class=cbg><SELECT>");
             while(fenxi.hasMoreTokens()){
                buffer.append("<option value=''>"+fenxi.nextToken());
             }
             buffer.append("</SELECT></TD>");
          }
          buffer.append("</TR>");
          buffer.append("<INPUT TYPE=hidden name=key value='"+iskey+"'>");
          j++;
          if(j==5)
             j=1;
          }
          rs2.close();
          conn.DBclose();
    }
    catch(Exception e){
    }
    return buffer;
}



}