JSP第九周作业

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

 1 package com.sykjxy.zy01;
 2 
 3 public class Book {
 4     private String id;
 5     private String name;
 6     private double price;
 7     
 8     public Book() {
 9         super();
10     }
11 
12     public Book(String id, String name, double price) {
13         super();
14         this.id = id;
15         this.name = name;
16         this.price = price;
17     }
18 
19     public String getId() {
20         return id;
21     }
22 
23     public void setId(String id) {
24         this.id = id;
25     }
26 
27     public String getName() {
28         return name;
29     }
30 
31     public void setName(String name) {
32         this.name = name;
33     }
34 
35     public double getPrice() {
36         return price;
37     }
38 
39     public void setPrice(double price) {
40         this.price = price;
41     }
42     
43     
44 }
  1 package com.sykjxy.zy01;
  2 
  3 import java.util.ArrayList;
  4 import java.util.List;
  5 import java.util.Scanner;
  6 
  7 public class Text {
  8     static List<Book> lbs = new ArrayList<Book>();
  9     
 10     static{
 11         Book b1 = new Book("101", "Java", 45.5);
 12         lbs.add(b1);
 13         Book b2 = new Book("102", "JavaWeb", 50);
 14         lbs.add(b2);
 15         Book b3 = new Book("103", "HTML", 50.5);
 16         lbs.add(b3);
 17     }
 18     
 19     public static void main(String[] args) {
 20         zsgc();
 21     }
 22     
 23     public static void zsgc(){
 24         for(;;){
 25             System.out.println("***********************");
 26             System.out.println("*      1、添加图书                  *");
 27             System.out.println("*      2、删除图书                  *");
 28             System.out.println("*      3、修改图书                  *");
 29             System.out.println("*      4、查询所有图书          *");
 30             System.out.println("*      5、查询一本图书          *");
 31             System.out.println("*      0、退出程序                  *");
 32             System.out.println("***********************");
 33             int i = inputInt("请输入要选择的操作:");
 34             switch (i) {
 35             case 1:
 36                 add();
 37                 break;
 38             case 2:
 39                 del();
 40                 break;
 41             case 3:
 42                 update();
 43                 break;
 44             case 4:
 45                 findAll();
 46                 break;
 47             case 5:
 48                 findOne();
 49                 break;
 50             case 0:
 51                 return;
 52             default:
 53                 System.out.println("输入错误,请重新输入!");
 54                 break;
 55             }
 56         }
 57     }
 58 
 59     private static void findOne() {
 60         String name = inputStr("请输入要查询的图书名称:");
 61         int index = 0;
 62         System.out.println("id\t图书名称\t价格");
 63         for(Book book : lbs){
 64             if(name.equals(book.getName())){
 65                 System.out.println(book.getId()+"\t"+book.getName()+
 66                         "\t"+book.getPrice());
 67             }
 68             index++;
 69         }
 70     }
 71 
 72     private static void findAll() {
 73         System.out.println("id\t图书名称\t价格");
 74         for(Book book : lbs){
 75             System.out.println(book.getId()+"\t"+book.getName()+"\t"+book.getPrice());
 76         }
 77         
 78     }
 79 
 80     private static void update() {
 81         String id = inputStr("请输入要修改的图书id:");
 82         int index = 0;
 83         for(Book book : lbs){
 84             if (id.equals(book.getId())) {
 85                 book.setName(inputStr("请输入修改后的名称:"));
 86                 book.setPrice(inputDouble("请输入修改后的价格:"));
 87                 lbs.remove(index);
 88                 lbs.add(index, book);
 89                 System.out.println("修改成功!");
 90             }
 91             index++;
 92         }
 93     }
 94 
 95     private static void del() {
 96         String id = inputStr("请输入要删除的图书id:");
 97         int index = 0;
 98         try{
 99             for(Book book : lbs){
100                 if (id.equals(book.getId())) {
101                     lbs.remove(index);
102                     System.out.println("删除成功!");
103                 }
104                 index++;
105             }
106         }catch (Exception e) {
107             // TODO: handle exception
108         }
109         
110             
111         
112     }
113 
114     private static void add() {
115         String id = inputStr("请输入图书id:");
116         String name = inputStr("请输入图书名称:");
117         double price = inputDouble("请输入图书价格:");
118         Book b = new Book(id, name, price);
119         lbs.add(b);
120         System.out.println("添加成功!");
121     }
122 
123     private static double inputDouble(String string) {
124         System.out.print(string);
125         return new Scanner(System.in).nextDouble();
126     }
127 
128     private static String inputStr(String string) {
129         System.out.print(string);
130         return new Scanner(System.in).nextLine();
131     }
132 
133     private static int inputInt(String string) {
134         System.out.print(string);
135         return new Scanner(System.in).nextInt();
136     }
137 }

 

 

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

 

 1 <%@page import="com.sykjxy.zy01.Book"%>
 2 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
 3 
 4 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 5 <html>
 6   <head>
 7     <title></title>
 8   </head>
 9   <body>
10       <%
11           List<Book> lbs = new ArrayList<Book>();
12           lbs.add(new Book("101","Java",50.5));
13           lbs.add(new Book("102","JavaWeb",50));
14           lbs.add(new Book("103","HTML",40.8));
15        %>
16        <table>
17            <tr>
18                <th>图书编号</th>
19                <th>图书名称</th>
20                <th>图书价格</th>
21            </tr>
22            <%
23                for(int i = 0; i < lbs.size(); i++){
24             %>
25             <tr>
26                 <td><%=lbs.get(i).getId() %></td>
27                 <td><%=lbs.get(i).getName() %></td>
28                 <td><%=lbs.get(i).getPrice() %></td>
29             </tr>
30             <%
31                 }
32              %>
33        </table>
34   </body>
35 </html>

 

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

用命令实现,
添加一个图书,

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

删除全部图书,

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

查看全部图书,

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

 

 

posted @ 2022-05-02 19:22  宇文92  阅读(20)  评论(0)    收藏  举报