Using the getFirst() function as a template for reference, code the saveProduct() function that will be called when the save button of the depicted screen is clicked. The text from the JTextFields will be used as parameters.The database schema for the SQL tables are also depicted. The number of the product is the primary key and is set to auto-increment. public Product getFirst() { if (openConnection()) { try{ Product temp = null; String query = "SELECT * FROM products order by number asc limit 1"; // our SQL SELECT query. Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); // create the java statement ResultSet rs = st.executeQuery(query);// execute the query, and get a java resultset while (rs.next()) // iterate through the java resultset { temp = new Product(rs.getInt("number"),rs.getString("prodid"),rs.getString("prodname"),rs.getFloat("price"),rs.getInt("onhand")); } st.close(); closeConnection();

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Using the getFirst() function as a template for reference, code the saveProduct() function that will be called when the save button of the depicted screen is clicked. The text from the JTextFields will be used as parameters.The database schema for the SQL tables are also depicted. The number of the product is the primary key and is set to auto-increment.

public Product getFirst()

{

if (openConnection())

{

try{

Product temp = null;

String query = "SELECT * FROM products order by number asc limit 1"; // our SQL SELECT query.

Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); // create the java statement

ResultSet rs = st.executeQuery(query);// execute the query, and get a java resultset

while (rs.next()) // iterate through the java resultset

{

temp = new Product(rs.getInt("number"),rs.getString("prodid"),rs.getString("prodname"),rs.getFloat("price"),rs.getInt("onhand"));