src/com/servlet/liuyanServlet.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;
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.util.*;
import java.util.List;
import java.sql.ResultSet;

public class liuyanServlet extends HttpServlet  {
	public void service(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		request.setCharacterEncoding("gb2312");
		System.out.println("method"+request.getParameter("method"));
		String method=(String)request.getParameter("method");
		if(method.equals("insert")){//留言添加
			insertM(request, response);
		}else if(method.equals("list")){//留言列表
			ListM(request, response);
		}else if(method.equals("delete")){//留言删除
			deleteM(request, response);
		}else if(method.equals("modifyindex")){//留言修改页面
			modifyIndex(request, response);
		}
		else if(method.equals("modify")){//留言修改
			modifyM(request, response);
		}else if(method.equals("detail")){//留言详细信息
			detailM(request, response);
		}else if(method.equals("Plist")){//留言列表信息
			PListM(request, response);
		}
	}
	private void insertM(HttpServletRequest request, HttpServletResponse response){//留言添加
		DBO db=new DBO();//初始化数据链接基础类
		String sql="";//sql语句初始化
			String keyid =(String)request.getParameter("keyid");//留言表主键
String yh=(String)request.getParameter("yh");//用户
String ly=(String)request.getParameter("ly");//留言
String nr=(String)request.getParameter("nr");//内容
String sj=(String)request.getParameter("sj");//时间

		response.setCharacterEncoding("gb2312");
 		sql="insert into liuyan(yh,ly,nr,sj) values('"+yh+"','"+ly+"','"+nr+"','"+sj+"')";
;//留言SQL 语句
		int row=1;
		try {
			row=db.update(sql);//执行sql语句 insert语句
			if(row==1){
			request.setAttribute("flag", "操作成功"); 
			}else{
			request.setAttribute("flag", "操作失败"); 
			}
			
			
			request.getRequestDispatcher("liuyan/liuyanadd.jsp").forward(request, response);