這篇文章主要介紹了jsp與sql語句的混合使用,需要的朋友可以參考下
話不多說,直接上例子 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] <% while (rs.next()){ String amount=rs.getString("amount"); String orderid=rs.getS新聞熱點
疑難解答