operate.java

jsp入门级代码

package mybbs;
import java.sql.*;
public class Operate {

public  Operate(){
}
  //点击量加1
  public void UpdateClick_time(String fid,String tid){
    DBConn conn=new DBConn();
    try {
      String sql2 = "UPDATE posts SET click_times=click_times+1 WHERE forumid=" +
          fid + " AND topic_id=" + tid + " AND istopic>0";
      conn.update(sql2);
    }
    catch (Exception e) {
      System.out.print("点击量增加不成功："+e.toString());
    }
  }
  public void UpdateTotalPost(int fid){
    DBConn conn=new DBConn();
    try {
      String sql3 =
          "UPDATE forums SET total_post=total_post+1 WHERE id=" + fid;
      conn.update(sql3);
      conn.DBclose();
    }
    catch (Exception e) {
      System.out.print("话题总数增加不成功："+e.toString());
    }

}

    //分论坛总话题数加1
 public void UpdateTotalTopic(int fid){
   DBConn conn=new DBConn();
   try {
     String sql4 =
         "UPDATE forums SET total_topic=total_topic+1 WHERE id=" + fid;
     conn.update(sql4);
     conn.DBclose();
   }
   catch (Exception e) {
     System.out.print("话题总数增加不成功："+e.toString());
   }
   }
   public void UserTotalPost(int userid){
  DBConn conn=new DBConn();
  try {
    String sql5 =
        "UPDATE bbsuser SET totalpost=totalpost+1 WHERE id=" + userid;
    conn.update(sql5);
    conn.DBclose();
  }
  catch (Exception e) {
    System.out.print("用户发表话题总数增加不成功："+e.toString());
  }
  }



}