lybbs_7.1to7.2.jsp

目前最流行的JSP论坛源码! 采用JSP+Servlet+Bean+MySql

        prestmt1.setByte(22,boldCode);
        prestmt1.setInt(23,lastAuthorID);
        prestmt1.setString(24,lastAuthor);
        prestmt1.setInt(25,lastPostAt);
        prestmt1.setString(26,lastPostClue);
        dbConnect.executeUpdate(prestmt1);
      
        prestmt2.setInt(1,postID);
        prestmt2.setInt(2,forumID);
        prestmt2.setInt(3,userID);
        prestmt2.setString(4,userName);
        prestmt2.setString(5,title);
        prestmt2.setString(6,content);
        prestmt2.setInt(7,DateUtils.getMillisToSeconds(postAt));
        prestmt2.setTimestamp(8,DateUtils.getTimestamp(postAt));
        prestmt2.setString(9,postIp);
        prestmt2.setString(10,titleIcon);
        prestmt2.setByte(11,accessary);
        prestmt2.setInt(12,clickTimes);
        prestmt2.setInt(13,replyNum);
        prestmt2.setInt(14,voteNum);
        prestmt2.setByte(15,lockTop);
        prestmt2.setInt(16,lockTopID);
        prestmt2.setByte(17,lockReply);
        prestmt2.setByte(18,lockVote);
        prestmt2.setByte(19,vote);
        prestmt2.setByte(20,voteCondition);
        prestmt2.setByte(21,elite);
        prestmt2.setByte(22,invisible);
        prestmt2.setByte(23,showSign);
        prestmt2.setString(24,color);
        prestmt2.setByte(25,boldCode);
        prestmt2.setByte(26,viewMode);
        prestmt2.setInt(27,viewNumber);
        prestmt2.setInt(28,0);
        prestmt2.setString(29,"");
        prestmt2.setInt(30,0);
        prestmt2.setString(31,"");
        dbConnect.executeUpdate(prestmt2);
      }
      else {
        prestmt3.setInt(1,postID);
        prestmt3.setInt(2,forumID);
        prestmt3.setInt(3,topicID);
        prestmt3.setInt(4,userID);
        prestmt3.setString(5,userName);
        prestmt3.setString(6,title);
        prestmt3.setString(7,content);
        prestmt3.setInt(8,DateUtils.getMillisToSeconds(postAt));
        prestmt3.setTimestamp(9,DateUtils.getTimestamp(postAt));
        prestmt3.setString(10,postIp);
        prestmt3.setString(11,titleIcon);
        prestmt3.setByte(12,accessary);
        prestmt3.setByte(13,invisible);
        prestmt3.setByte(14,showSign);
        prestmt3.setByte(15,viewMode);
        prestmt3.setInt(16,viewNumber);
        prestmt3.setInt(17,0);
        prestmt3.setString(18,"");
        prestmt3.setInt(19,0);
        prestmt3.setString(20,"");
        dbConnect.executeUpdate(prestmt3);
      }
    }
    out.println("<br>postID:"+postID+"&nbsp;&nbsp;total:"+maxPostID);
    if(postID==0){zeroTimes++;} else{zeroTimes=0;}
    if(maxPostID<=postID){out.println("<script>finished=true;</script>");}
  }
  else if(step==6) {
    //更新用户表的blogID列

    int maxBlogID=0;
    prestmt4=dbConnect.createPreparedStatement("select max(id) from lyblog_blog");
    rs=dbConnect.executeQuery(prestmt4);
    if(rs.next()) {maxBlogID=rs.getInt(1);}
    rs.close();

    int blogID=0;
    int userID=0;
    prestmt1=dbConnect.createPreparedStatement("update lybbs_author set blogid=? where id=?");
    
    prestmt2=dbConnect.createPreparedStatement("select id,userid from lyblog_blog where id>"+offset+" and id<="+to);
    rs=dbConnect.executeQuery(prestmt2);
    while(rs.next()) {
      blogID=rs.getInt(1);
      userID=rs.getInt(2);

      prestmt1.setInt(1,blogID);
      prestmt1.setInt(2,userID);
      dbConnect.executeUpdate(prestmt1);
    }
    out.println("<br>blogID:"+blogID+"&nbsp;&nbsp;total:"+maxBlogID);
    if(blogID==0){zeroTimes++;} else{zeroTimes=0;}
    if(maxBlogID<=blogID){out.println("<script>finished=true;</script>");}
  }
  out.println("<script>if(finished) {document.write('<br><b>All Finished.</b>');} else {document.write('<br><b>Convert success!</b>');}</script>");
}
catch(Exception ex) {
  out.println("&nbsp;&nbsp;&nbsp;&nbsp;Convert error:"+ex.toString());
  out.println("<script>notErrorOccurs=false;</script>");
}
finally {
  if(dbConnect!=null) {
    dbConnect.closeResultSet(rs);
    dbConnect.closePreStmt(prestmt1);
    dbConnect.closePreStmt(prestmt2);
    dbConnect.closePreStmt(prestmt3);
    dbConnect.closePreStmt(prestmt4);
    dbConnect.close();
  }
}
%>
<br><br>
<form action="lybbs_7.1TO7.2.jsp" name="myform" method="post">
<input type=hidden name="notFirstTime" value="true">
<input type=hidden name="zeroTimes" value="<%=zeroTimes%>">
step:
  <select name=step onchange="resetOffset(this.options[this.selectedIndex].value)">
   <option value="1" <%if(step==1)out.print("selected");%>>step1-clear</option>
   <option value="2" <%if(step==2)out.print("selected");%>>step2-notuse</option>
   <option value="3" <%if(step==3)out.print("selected");%>>step3-replytitle</option>
   <option value="4" <%if(step==4)out.print("selected");%>>step4-uploadtitle</option>
   <option value="5" <%if(step==5)out.print("selected");%>>step5-posts</option>
   <option value="6" <%if(step==6)out.print("selected");%>>step6-blogid</option>
  </select>
