regnote.java

一些基本jsp

package my.servlet;
import my.data.MyOdbc;
import my.data.MyParameter;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class regNote extends HttpServlet{
	public void doPost(HttpServletRequest request,
	   HttpServletResponse reponse)
	   throws IOException{
	   	HttpSession session=request.getSession(true);
	   	MyOdbc myodbc=new MyOdbc();
	   	MyParameter cn=new MyParameter(request);
	   String sql,sql2,sql3,title,note,userId,ip,date,noteId,boardId;
	   title=cn.getParameter("title");
	   note=cn.getParameter("note");
	   noteId=request.getParameter("noteId");
	   date=myodbc.getTime();
	   boardId=request.getParameter("boardId");
	   ip=request.getRemoteAddr();
	   userId=(String)session.getAttribute("userId");
	   sql="insert into 回复(标题,内容,用户名,贴子id,回复时间,回复IP)values('"+title+"','"+note+"','"+userId+"','"+noteId+"','"+date+"','"+ip+"')";
	   sql2="update 贴子 set 最后回复时间='"+date+"',最后回复作者='"+userId+"',回复次数=回复次数+1 where 贴子id="+noteId;
	   myodbc.executeUpdate(sql);
	   myodbc.executeUpdate(sql2);
	   reponse.sendRedirect("shownote.jsp?boardId="+boardId+"&noteId="+noteId);
	}
}