SQL Server数据库转换Oracle

[qczl1224]

String idStr = req.getParameter("id");
String sql = "DELETE FROM bookTab WHERE bookId=" + idStr + ";";

删除一个表里面ID的的所以数据。不知怎么改？？？

res.setContentType("text/plain;");
PrintWriter pw=res.getWriter();
pw.println("加入一笔记录\n\n"+
"书号"+idStr+"\n"+
"书名"+title+"\n"+
"作者"+author+"\n"+
"单价"+priceStr);

我编辑加入记录结果都是？？？号谁知道怎么回事吗？

??????

??1006
????????
????
??5000

[giant216]

不懂搂住的意思,乱码肯定是编码的问题啊

[waterfirer]

String sql = "DELETE FROM bookTab WHERE bookId='" + idStr + "';";

[njhart2003]

String sql = "DELETE FROM bookTab WHERE bookId='" + idStr+"'";
引号内不需要"；"吧

[waterfirer]

嗯，是多了一个"；"，竟然没看到，sign

[qczl1224]

我哭呀原来最后不要分号，，搞了我两天，，谢谢大家