lybbs_upgrade_6.4to6.5.jsp

常见的bbs源代码

<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="net.lybbs.util.*"%>
<%@ page import="net.lybbs.session.util.*"%>
<%@ page import="net.lybbs.db.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%
int step=ParameterUtils.getInt(request,"step");
int offset=ParameterUtils.getInt(request,"offset");
int limit=ParameterUtils.getInt(request,"limit");
int to=offset+limit;


out.println("<br>");
out.println("Next upgrade from 6.4 to 6.5, if connection failed, please check test.jsp first:<br>");
DBConnect dbConnect=null;
PreparedStatement prestmt1=null;
PreparedStatement prestmt2=null;
PreparedStatement prestmt3=null;
ResultSet rs1=null;
ResultSet rs2=null;
try {
  dbConnect=DBConnectManager.getInstance().getDBConnect();
  dbConnect.createConnection();
  if(step==1) {
    int userID=0;
    long lastPostTime;
    prestmt1=dbConnect.createPreparedStatement("update lybbs_author set lastposttime=? where id=?");
    
    prestmt2=dbConnect.createPreparedStatement("select id from lybbs_author where id>"+offset+" and id<="+to);
    prestmt3=dbConnect.createPreparedStatement("select max(lastpostat) from lybbs_posts where lastauthorid=?");
    rs1=dbConnect.executeQuery(prestmt2);
    while(rs1.next()) {
      userID=rs1.getInt(1);
      prestmt3.setInt(1,userID);
      rs2=dbConnect.executeQuery(prestmt3);
      if(rs2.next()) {
        lastPostTime=rs2.getLong(1);
        prestmt1.setLong(1,lastPostTime);
        prestmt1.setInt(2,userID);
        dbConnect.executeUpdate(prestmt1);
      }
    }
    out.println("<br>userID:"+userID);
  }
  out.println("<br><b>Upgrade success!</b>");
}
catch(Exception ex) {
  out.println("&nbsp;&nbsp;&nbsp;&nbsp;Upgrade error:"+ex.toString());
}
finally {
  if(dbConnect!=null) {
    dbConnect.closeResultSet(rs1);
    dbConnect.closeResultSet(rs2);
    dbConnect.closePreStmt(prestmt1);
    dbConnect.closePreStmt(prestmt2);
    dbConnect.closePreStmt(prestmt3);
    dbConnect.close();
  }
}
%>
<br><br>
<form action="lybbs_upgrade_6.4to6.5.jsp" name="myform" method="post">
step:<select name=step>
	    <option value="1" <%if(step==1)out.print("selected");%>>step1</option>
	   </select>
Offset:<input type=text name="offset" value="<%=to%>" size=10>&nbsp;
Limit:<input type=text name="limit" value="<%=(limit==0)?200:limit%>" size=10>&nbsp;&nbsp;
<input type=button name=mysubmit value="Submit" onclick="disabledButton()">
</form>
<script language="JavaScript">
  function disabledButton() {
    document.myform.mysubmit.disabled=true;
    document.myform.submit();
  }
</script>