int rs = 0;
String IDStr =req.getParameter("usrID");
if(IDStr==null && "".equals(IDStr)){
req.setAttribute("rs", rs);
req.getRequestDispatcher("dao/borrow.jsp").forward(req, resp);
}
int usrID = java.lang.Integer.parseInt(IDStr);
String bIDStr =req.getParameter("bookID");
if(IDStr==null && "".equals(IDStr)){
req.setAttribute("rs", rs);
req.getRequestDispatcher("dao/borrow.jsp").forward(req, resp);
}
int bookID = java.lang.Integer.parseInt(bIDStr);
String bTime = GetTime.get();
String sql="insert into useTable values("+usrID+",'',"+bookID+",'','"+bTime+"',"+null+",default,'')";
Connection con =null;
Statement sta = null;
con = new Sqlcon().getcon();
try {
sta= con.createStatement();
rs =sta.executeUpdate(sql);
System.out.println(rs);
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
Sqlcon.closeCon(con, null, sta);
} catch (SQLException e) {
e.printStackTrace();
}
}
req.setAttribute("rs", rs);
req.getRequestDispatcher("dao/borrow.jsp").forward(req, resp);
}
Console输出的
59
2
0
在sql里面用语句插入的结果
(9 行受影响)
(1 行受影响)
(1 行受影响)
(1 行受影响)
为什么sta.executeUpdate(sql)返回的是 0呢
------解决方案--------------------
代码没贴全吧。。。
怎么会输出3行呢？