Offset:<input type=text name="offset" value="<%=to%>" size=10>&nbsp;
Limit:<input type=text name="limit" value="<%=(limit==0)?2000:limit%>" size=10>&nbsp;&nbsp;<span id="timeStr"></span>&nbsp;
<input type=button name=mysubmit value="Submit" onclick="disabledButton()">
&nbsp;&nbsp;
<input type=button name=mybutton value="Pause" onclick="pauseTime()">
</form>
<script language="JavaScript">
  function resetOffset(step) {
   document.myform.offset.value="0";
   document.myform.zeroTimes.value="0";
   if(step==2) {
     document.myform.limit.value="5000";
   }
   else if(step==3) {
     document.myform.limit.value="2000";
   }
   else if(step==4) {
     document.myform.limit.value="5000";
   }
   else if(step==5) {
     document.myform.limit.value="2000";
   }
   else if(step==6) {
     document.myform.limit.value="1000";
   }
   else {
     document.myform.limit.value="50";
   }
  }
  var i=4;
  var pause=false;
  var objTimePost;
  function pauseTime() {
    if(pause) {
      //continue
      timeValidate()
      document.myform.mybutton.value="Pause";
      pause=false;
    }
    else {
      //pause
      window.clearInterval(objTimePost)
      document.myform.mysubmit.disabled=false;
      document.myform.mybutton.value="Continue";
      pause=true;
    }
  }
  function timePost() {
    if(i==0) {
      window.clearInterval(objTimePost);
      document.getElementById("timeStr").innerHTML=i;
      disabledButton();
    }
    else {
      document.getElementById("timeStr").innerHTML=i;
      if(i==2) {
        document.myform.mysubmit.disabled=true;
        document.myform.mybutton.disabled=true;
      }
      i--;
    }
  }
  function disabledButton() {
    window.clearInterval(objTimePost);
    document.myform.mysubmit.disabled=true;
    document.myform.submit();
  }
  var notFirstTimejs=<%=notFirstTime%>;
  var zeroTimes=<%=zeroTimes%>;
  if(!notErrorOccurs) {window.focus();}
  timeValidate();
  function timeValidate() {
    if(notFirstTimejs && !finished && zeroTimes<=2 && notErrorOccurs) {
      objTimePost=window.setInterval("timePost()", 1000);
    }
  }
  if(zeroTimes>2 || finished) {
    //next
    var nextStep=document.myform.step.options[document.myform.step.selectedIndex+1];
    if(nextStep!=null) {
      //start next
      i=20;
      nextStep.selected=true;
      resetOffset(nextStep.value);
      zeroTimes=0;
      finished=false;
      timeValidate();
      document.getElementById("timeStr").innerHTML="Single Finished";
    }
    else {
      //disvalidate submit
      document.myform.mysubmit.disabled=true;
      document.myform.mybutton.disabled=true;
      document.getElementById("timeStr").innerHTML="All Finished";
    }
  }
</script>