?? addbbs.java
字號(hào):
package com.service;
import java.io.IOException;
import java.io.PrintWriter;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.data.Bbs;
import com.db.*;
public class addbbs extends HttpServlet {
/**
* Constructor of the object.
*/
public addbbs() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/xml;charset=utf-8");
response.setHeader("Cache-Control","no-cache");
PrintWriter out = response.getWriter();
request.setCharacterEncoding("UTF-8");
StringBuffer backInf=new StringBuffer();
HttpSession sess=request.getSession(true);
//讀取用戶的信息
String username=(String)sess.getAttribute("name");//
String indentity=(String)sess.getAttribute("indentity");
//獲取主題
String bbstopic=(String)request.getParameter("bbstopic");
//獲取內(nèi)容
String bbscontent=(String)request.getParameter("bbscontent");
//獲取ip
String userip=request.getRemoteAddr();//ip
//獲取版主id
int board_id=Integer.parseInt(request.getParameter("board_id"));
//獲取本地時(shí)間
String bbsdata=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
//插入語(yǔ)句
String query="insert into bbs(username,userip,bbstopic,bbscontent," +
"bbsdata, board_id,indentity,bbsredata,bbsrename) values("+"'"+username+"'"+","+"'"+userip+"'"+","+"'"+bbstopic+"'"+","
+"'"+bbscontent+"'"+","+"'"+bbsdata+"'"+","+ board_id+","+"'"+indentity+"'"+","+"'"+bbsdata+"'"+","+"'"+username+"'"+")";
backInf.append("<Infs>");
//執(zhí)行數(shù)據(jù)庫(kù)操作
if(DataProcess.ExeQuery(query)){
backInf.append("<Inf>success</Inf>");
}else{
backInf.append("<Inf>fail</Inf>");
}
backInf.append("</Infs>");
//帖子數(shù)目加一
String sql="update board set boardtopics=boardtopics+1 where board_id="+board_id;
DataProcess.ExeQuery(sql);
//積分加五
String sqla="update user set userclass=userclass+5 where username="+"'"+username+"'";
DataProcess.ExeQuery(sqla);
out.print(backInf);
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occure
*/
public void init() throws ServletException {
// Put your code here
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -