java中从数据库中模糊查询问题

Connection conn = SqlUtil.getDBConn();
Statement stmt = conn.createStatement();
ResultSet rs =
stmt.executeQuery("select * from goods_info ");
while (rs.next()) {
GoodsInfo goods = new GoodsInfo();
goods.setGoodsId(rs.getInt("goods_id"));
goods.setGoodsName(rs.getString("goods_name")); goodsList.add(goods);
}
这样输出结果

你是不是查询语句写错了哦..

HI我..我帮你看看呢..

请举个例子先

select top 10 * from xx_table where xxx like '%xxxx%'

模糊查询的语句一般写法：select * from tablename where username like '%张三%'。
楼主看看你的语句写的对不对。