addnote.java

一些基本jsp

package my.servlet;
import my.data.MyOdbc;
import my.data.MyParameter;
import java.sql.*;
import java.io.*;
import java.util.Date;
import javax.servlet.*;
import javax.servlet.http.*;
public class addNote extends HttpServlet{
	public void doPost(HttpServletRequest request,
	   HttpServletResponse reponse)
	   throws IOException{
	   	HttpSession session=request.getSession(true);
	   	MyParameter cn=new MyParameter(request);
	    MyOdbc myodbc=new MyOdbc();
	    String sql,sql2,sql3,sql4,title,note,userId,date,boardId;
	   title=cn.getParameter("title");
	   note=cn.getParameter("note");
	   date=myodbc.getTime();
	   userId=(String)session.getAttribute("userId");
	   boardId=request.getParameter("boardId");
	   sql="insert into 贴子(标题,内容,发表日期,用户名,版块id)values('"+title+"','"+note+"','"+date+"','"+userId+"','"+boardId+"')";
	   sql2="update 论坛 set 贴子数量=贴子数量+1 where 论坛id="+boardId;
	   sql3="update 论坛 set 最后发表时间='"+date+"',最后发表人='"+userId+"' where 论坛id="+boardId;
	   sql4="update 用户表 set 发贴次数=发贴次数+1 where 用户名='"+userId+"'";
	   myodbc.executeUpdate(sql);
	   myodbc.executeUpdate(sql2);
	   myodbc.executeUpdate(sql3);
	   myodbc.executeUpdate(sql4);  
	   reponse.sendRedirect("board.jsp?boardId="+boardId);
	   }
	
}