第九周作业
1.做一个图书类Book id,name,price ,get,set访问器，构造方法2个，1个无参，1个有参做一个测试类，在main中创建3个图书对象，放到list集合中。做一个菜单，可以添加，删除，修改，查询
package myweb;
//做一个图书类Book id,name,price
//get,set访问器，构造方法2个，1个无参(Super)，1个有参(Fields)
public class Book {
int id;
String name;
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();
// TODO Auto-generated constructor stub
}
@Override
public String toString() {
return "Book [id=" + id + ", name=" + name + ", price=" + price + "]";
}
}
package myweb;
//做一个测试类，在main中创建3个图书对象，放到list集合中
//做一个菜单，可以添加，删除，修改，查询
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;
public class Main {
static java.util.List<Book> list = new ArrayList<Book>();
static {//static是静态修饰符,修饰的成员可以通过类名加'.'进直接访问
Book b1 = new Book(1, "book1", 11.11);
Book b2 = new Book(2, "book2", 22.22);
Book b3 = new Book(3, "book3", 33.33);
list.add(b1);
list.add(b2);
list.add(b3);
}
/**
* @param args
* @return
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
while (true) {
System.out.println("主页面");
System.out.println("1.添加");
System.out.println("2.删除");
System.out.println("3.修改");
System.out.println("4.查询");
System.out.println("5.退出程序");
System.out.println("请选择1-5");
Scanner scanner = new Scanner(System.in);
int i = scanner.nextInt();
switch (i) {
case 1:
addbook();
System.out.println("是否返回主界面Y/N?");
String s = scanner.next();
if (s.equals("Y")) {
break;
} else {
return;
}
case 2:
delBoook();
System.out.println("是否返回主界面Y/N?");
s = scanner.next();
if (s.equals("Y")) {
break;
} else {
return;
}
case 3:
update();
System.out.println("是否返回主界面Y/N?");
s = scanner.next();
if (s.equals("Y")) {
break;
} else {
return;
}
case 4:
search();
System.out.println("是否返回主界面Y/N?");
s = scanner.next();
if (s.equals("Y")) {
break;
} else {
return;
}
case 5:
System.out.println("退出成功");
return;
}
}
}
private static void search() {
// TODO Auto-generated method stub
for (Book book4 : list) {
System.out.println(book4);
}
}
private static void update() {
// TODO Auto-generated method stub
System.out.println("请输入修改的图书id");
int update = new Scanner(System.in).nextInt();
for (Book book : list) {
if (update == book.getId()) {
System.err.println("请输入名称");
String b1 = new Scanner(System.in).next();
System.err.println("请输入价格");
double c1 = new Scanner(System.in).nextDouble();
book.setName(b1);
book.setPrice(c1);
System.out.println("修改成功");
}
}
}
private static void delBoook() {
System.out.println("请输入你要删除的图书id");
int id = new Scanner(System.in).nextInt();
try {
for (Book book : list) {
if (list.size() != 0) {
if (id == book.getId()) {
list.remove(book);
System.out.println("删除成功");
}
}
}
} catch (Exception e) {
// TODO: handle exception
}
}
private static void addbook() {
// TODO Auto-generated method stub
//构造一个Scanner类的对象来获取用户的输入
Scanner scanner = new Scanner(System.in);
System.err.println("请输入id");
int id = scanner.nextInt();
System.err.println("请输入名称");
String name = scanner.next();
System.err.println("请输入价格");
double price = scanner.nextDouble();
Book book = new Book(id, name, price);
list.add(book);
System.out.println("添加成功");
}
}
2.上题的类，在一个JSP页面中，创建一个集合，里面放3个图书，集合循环遍历显示在页面上。
<%@page import="myweb.Book"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body>
<%
List<Book> list=new ArrayList<Book>();
Book b1 = new Book(1, "book1", 11.11);
Book b2 = new Book(2, "book2", 22.22);
Book b3 = new Book(3, "book3", 33.33);
list.add(b1);
list.add(b2);
list.add(b3);
for(Book book4:list){
out.println(book4+"<br>");
}
%>
</body>
</html>
3.在MySQL中创建Book表，里面id,name,price,
用命令实现，
