sql语句like模糊搜索怎么通过一个关键字搜到所有包含关键字的数据

Question

像下面这个只能搜到一条数据，怎么把所有包含关键字的数据都搜出来 String strSql = "select 商品ID,商品名称,价格,优惠价格,图片地址  from 商品数据表  where 商品名称  like ?";      GoodsInfoManage5_8 gm = new GoodsInfoManage5_8();      try {        goods = gm.getInfoName(strSql, findname);        request.setAttribute("goods", goods);        request.getRequestDispatcher("productList.jsp").forward(request, response);              }      catch (SQLException e) {        e.printStackTrace();      } GoodsInfoManage5_8()：String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";  String url = "jdbc:sqlserver://localhost:1433;DatabaseName=ECommerce";  String username = "sa";  String password = "123456";  private Connection conn = null;  private Statement stmt = null;  private ResultSet rs = null;  private PreparedStatement pstmt = null;public GoodsInfo getInfoName(String sql, String name) throws SQLException {    ResultSet rs = null;    GoodsInfo goods = null;    if (this.conn == null)      Connection();    try    {      this.pstmt = this.conn.prepareStatement(sql);      this.pstmt.setString(1, "%" + name + "%");      rs = this.pstmt.executeQuery();      if(rs.next()){        goods = new GoodsInfo();        goods.setGoodsId(rs.getInt("商品ID"));        goods.setGoodsName(rs.getString("商品名称"));        goods.setGoodsPrice(rs.getDouble("价格"));        goods.setGoodsPreferentialPrice(rs.getDouble("优惠价格"));        goods.setGoodsImageAddress(rs.getString("图片地址"));      }    }    catch (SQLException e) {      e.printStackTrace();    }    return goods;  } 

Answer 1

因为你sql语句写的是限定商品名称查询呀，where后面你写的是什么就是限定是什么，比如你这个写的是商品名称，就是对商品名称的模糊查询！