public void connectAndRetrieve(){
        try{
               Connection con = DriverManager.getConnection
               ("jdbc:mysql://localhost:3306/supermarket","root","");

               Statement stmt = con.createStatement();
               ResultSet rs = stmt.executeQuery("SELECT * FROM products WHERE name='"+jTextField1.getText() + "'");

               DefaultTableModel m = (DefaultTableModel) jTable1.getModel();
               while(rs.next()){
                   m.addRow(new Object[]{rs.getInt(1), rs.getString(2), rs.getFloat(3),  rs.getInt(4)});
               }

               con.close();

        }

        catch (Exception e)
        {

        }
    }