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.getString("id"); String bookname=rs.getString("name"); String price=rs.getString("price"); String picture=rs.getString("pic"); //out.println("\tshuliang"+amount); %>