JSP第九周作业

1.做一个图书类Book  id,name,price 。  get,set访问器，构造方法2个，1个无参，1个有参

做一个测试类，在main中创建3个图书对象，放到list集合中。做一个菜单，可以添加，删除，修改，查询

import java.util.*;
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;
        }
}

import java.util.*;
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", "心理罪城市之光", 38);
            book b2 = new book("2", "看不见的病人", 32);
            book b3 = new book("3", "哈利波特与魔法石", 51);
            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:
                de();
                break;
            case 3:
                sel();
                break;
            case 4:
                alert();
                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 de() {
            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("修改成功");
              
                }
                menu();
            }

        }

}

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

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import= "aa.book"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>My JSP 'MyJsp.jsp' starting page</title>
  </head>
  <body>
     <%
        ArrayList<book> list = new ArrayList<book>();
        book b1 = new book("1","心理罪",45);
        book b2 = new book("2","红楼梦",56);
        book b3 = new book("3","哑舍",36);
        list.add(b1);
        list.add(b2);
        list.add(b3);
        for (int i = 0; list != null && 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,

用命令实现，

添加5个图书，

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

查看全部图书，

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

根据名称删除图书，

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

删除全部图书。