Question

jdbc调用存储过程的出现的错误

ALTER PROCEDURE [dbo].[sp_get_goods_by_id]
@id BIGINT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT * FROM dbo.goods WHERE uid=@id
END
这样的存储过程怎么调用conn=ConnDB.GetConn();
cs=conn.prepareCall("call sp_get_goods_by_id(?)");
cs.setString(1, uid);;
rs=cs.getResultSet();
while(rs.next()) {
gbBean.setUid(rs.getLong(1));
gbBean.setGoodsName(rs.getString(2));
gbBean.setGoodsInfo(rs.getString(3));
gbBean.setGoodsPrice(rs.getFloat(4));
gbBean.setGoodsNum(rs.getInt(5));
gbBean.setPublisher(rs.getString(6));
gbBean.setPhoto(rs.getString(7));
gbBean.setType(rs.getString(8));
}
这样调用怎么出错了呢

Answer 1

conn.prepareCall("{call sp_get_goods_by_id(?)}");
cs.setObject(1, uid); //uid应该是BigInteger吧，字符串与bigint类型不匹配

追问

还是不行哦

追答

2边的大括号加了?