首先写一个SQL语句:
String sqlblor=“select * from b_station as s where s.SubordinateRegion LIKE ? or s.SubordinateName LIKE ? or s.StationUnit LIKE ? or s.StationName LIKE ? or s.StationCode LIKE ? limit ?,?”;
然后传入要查询的数据,判断传入的数据不能为空,是否进行模糊查询。
获取页面传过来的数据,
private void selectSt(HttpServletRequest request, HttpServletResponse response) throws IOException {
String find = request.getParameter(“isnot”);
String page = request.getParameter(“page”);
String limit = request.getParameter(“limit”);
List list = new ArrayList();
如果乱码的话,要转换一下格式,代码如下:
request.setCharacterEncoding(“UTF-8”);
response.setCharacterE