JSP第九周作业

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

package one;

public class Book {
    String id;
    String name;
    int price;
        
    
    public Book() {
        super();
    }
    
    public Book(String id, String name, int price) {
        super();
        this.id = id;
        this.name = name;
        this.price = 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 int getPrice() {
        return price;
    }
    public void setPrice(int price) {
        this.price = price;
    }

    @Override
    public String toString() {
        return "编号是"+id+",书名是"+name+",价格是"+price;
    }
    
    

}
package one;

import java.util.ArrayList;
import java.util.Scanner;

public class Test {
    static ArrayList<Book> list = new ArrayList<Book>();
    static Scanner input = new Scanner(System.in);

    public static void main(String[] args) {
        // TODO Auto-generated method stub
        Book b1 = new Book("1", "夜莺与玫瑰", 28);
        Book b2 = new Book("2", "我的前半生", 50);
        Book b3 = new Book("3", "狼王宝座", 32);
        list.add(b1);
        list.add(b2);
        list.add(b3);
        menu();

    }

    public static void menu() {
        System.out.println("请输入想要实现的功能");
        System.out.println("1.添加");
        System.out.println("2.删除");
        System.out.println("3.查找");
        System.out.println("4.修改");
        int i = input.nextInt();
        switch (i) {
        case 1:
            add();
            break;
        case 2:
            del();
            break;
        case 3:
            sel();
            break;
        case 4:
            sel();
            break;
        }
    }

    public static void add() {
        System.out.println("请添加的序号");
        String id = input.next();
        System.out.println("请添加书名");
        String name = input.next();
        System.out.println("请输入价格");
        int price = input.nextInt();
        Book b = new Book(id, name, price);
        list.add(b);
        menu();
    }

    public static void del() {
        System.out.println("请输入要删除的编号");
        String id = input.next();
        for (int i = 0; i < list.size(); i++) {
            if (list.get(i).getId().equals(id)) {
                list.remove(i);
            }
        }
        menu();
    }

    public static void sel() {
        for (Book b : list) {
            System.out.println(b);
        }
        menu();
    }

    public static void alert() {
        System.out.println("输入要修改书的编号");
        String id = input.next();

        for (int i = 0; i < list.size(); i++) {
            if (list.get(i).getId().equals(id)) {
                System.out.println("输入新的编号");
                String id1 = input.next();
                System.out.println("输入新书名");
                String name = input.next();
                System.out.println("输入新价格");
                int price = input.nextInt();
                Book b = new Book(id1, name, price);
                list.set(i, b);
                System.out.println("修改成功");
                break;
            }
            menu();
        }

    }

}

 

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

 

<%@ page import="one.Book" %>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>My JSP 'index.jsp' starting page</title>
  </head>
  
  <body>
  <%
  ArrayList<Book> list=new ArrayList<Book>();
  
  Book b1=new Book("1","DK博物大百科",73);
  Book b2=new Book("2","哈利·波特与魔法石",40);
  Book b3=new Book("3","宫西达也恐龙系列",39);
  
  list.add(b1);
  list.add(b2);
  list.add(b3);
  
   for (int i = 0; i<list.size(); i++) {
            out.print("编号为:"+list.get(i).getId()+"  ,名称为:"
                       +list.get(i).getName()+"  ,价格为:"+list.get(i).getPrice()+"<br>");
        }
   %>
    
  </body>
</html>

 

 

 

3.在MySQL中创建Book表,里面id,name,price,

create database Books;
use Books;

create table book(
id int(20) primary key,
name varchar(10) not null,
price double
);

  

 用命令实现,

添加一个图书,

insert into book values('1','猜猜我有多爱你','40'),
('2','苹果树上的外婆','14'),
('3','我爸爸','21'),
('4','7号梦工厂','70');

 

 


根据名称删除图书,
把所有名称是“我”开头的图书删除,

delete from book where name like '我%';

把20元以上的图书价格都修改为18.8,

update book set price=18.8 where price>20;

 

 

查看全部图书,

select*from book;

查看价格高于10块钱的全部图书

select*from book where price>10;

删除全部图书,

 

 

 

 

posted @ 2022-04-30 23:21  请叫我妖玉大侠  阅读(24)  评论(0编辑  收藏  举报