关于在MyEclipse中如何写SQL语句

想在MyEclipse中实现如下语句：select * from goods where goodsName like %?% limit ?,?
在A处应该怎样写呢？ ps = conn.preparestatement(" A");
ps.setString(1,goodsName)

问题很简单，不过我还是很重要，有劳各位了

[code="java"]
ps = conn.preparestatement("select * from goods where goodsName like ? limit ?,? ");
ps.setString(1,"%" + goodsName + "%")
[/code]

PreparedStatement pst=conn.preparestatement("select * from goods where goodsName like ? limit ?,? ");

pst.setString(1,"%" + goodsName + "%")；
pst.setInt(2, 0);
pst.setInt(3, 10);
pst.executeQuery();