急求 JSP 显示数据库信息页面的解决

Question

问题好象不少啊
"Syntax error on token "finally", { expected"bean里面吧吧　少了个"{"
bean里边对ResultSet　指针调整了么（rs.next()）？
"Syntax error on token "catch", Identifier expected"bean里面的try catch块也不完整吧

Answer 1

把bean贴出来算了,不介意的话

Answer 2

<td><% out.print(rb[0].getRepairName()); %></td>
<td><% out.print(rb[0].getUserName()); %></td>
<td><% out.print(rb[0].getTel()); %></td>
<td><% out.print(rb[0].getDepartment()); %></td>
<td><% out.print(rb[0].getTroubleInfo()); %></td>
改为
<td><%=rb[0].getRepairName()%></td>
<td><%=rb[0].getUserName()%></td>
<td><%=rb[0].getTel()%></td>
<td><%=rb[0].getDepartment()%></td>
<td><%=rb[0].getTroubleInfo()%></td>
还有就是你的try catch有点问题似的

Answer 3

ackage servlet;
/** 实现向repair表中插入新的纪录
*/
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import bean.*;public class ShowServlet extends HttpServlet{ private static final String CONTENT_TYPE = "text/html; charset=GBK";
//输出是指定字符集
//Initialize global variables
public void init()  throws ServletException
{
}//Process the HTTP Get request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{   
   response.setContentType("text/html; charset=GBK");
   
    DataBean db = new DataBean();
    //RepairBean rb= new RepairBean();
    RepairBean[] resultset =db.ShowRepair();
    PrintWriter out = response.getWriter();
    out.print("repairname");
    
    request.setAttribute("resultset", resultset);
    RequestDispatcher rd = request.getRequestDispatcher("list.jsp");
    rd.forward(request, response); 
   
}//Process the HTTP Post request
public void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException
{
    doPost(request, response);
}//Clean up resources
public void destroy()
{
}}--------------------------------------------------------DataBean中 关于本ShowServlet中的部分
public RepairBean[] ShowRepair()    /** 显示repair表中的纪录*/
{
    //DataBean db = new DataBean();
RepairBean rb[] = null;
    int rsNumber = 0; //返回纪录数
    String sql="SELECT * FROM repair where rightorno='0'";//查询未解决的故障的信息
    try
      {
          //this.prepar = conn.prepareStatement(sql);
       Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                  ResultSet.CONCUR_UPDATABLE);
          ResultSet rs = stmt.executeQuery(sql);
          //int result = prepar.executeUpdate();  
         
             
   
          if (rs != null){
           rs.last();
           rsNumber = rs.getRow();
           //System.out.print(rsNumber);
           rb = new RepairBean[rsNumber];
           for(int i=0; i<rsNumber; i++){
           rb[i] = new RepairBean();
           }
           rs.first();
           for(int i=0; i<rsNumber; i++){
           rb[i].setId(rs.getString("id"));
           rb[i].setRepairName(rs.getString("repairname"));
           rb[i].setUserName(rs.getString("username"));
           rb[i].setDepartment(rs.getString("department"));
           rb[i].setTel(rs.getString("tel"));
           rb[i].setTroubleInfo(rs.getString("troubleinfo"));
           rs.next();        
              }
        
         
          }//else System.out.println("sadfsaf");
                  
      }
      catch(SQLException e){ e.printStackTrace();}
      return rb;    
}

Answer 4

回复 kurtjob() 
非常感谢你的帮忙 我已经把showservlet 和DataBean中的部门代码 发上去了 
麻烦你帮我看看我用Elipse编写的 如果缺少“｛”的话 会报错的！

Answer 5

RepairBean检查一下里面定义的数组和for循环有没有问题
for(int i=0; i<rsNumber; i++){
          rb[i].setId(rs.getString("id"));
          rb[i].setRepairName(rs.getString("repairname"));
          rb[i].setUserName(rs.getString("username"));
          rb[i].setDepartment(rs.getString("department"));
          rb[i].setTel(rs.getString("tel"));
          rb[i].setTroubleInfo(rs.getString("troubleinfo"));
          rs.next();       
              }然后看看jsp页面第７７行

Answer 6

问题已经解决 是jsp页面中for循环 阻挡了编译  现已经解决
新的修改为
 <% if (rb != null) {  for(int i=0;i<rb.length;i++){%>
  <tr>
            <td><%out.print(rb[i].getId()); %></td>
            <td><%out.print(rb[i].getRepairName()); %></td>
            <td><%out.print(rb[i].getUserName()); %></td>
            <td><%out.print(rb[i].getDepartment()); %></td>
            <td><%out.print(rb[i].getTel()); %></td>
            <td><%out.print(rb[i].getTroubleInfo());} }%></td>
感谢各位的帮忙，付出就有收获，虽然你们只问耕耘，但我说到做到分给你们
再次感谢你们的帮助   非常感谢！！！