- Study The User Interface Given Below And Complete The Code As Per Instructions The Ui Designed Below Is Part Of A Pos S 1 (50.35 KiB) Viewed 1833 times
- Study The User Interface Given Below And Complete The Code As Per Instructions The Ui Designed Below Is Part Of A Pos S 2 (94.83 KiB) Viewed 1833 times
- Study The User Interface Given Below And Complete The Code As Per Instructions The Ui Designed Below Is Part Of A Pos S 3 (142.86 KiB) Viewed 1833 times
application below.
Study the user interface given below and complete the code as per instructions. The UI designed below is part of a POS systems to add products of sale to the company database. For this function to work, the user needs to provide the following information: product ID, product name, price and quantity available in stock. Once the SAVE button is pressed – this information is stored in the database. The DELETE button deletes the product by ID listed. ProductID Product Name Product Price Quantity DELETE SAVE E • database name "products" • table name = "product_details"
Field name and Type: • Product_ID • Name • Quantity • Price VarChar VarChar Integer Double You have been asked to implement this system as a Java RMI application. The Server application has already been written for you. import java.rmi.*; import java.rmi.server.*; import java.rmi.registry.*; public class Server extends DBFuncImpl { Server() throws Exception { super(); } public static void main(String[] args) throws Exception { 1 try 2 { //instantiate the implementation class DBFuncImpl stub = new DBFuncImpl(); //Bind the remote object (stub) in the registry Registry reg = LocateRegistry.createRegistry (9999); reg.rebind("myDBServer", stub);
Code the following: • Code the remote interface. (4 Marks) • Provide the implementation of the remote interface. A partial code is provided for you. (8 Marks) public class DBFuncImpl extends UnicastRemoteobject implements DBFuncInt { public DBFuncImpl() throws Exception super(); ) public static Connection getConnection() throws SQLException Connection conn = null; String username = "root"; String password = ""; String url = "jdbc:mysql://localhost: 3306/products"; try Class.forName ("com.mysql.jdbc.Driver"); //establish a connection to database conn = DriverManager.getConnection (url, username, password); } catch (Exception e) { System.out.println(e.getMessage()); } return conn; ) public void saveproduct (String queryString) //complete the implementation ) public void deleteproduct (String queryString) // complete the implementation