deleteuser.java

用JSP写的论坛源代码 走过路过的各位千万不要错过啊！！！！

package admin;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import serv.bbsdb;


public class deleteuser extends HttpServlet {
	public deleteuser()
	{super();}
	public void init(ServletConfig config)throws ServletException
	{
		super.init(config);	
	}
	public void doPost(HttpServletRequest req,HttpServletResponse resp)throws ServletException,IOException
	{
		try {
		bbsdb dbconn=new bbsdb();
		req.setCharacterEncoding("gb2312");
		String username=req.getParameter("userName");
		String sql="DELETE * FROM user WHERE userName='"+username+"'";
			dbconn.executeUpdate(sql);	
			String sql1="DELETE * FROM bbs WHERE username='"+username+"'";
			dbconn.executeUpdate(sql1);	
			resp.sendRedirect("/May/tempuser.jsp");//实现网页跳转 
		
		}  catch (RuntimeException e) {e.printStackTrace();}
	}
}