questionview.java

它是利用jsp+javabean来编写的

/*
 * QuestionView.java
 *
 * Created on 2006年8月10日, 下午6:35
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package ACTION;
import java.io.UnsupportedEncodingException;
import java.sql.*;
import PUBLIC.TestSql;
/**
 *
 * @author fish
 */
public class QuestionView extends TestSql{
    String Result="无法显示该内容";
    int QuestionID;
    String UserName=null;
    public QuestionView() {
        //rs=null;
    }
    public void setView(String newid){  //获得题目编号
        QuestionID=Integer.parseInt(newid);
    }
    public void setUserName(String s){  //获得答案递交者的用户名
        UserName=s.trim(); 
    }
    public String getView(){
            ResultSet rs = null;
            StringBuffer buffer=new StringBuffer(); //建立缓存空间
            String condition;
            String QuestionContents;
            Time QuestionTime;
        try {
            condition="SELECT * FROM TestQuestion WHERE QuestionID="+QuestionID; //查找表[TestQuestion]中的指定题目
            rs=sql.executeQuery(condition);
        } catch (SQLException ex) {
            buffer.append("题目不存在");
            ex.printStackTrace();
        }
        try {
            while (rs.next()){  //将记录集中的数据依次读取出来
                QuestionContents=rs.getString("QuestionContents");
                QuestionTime=rs.getTime("QuestionTime");
                buffer.append("编号:"+QuestionID+"  "); //建立HTML内容
                buffer.append("发布时间:"+QuestionTime+"<br><br>");
                buffer.append("题目内容:"+QuestionContents+"<br><br>");
            }
        } catch (SQLException ex) {
            buffer.append("RsWrong");
            ex.printStackTrace();
        }
        Result=new String(buffer);  //将缓存中的内容转化为字符串并赋值给result
        return Result;
    }
    
    public String getAnswer(){
        ResultSet rs=null;
        int i=0;
        StringBuffer buffer=new StringBuffer(); //建立缓存空间
        String condition;
         //取出数据库中已经递交过的用户列表
        try {
                condition="SELECT AnswerUser FROM TestAnswer WHERE AnswerQuestionID="+QuestionID;
                rs=sql.executeQuery(condition);
                while(rs.next())
                    if(UserName.equals(rs.getString("AnswerUser").trim()))
                        i++;    //将找到该用户的递交计数
            } catch (SQLException ex) {
                buffer.append("递交过的用户列表不存在");
                ex.printStackTrace();
            }
        //取出数据库中的答案
        try {
            condition="SELECT * FROM TestAnswer WHERE AnswerQuestionID="+QuestionID+" ORDER BY AnswerID DESC";
            rs=sql.executeQuery(condition);
        } catch (SQLException ex) {
            buffer.append("没有该题目答案");
            ex.printStackTrace();
        }
        
        try {   //建立HTML内容
            while(rs.next())
            {   
                buffer.append("<font color='#ff0000'>"+rs.getString("AnswerUser").trim());
                buffer.append("&nbsp;&nbsp;发表于:&nbsp;"+rs.getTime("AnswerTime")+"</font><br>");
                if(i==0){
                    buffer.append("由于您还没有回答该题,所以无法查看别人的回答<br><br>");
                }
                else
                {
                    buffer.append(rs.getString("AnswerContents")+"<br><br>");
                }
            }
        } catch (SQLException ex) {
            buffer.append("该题目答案查看失败");
            ex.printStackTrace();
        }
        Result=new String(buffer);
        return Result;
    }
}