第七次作业

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


 1 package com.gd.entity;
 2 
 3 public class Book {
 4     private Integer id;
 5     private String name;
 6     private double price;
 7     
 8     public Book() {
 9         super();
10         // TODO Auto-generated constructor stub
11     }
12 
13     public Book(Integer id, String name, double price) {
14         super();
15         this.id = id;
16         this.name = name;
17         this.price = price;
18     }
19 
20     public Integer getId() {
21         return id;
22     }
23 
24     public void setId(Integer id) {
25         this.id = id;
26     }
27 
28     public String getName() {
29         return name;
30     }
31 
32     public void setName(String name) {
33         this.name = name;
34     }
35 
36     public double getPrice() {
37         return price;
38     }
39 
40     public void setPrice(double price) {
41         this.price = price;
42     }
43 
44     @Override
45     public String toString() {
46         return "Book [id=" + id + ", name=" + name + ", price=" + price + "]";
47     }
48 
49     
50     
51 }


 1 package com.gd.entity;
 2 
 3 import java.util.ArrayList;
 4 import java.util.List;
 5 import java.util.Scanner;
 6 
 7 public class TestBook {
 8 
 9     /**
10      * @param args
11      */
12     public static void main(String[] args) {
13         List<Book> list = new ArrayList<Book>();
14         Book book = new Book();
15         Book b1=new Book(1,"安徒生童话",15.0);
16         Book b2=new Book(2,"马化腾全传",20.5);
17         Book b3=new Book(3,"马云全传",50.00);
18         list.add(b1);
19         list.add(b2);
20         list.add(b3);
21         menu(list, book);
22         
23     }
24     public static void menu(List<Book> list, Book book){
25         System.out.println("1.添加图书");
26         System.out.println("2.删除图书");
27         System.out.println("3.修改图书");
28         System.out.println("4.查询图书");
29         System.out.println("请选择");
30         select(list, book);
31             
32     }
33     public static void select(List<Book> list, Book book) {
34         int i = new Scanner(System.in).nextInt();
35         switch (i) {
36         case 1:
37             System.out.println("请添加图书的编号：");
38             book.setId(new Scanner(System.in).nextInt());
39             System.out.println("请添加图书的名称：");
40             book.setName(new Scanner(System.in).next());
41             System.out.println("请添加图书的价格：");
42             book.setPrice(new Scanner(System.in).nextDouble());
43             list.add(book);
44             System.out.println("添加成功");
45             menu(list, book);
46 
47             break;
48         case 2:
49             System.out.println("请输入要删除图书的名称：");
50             String name=new Scanner(System.in).next();
51             for (int j = 0; list != null && j < list.size(); j++) {
52                 if (list.get(j).getName().equals(name)) {
53                     list.remove(j);
54                 }
55             }
56             System.out.println("删除成功");
57             menu(list, book);
58             break;
59         case 3:
60             System.out.println("请输入要修改图书的编号：");
61             int k=new Scanner(System.in).nextInt();;
62             for (int j = 0; list != null && j < list.size(); j++) {
63                 if (list.get(j).getId().equals(k)) {
64                     list.remove(j);
65                     System.out.println("请输入修改后图书的名称：");
66                     String name1=new Scanner(System.in).next();
67                     System.out.println("请输入修改后图书的价格：");
68                     double price1=new Scanner(System.in).nextDouble();
69                     Book b=new Book(k,name1,price1);
70                     list.add(b);
71                     break;
72                 }
73             }
74             System.out.println("修改成功");
75             menu(list, book);
76             break;
77 
78         case 4:
79             for (int j = 0; list != null && j < list.size(); j++) {
80                 System.out.println(list.get(j).getId() + "."
81                         + list.get(j).getName() + "," + list.get(j).getPrice());
82             }
83             menu(list, book);
84             break;
85         }
86     }
87 
88 }

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


 1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
 2 <%@page import="com.gd.entity.Book"%>
 3 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 4 <html>
 5 <head>
 6 </head>
 7 
 8 <body>
 9     <%
10         List<Book> list = new ArrayList<Book>();
11         Book b1=new Book(1,"安徒生童话",15.0);
12         Book b2=new Book(2,"马化腾全传",20.5);
13         Book b3=new Book(3,"马云全传",50.00);
14         list.add(b1);
15         list.add(b2);
16         list.add(b3);
17         for (int i = 0; list != null && i < list.size(); i++) {
18             out.print(list.get(i).getId() + "." + list.get(i).getName()
19                     + "," + list.get(i).getPrice() + "<br>");
20         }
21     %>
22 </body>
23 </html>

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

 


# 建表
create table book(
    id double(100,10) primary key auto_increment,
    name varchar(10) not null ,
    price double(100,10)
   );
#插入数据
 insert into book (name,price) values('西游记',24.5),('我和我',14.5),('重生之天才小子',10);
 insert into book (name,price) values('三国演义',25),('水浒传',16),('红楼梦',19.6);
#查询价格大于10的书籍信息
select * from  book where price>10;
#查询所有书籍信息
select * from  book;
#将价格大于20的书籍的价格改为18.8
update book set price=18.8 where price>20;
#删除”我“开头的书籍信息
delete from book where name like'我%';
#删除指定名称的书籍信息
delete from book where name='重生之天才小子';
#删除所有书籍信息
delete from book;
#删除表
drop table book;