1、在mysql中新增一张商品表
字段如下:id(自增,主键),商品名称,价格,库存
2、实现商品的增删查
2.1菜单如下
----------------------------------------商品管理系统-------------------------------------------
1、商品信息显示 2、商品新增 3、商品删除 4、退出
2.2、商品信息显示:显示出商品表里面的商品
2.3、商品新增,不断新增商品直到新增完成
CommodityOperator.java
字段如下: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