JSP第九周作业
1.做一个图书类Book id,name,price ,get,set访问器，构造方法2个，1个无参，1个有参
做一个测试类，在main中创建3个图书对象，放到list集合中。做一个菜单，可以添加，删除，修改，查询
package po; public class Book { private int id; private String name; private double price; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public double getPrice() { return price; } public void setPrice(double price) { this.price = price; } public Book(int id, String name, double price) { super(); this.id = id; this.name = name; this.price = price; } public Book() { super(); } @Override public String toString() { return "Book [id=" + id + ", name=" + name + ", price=" + price + "]"; } }
package po; import java.util.ArrayList; import java.util.List; import java.util.Scanner; public class BookTest { static Scanner sc=new Scanner(System.in); static List<Book> blist=new ArrayList<Book>(); public static void main(String[] args) { // TODO Auto-generated method stub Book b1=new Book(1, "三国演义", 15); Book b2=new Book(2, "水浒传", 20); Book b3=new Book(3, "西游记", 25); blist.add(b1); blist.add(b2); blist.add(b3); System.out.println(blist); show(); } public static void show() { int menu = 0; while(true) { System.out.println("\n========= 1.添加=2.删除=3.修改=4.查询 ========="); System.out.println("请输入你的选择："); menu = sc.nextInt(); switch (menu) { case 1: add(); break; case 2: del(); break; case 3: update(); break; case 4: select(); break; default: System.out.println("没有这个选项！\n"); break; } } } public static void add() { System.out.println("请输入要添加的Id"); int id=sc.nextInt(); System.out.println("请输入要添加的书名"); String name=sc.next(); System.out.println("请输入要添加书的价格"); double price=sc.nextDouble(); Book b=new Book(id,name,price); blist.add(b); } public static void del() { System.out.println("请输入要删除书的Id"); int id=sc.nextInt(); for (Book b:blist) { if (b.getId() == id) { blist.remove(b); } } } public static void update() { System.out.println("请输入要修改的Id"); int id=sc.nextInt(); System.out.println("请输入要修改书的价格"); double price=sc.nextDouble(); for (Book b : blist) { if (b.getId()== id) { b.setPrice(price); } } } public static void select() { for (Book book : blist) { System.out.println(book); } } }
2.上题的类，在一个JSP页面中，创建一个集合，里面放3个图书，集合循环遍历显示在页面上。
<%@ page language="java" import="java.util.*" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@ page import= "po.* "%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Insert title here</title> </head> <body> <% List<Book> list = new ArrayList<Book>(); Book b1=new Book(1,"三国演义",20); Book b2=new Book(2,"水浒传",25); Book b3=new Book(3,"西游记",30); list.add(b1); list.add(b2); list.add(b3); for(Book b:list){ out.println(b); } %> </body> </html>
3.在MySQL中创建Book表，里面id,name,price,
用命令实现，
添加一个图书，
根据名称删除图书，
把所有名称是“我”开头的图书删除，
删除全部图书，
把20元以上的图书价格都修改为18.8，
查看全部图书，
查看价格高于10块钱的全部图书
INSERT INTO Book (name,price) VALUES('三国演义',25);
DELETE FROM Book WHERE NAME LIKE '我%';
DELETE FROM Book;
UPDATE book SET price=18.8 WHERE price>20;
SELECT * FROM Book;
SELECT * FROM Book WHERE price>10;
