public static ArrayList<String> showName() {
        ArrayList<String> products = new ArrayList<String>();
        Database db = dbconnect();
            try {	
                db.prepare("SELECT name FROM product ORDER BY PID");
		ResultSet rs = db.executeQuery();
		while(rs.next()) {
			products.add(rs.getString(rs.getMetaData().getColumnName(1)));
		}
                db.close();
        } catch (SQLException e) {
            Error_Frame.Error(e.toString());
        } 
         return products;
    }