insert
代码如下:
String sql="insert into allorder values('" + orderid + "','" + bookid +"','" + amount + "','" + username + "')";
int result=stmt.executeUpdate(sql);
if(result==1)
response.sendRedirect("index.jsp");
else
response.sendRedirect("detail.jsp");
delete
代码如下:
String condition="delete from allorder where id='"+ orderid+ "'";
int result=stmt.executeUpdate(condition);
if(result==1)
response.sendRedirect("index.jsp");
else
out.println("shopCar.jsp");
update
代码如下:
与delete，insert差不多
select
[code]