jdbc商品管理系统 增删改查练习

1、在mysql中新增一张商品表
字段如下：id(自增，主键），商品名称，价格，库存
2、实现商品的增删查
2.1菜单如下
----------------------------------------商品管理系统-------------------------------------------
1、商品信息显示 2、商品新增 3、商品删除 4、退出
2.2、商品信息显示：显示出商品表里面的商品
2.3、商品新增，不断新增商品直到新增完成

2.4、商品删除，提示输入商品的id，然后删除

Commodity.java

package model;

public class Commodity {
	
	private int id;
	private String name;
	private double price;
	private int stock;
	
	public Commodity() {
		super();
	}

	public Commodity(String name, double price, int stock) {
		super();
		this.name = name;
		this.price = price;
		this.stock = stock;
	}
	
	public Commodity(int id, String name, double price, int stock) {
		super();
		this.id = id;
		this.name = name;
		this.price = price;
		this.stock = stock;
	}
	
	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 int getStock() {
		return stock;
	}
	public void setStock(int stock) {
		this.stock = stock;
	}
}

CommodityOperator.java

package controller;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import model.Commodity;
import utility.DatabaseController;

public class CommodityOperator {
	
	private DatabaseController ds = new DatabaseController();
	
	//查询所有数据
	public ArrayList<Commodity> getAllcommodity(){
		
		ArrayList<Commodity> al = new ArrayList<Commodity>();
		String sql = "select * from commodity";
		ResultSet rs = ds.executeQuery(sql);
		try {
			if(rs != null)
			while(rs.next()){
				int id = rs.getInt("id");
				String name = rs.getNString("name");
				double price