INITIAL QUERIES :

mysql > CREATE TABLE product(id INT, pname VARCHAR(45) ,description VARCHAR(45) ,barcode INT, cprice INT, rprice INT, qty INT ,rlevel INT);

mysql> create table vendor(id INT,name VARCHAR(45) , phone VARCHAR(45) , email VARCHAR(45) , address VARCHAR(45));

NOT TO MENTION YOU NEED TO CREATE THE ID IN EVERY TABLE AS PRIMARY KEY AND AUTO_INCREMENT

ALSO U NEED TO CREATE CONNECTION CORRESPONDING TO YOUR DATABASE DETAILS IN Connect()

Syntax- Con = DriverManager.getConnection(“jdbc:mysql://localhoset/YOUR_DATABASE_NAME”,”USER_NAME”,”PASSWORD”);

THANKYOU FOR READING.

**************************** FOR COMPLETE PPT, CONTACT @SINGH_HARISH_IG ************************************

**************************** FOR COMPLETE PPT, CONTACT @SINGH_HARISH_IG ************************************