jsp第九周作业

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

package housework;

public class Book {

    private String id;

    private String name;

    private double price;

    //生成getters和setters

    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 double getPrice() {

        return price;

    }

    public void setPrice(double price) {

        this.price = price;

    }

    //有参构造

    public Book(String id, String name, double price) {

        super();

        this.id = id;

        this.name = name;

        this.price = price;

    }

    //无参构造

    public Book() {

        super();

    }

}

package housework;

import java.util.ArrayList;

import java.util.List;

import java.util.Scanner;

import com.sun.org.apache.bcel.internal.generic.Select;

public class test {

    /**

     * @param args

     */

    public static void main(String[] args) {

        // TODO Auto-generated method stub

        List<Book> list = new ArrayList<Book>();

        Book book = new Book();

        Book book1 = new Book("001", "jsp实用教程", 45.88);

        Book book2 = new Book("002", "C程序设计", 59.80);

        Book book3 = new Book("003", "软件测试技术", 52.60);

        list.add(book1);

        list.add(book2);

        list.add(book3);

        show(list, book);

    }

    public static void show(List<Book> list, Book book) {

        System.out.println("1.添加图书");

        System.out.println("2.查询图书");

        System.out.println("3.修改图书");

        System.out.println("4.删除图书");

        System.out.println("请选择你想要的操作");

        System.out.println("========================");

        select(list, book);

    }

    public static void select(List<Book> list, Book book) {

        int i = new Scanner(System.in).nextInt();

        switch (i) {

        case 1:

            System.out.println("请输入添加的图书编号");

            book.setId(new Scanner(System.in).next());

            System.out.println("请输入添加的图书名称");

            book.setName(new Scanner(System.in).next());

            System.out.println("请输入添加的图书价格");

            book.setPrice(new Scanner(System.in).nextDouble());

            list.add(book);

            System.out.println("添加成功");

            System.out.println("========================");

            show(list, book);

            break;

        case 2:

            for (int a = 0; list != null && a < list.size(); a++) {

                System.out.println(list.get(a).getId() + "."

                        + list.get(a).getName() + "," + list.get(a).getPrice());

            }

            show(list, book);

            break;

        case 3:

            System.out.println("请输入要修改图书的编号");

            String q = new Scanner(System.in).next();

            for (int a = 0; list != null && a < list.size(); a++) {

                if (list.get(a).getId().equals(q)) {

                    list.remove(a);

                    System.out.println("请输入要修改图书名称");

                    String n1 = new Scanner(System.in).next();

                    System.out.println("请输入要修改图书价格");

                    double p1 = new Scanner(System.in).nextDouble();

                    Book b = new Book(q, n1, p1);

                    list.add(b);

                    break;

                }

            }

            System.out.println("修改成功");

            System.out.println("========================");

            show(list, book);

            break;

        case 4:

            System.out.println("请输入要删除图书的名称");

            String name = new Scanner(System.in).next();

            for (int a = 0; list != null && a < list.size(); a++) {

                if (list.get(a).getName().equals(name)) {

                    list.remove(a);

                }

            }

            System.out.println("删除成功");

            System.out.println("========================");

            show(list, book);

            break;

        }

    }

}

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

<%@page import="housework.Book"%>

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<html>

<head>

</head>

<body>

     <%

        List<Book> list = new ArrayList<Book>();

        Book book = new Book();

        Book book1 = new Book("001", "jsp实用教程", 45.88);

        Book book2 = new Book("002", "C程序设计", 59.80);

        Book book3 = new Book("003", "软件测试技术", 52.60);

        list.add(book1);

        list.add(book2);

        list.add(book3);

        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,
用命令实现，
添加一个图书，
根据名称删除图书，
把所有名称是“我”开头的图书删除，
删除全部图书，
把20元以上的图书价格都修改为18.8，
查看全部图书，
查看价格高于10块钱的全部图书

create table Book(id int(10),name char(10),price double(10));

insert into Book(id,name,price)values(001,"jsp教程",88);

delete from Book where name='java';

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;

巴特西

jsp第九周作业

最新文章

热门文章