We have three tables in the database written in the bean format Goods.java
public class Goods {private int id;private string goodsname;private string goodsstyle;private int goodsnumber;private Stri ng Storageid;public int getId () {return ID;} public void setId (int id) {this.id = ID;} Public String Getgoodsname () {return goodsname;} public void Setgoodsname (String goodsname) {this.goodsname = Goodsname;} Public String Getgoodsstyle () {return goodsstyle;} public void Setgoodsstyle (String goodsstyle) {this.goodsstyle = Goodsstyle;} public int Getgoodsnumber () {return goodsnumber;} public void Setgoodsnumber (int goodsnumber) {this.goodsnumber = Goodsnumber;} Public String Getstorageid () {return storageid;} public void Setstorageid (String storageid) {This.storageid = Storageid;}}
Storage.java
Public classStorage {Private intID; PrivateString Storagename; PrivateString Storagestyle; Private intStorageid; Public intgetId () {returnID; } Public voidSetId (intID) { This. ID =ID; } PublicString Getstoragename () {returnStoragename; } Public voidsetstoragename (String storagename) { This. Storagename =Storagename; } PublicString Getstoragestyle () {returnStoragestyle; } Public voidSetstoragestyle (String storagestyle) { This. Storagestyle =Storagestyle; } Public intGetstorageid () {returnStorageid; } Public voidSetstorageid (intStorageid) { This. Storageid =Storageid; } }
Users.java
Public classUser {Private intID; PrivateString username; PrivateString userpwd; PrivateString Flag; Public intgetId () {returnID; } Public voidSetId (intID) { This. ID =ID; } PublicString GetUserName () {returnusername; } Public voidSetusername (String username) { This. Username =username; } PublicString getuserpwd () {returnuserpwd; } Public voidsetuserpwd (String userpwd) { This. userpwd =userpwd; } PublicString Getflag () {returnFlag; } Public voidSetflag (String flag) { This. Flag =Flag; }}
Java Warehouse Management System (II)