java mvc模糊查询_MVC模式的多条件模糊查询

这个是前台代码

package servlet;

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import bean.Car;

/**

* Servlet implementation class SelectCarServlet

*/

public class SelectCarServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

*/

public SelectCarServlet() {

super();

// TODO Auto-generated constructor stub

}

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

response.getWriter().append("Served at: ").append(request.getContextPath());

}

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

//实例化一个业务bean

Car c=new Car();

//从前台接收输入框中的name值

String name=request.getParameter("selectCar");

request.setAttribute("select", c.selectCar());

//请求重定向

request.getRequestDispatcher("buy.jsp").forward(request, response);

}

}

这个是控制层的SelectServlet

package bean;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import util.DBUtil;

public class Test {

//这是之前写过的一个JDBC工具类

DBUtil db=DBUtil.getDB();

private String id;//汽车车牌号

private String pinpai;//品牌

private String xinghao;//型号

private String name;//汽车车名

public String getId() {

return id;

}

public void setId(String id) {

this.id = id;

}

public String getPinpai() {

return pinpai;

}

public void setPinpai(String pinpai) {

this.pinpai = pinpai;

}

public String getXinghao() {

return xinghao;

}

public void setXinghao(String xinghao) {

this.xinghao = xinghao;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

//这里是业务方法，用来在SQL中获取车辆信息

public ArrayList getAllCar(){

ArrayList list=new ArrayList();

//SQL语句

String sql="select cid,cpinpai,cxinghao,cname from car ";

ResultSet rs=db.executeQuery(sql);

try {

while(rs.next()){

//保证每存完一行数据后就刷新

Car c=new Car();

c.setId(rs.getString("cid"));

c.setPinpai(rs.getString("cpinpai"));

c.setXinghao(rs.getString("cxinghao"));

c.setName(rs.getString("cname"));

list.add(t);

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return list;

}

}

这个是业务bean，Car.java

最后调到buy.jsp在jsp中

JSP Page

list=new ArrayList();%>

车牌号	品牌	型号	车名