JSP第七次作业

1.做一个图书类Book id,name,price ,get,set访问器，构造方法2个，1个无参，1个有参
做一个测试类，在main中创建3个图书对象，放到list集合中。做一个菜单，可以添加，删除，修改，查询

package book;

import java.util.ArrayList;
import java.util.List;

public class Book {
    private String id;
    private String name;
    private double price;
    public String getId() {
        return id;
    }
    public void setId(String id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public double getPrice() {
        return price;
    }
    public void setPrice(double price) {
        this.price = price;
    }
    public Book(String id, String name, double price) {
        super();
        this.id = id;
        this.name = name;
        this.price = price;
    }
    public Book() {
        super();
        // TODO Auto-generated constructor stub
    }
    
    List<Book> list=new ArrayList<Book>();
    
    //添加
    public void add(Book b){
        list.add(b);
    }
    //删除
    public boolean remove(Book b){
        return list.remove(b);
    }
    //修改
    public void set(Book b,int index){
        list.set(index, b);
    }
    //查询
    public void showAll(){
        for(int i=0;i<list.size();i++){
            System.out.println("ID:"+list.get(i).getId()+",NAME:"+list.get(i).getName()+",PRICE:"+list.get(i).getPrice());
        }
    }

}

package book;

public class bookTest {

    /**
     * @param args
     */
    public static void main(String[] args) {
        // TODO Auto-generated method stub
        Book b1=new Book("a","aa",10);
        Book b2=new Book("b","bb",20);
        Book b3=new Book("c","cc",30);
        Book b4=new Book("d","dd",40);
        Book b=new Book();
        b.add(b1);
        b.add(b2);
        b.add(b3);
        b.showAll();
        b.set(b4, 0);
        System.out.println("==============");
        b.showAll();
        System.out.println("==============");
        b.remove(b4);
        b.showAll();

    }

}

2.上题的类，在一个JSP页面中，创建一个集合，里面放3个图书，集合循环遍历显示在页面上。

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<html>
  <head>
    
    <title>My JSP 'd1.jsp' starting page</title>

  </head>
  <%@ page import="book.Book" %>
  
  <body>
    <%
  List<Book> list=new ArrayList<Book>();
  Book b1=new Book();
  b1.setId("a");
  b1.setName("中华小当家");
  b1.setPrice(10);
  Book b2=new Book();
  b2.setId("b");
  b2.setName("三国演义");
  b2.setPrice(20);
  list.add(b1);
  list.add(b2);
  for(int i=0;i<list.size();i++){
            out.print("ID:"+list.get(i).getId()+",NAME:"+list.get(i).getName()+",PRICE:"+list.get(i).getPrice()+"<br>");
        }
   %>
  </body>
</html>

3.在MySQL中创建Book表，里面id,name,price,
用命令实现，
添加一个图书，
根据名称删除图书，
把所有名称是“我”开头的图书删除，
删除全部图书，
把20元以上的图书价格都修改为18.8，
查看全部图书，
查看价格高于10块钱的全部图书

create table book(
id INT PRIMARY KEY auto_increment,
name varchar(30) NOT NULL,
price DOUBLE 
);
select * from book;
INSERT INTO book (name,price) VALUE("三国演绎",10);
INSERT into book(name,price) value("中华小当家",20);
insert into book(name,price) VALUE("我们的家",30);
update book set price=18.8 where price>20;
select * from book where price>10;
delete from book where name like '我%';

posted on 2022-04-27 12:26 Lwmm 阅读(66) 评论(0) 编辑收藏举报