这个是我servlet的代码。代码里如何改?就是通过一个jsp页面把得到的参数进行处理,得到的mysql数据传输到另一个jsp页面
请问第二个的jsp里面还要怎么写?
小弟跪拜各位大哥,球球你们啦
package servlet;
import dao.DBConnection;
import java.io.IOException;
import java.sql.*;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* @author Lenovo
*/
public class Search extends HttpServlet {
public Search() {
super();
// TODO Auto-generated constructor stub
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setHeader("Pragma","No-cache");
response.setHeader("Cache-Control","no-cache");
response.setDateHeader("Expires", 0);
String type = request.getParameter("type");
String clause = "";
String keyword = request.getParameter("keyword");
String way = request.getParameter("way");
if ((type == null)||(type.equals("null"))) {
if (way.trim().equals("1")) {
clause = "select * from sheet1 where name like '%" + keyword + "%'";
} else if (way.trim().equals("2")) {
clause = "select * from sheet1 where time like '%" + keyword + "%'";
} else if (way.trim().equals("3")) {
clause = "select * from sheet1 where production like '%" + keyword + "%'";
} else if (way.trim().equals("4")) {
clause = "select * from sheet1 where publisher like '%" + keyword + "%'";
}
}
DBConnection db = new DBConnection();
db.executeQuery(clause);
request.setAttribute("clause",clause);
try {
request.getRequestDispatcher("/result.jsp?type=" + type + "&keyword=" + keyword
+ "&way=" + way).forward(request, response);
} catch (IOException t) {
getServletContext().log(t.getMessage());
}
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setHeader("Pragma","No-cache");
response.setHeader("Cache-Control","no-cache");
response.setDateHeader("Expires", 0);
String clause = "";
String keyword = request.getParameter("keyword");
String way = request.getParameter("way");
if (way.trim().equals("1")) {
clause = "select * from sheet1 where name like '%" + keyword + "%'";
} else if (way.trim().equals("2")) {
clause = "select * from sheet1 where author like '%" + keyword + "%'";
} else if (way.trim().equals("3")) {
clause = "select * from sheet1 where production like '%" + keyword + "%'";
} else if (way.trim().equals("4")) {
clause = "select * from sheet1 where publisher like '%" + keyword + "%'";
}
DBConnection db = new DBConnection();
db.executeQuery(clause);