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块钱的全部图书

浙公网安备 33010602011771号