求助，java使用PreparedStatement 查询时，通配符%无效

[浴漱淋沨]

当使用代码如下：

输入000，按下回车：
会弹出窗口：
当使用代码：
输入000，按下回车：
控制台显示：
这个种情况怎么办呢？各位大佬帮帮忙啊。我试过


也是不行。

[hr_hin]

select * from goods where GoodsId like concat('%',Sname,'%') or Goodsname like concat('%',Sname,'%')

[浴漱淋沨]

引用 5 楼 sinat_37729323 的回复:

select * from goods where GoodsId like concat('%',Sname,'%') or Goodsname like concat('%',Sname,'%')

			String sql = "select * from goods where GoodsId like concat('%',?,'%') or  GoodsName like concat('%',?,'%')";
			pstat=con.prepareStatement(sql);
			pstat.setString(1, Sname);
			pstat.setString(2, Sname);
			rs = pstat.executeQuery();
			System.out.println(Sname);
    		System.out.println(rs.next());

结果是：
控制台Sname是0，rs.next();返回false。


另外在sql server里是：

[浴漱淋沨]

			String sql = "SELECT * from goods where GoodsID like '%000%' or GoodsName like '%000%'";
			//String sql = "select * from goods where GoodsId like concat('%',?,'%') or  GoodsName like concat('%',?,'%')";
			pstat=con.prepareStatement(sql);
			//pstat.setString(1, Sname);
			//pstat.setString(2, Sname);
			rs = pstat.executeQuery();
			System.out.println(Sname);
    		System.out.println(rs.next());

结果是：

—————————————————————————————————————————————————————————————————————

			  String sql = "SELECT * from goods where GoodsID like ? or GoodsName like ?";
			//String sql = "SELECT * from goods where GoodsID like '%000%' or GoodsName like '%000%'";
			//String sql = "select * from goods where GoodsId like concat('%',?,'%') or  GoodsName like concat('%',?,'%')";
			pstat=con.prepareStatement(sql);
			pstat.setString(1, "%"+Sname+"%");
			pstat.setString(2, "%"+Sname+"%");
			//pstat.setString(1, Sname);
			//pstat.setString(2, Sname);
			rs = pstat.executeQuery();
			System.out.println(Sname);
    		System.out.println(rs.next());

结果是：

[浴漱淋沨]

如果不使用like而是使用=

			  String sql = "SELECT * from goods where GoodsID = ? or GoodsName = ?";
//			  String sql = "SELECT * from goods where GoodsID like ? or GoodsName like ?";
			//String sql = "SELECT * from goods where GoodsID like '%000%' or GoodsName like '%000%'";
			//String sql = "select * from goods where GoodsId like concat('%',?,'%') or  GoodsName like concat('%',?,'%')";
			pstat=con.prepareStatement(sql);
//			pstat.setString(1, "%"+Sname+"%");
//			pstat.setString(2, "%"+Sname+"%");
			pstat.setString(1, Sname);
			pstat.setString(2, Sname);
			rs = pstat.executeQuery();
			System.out.println(Sname);

分别输入No00000001和330ml 可口可乐（听）结果是：



而使用like就不行了

[oyljerry]

PreparedStatement pstmt = con.prepareStatement(
    "SELECT * FROM analysis WHERE notes like ?");
pstmt.setString(1,  "%" + notes + "%");`

就是这样就可以。先看看sql字段等都对了。

[浴漱淋沨]

我是在stat的sql语句上改的，sql字段应该都没问题，不知道怎么到了pstat就不行了。

[浴漱淋沨]

String sql = "SELECT * FORM goods";
			pstat=con.prepareStatement(sql);
			rs = pstat.executeQuery();

这样也不行

[浴漱淋沨]

String sql = "SELECT * from goods";
			pstat=con.prepareStatement(sql);
			rs = pstat.executeQuery();

可以了