MVC模式的多条件模糊查询

最新推荐文章于 2023-02-25 08:41:00 发布

chisou2614

最新推荐文章于 2023-02-25 08:41:00 发布

阅读量588

点赞数

文章标签：测试 java 数据库

原文链接：https://my.oschina.net/cannianguaishushu/blog/709655

版权

<form action="SelectServlet" method="post>
	<span>搜索车型：</span><input type="text" name="select"><br/>
	<input type="submit" value="搜索">
</form>

这个是前台代码

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<Test> getAllCar(){
		ArrayList<Test> list=new ArrayList<Test>();
		//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中

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
    	<%ArrayList<Car> list=new ArrayList<Car>();%>
    		<table>
    			<tr>
    				<td>车牌号</td><td>品牌</td><td>型号</td><td>车名</td>
    			</tr>
    			<%for(int i=0;i<list.size();i++){%>
    				<tr>
					<td><%=list.get(i).getId%></td>
					<td><%=list.get(i).getPinpai%></td>
					<td><%=list.get(i).getXinghao%></td>
					<td><%=list.get(i).getName%></td>
    				</tr>
    			<%}%>	
    		</table>
 	</body>
</html>

转载于:https://my.oschina.net/cannianguaishushu/blog/709655