Open your text editor and create a new document named model.php model.php will contain functions that will connect to a database potentially return PDO statement objects to the controller for processing. updateMessages function updateMessages($id) This method will take a single parameter of id which is the saved id from the last or latest message displayed. It will conditionally select from the table "messages", id, name, message, and time. The condition is that the field id is greater than the parameter for id. The return is the PDOStatement object with the row data from the query.

Create a Windows Forms application. Use the following names for the project andsolution, respectively: Adaline Project and Adaline Solution. Save the application inthe VB2017\Chap08 folder. Create the interface shown in Figure 8-54. The figure alsocontains the major tasks that the application needs to perform. Code the application.Save the solution and then start and test the application.Tasks1). Declare a class-level Integer array to store the sales amounts for the following salespeople.You can create either a two-row, six-column array or a six-row, two-colurnn array.

In this project you will implement a student database using JavaFX. A GUI should be used as the program's interface. This program must consist of two classes. (1) The first class should define the GUI and handle the database interactions: a. Combo box should allow the user to select one of the four database actions (Insert, Delete, Find, and Update). b. The database should be implemented as a HashMap, with the ID field as the key and a student record consisting of a name and major as the value. c. The operation should be performed when the user clicks the Process Request button. d. If the user attempts to insert a key that is already in the database an error message should be displayed using a JOptionPane message dialog box. e. If the user attempts to delete, find or update a record that is not in the database, a message should also be displayed. f. After each successful operation is completed a JOptionPane window should be...

Using the getSales() function as a reference, create a function thatt will take one parameter (string code) which is a product code (or part thereof), and when the search button is pressed, all sales that include this product code (or part thereof) will be displayed in the jTable. The date boxes in the GUI will be replaced with a text box. The schema of the database where the queries are being used is also attached. public List<Pos> getSales(String fromDate, String toDate){ List<Pos> salesList = new ArrayList<>(); try { String query = "SELECT sales_date, sales_number, prod_code, prod_name, unit_cost, quantity, sales_total " + "FROM Sales, SalesDetails, Product " + "WHERE Sales.sales_number = SalesDetails.sales_number " + "AND SalesDetails.prod_code = Product.prod_id " + "AND sales_date BETWEEN ? AND ?"; PreparedStatement stmt =...

Assignment #2 Design an application to search in a database table of employee records. Each employee record consists of an ID, first name, last name, job title. The user interface should look similar to the sketch shown below. A text field is used to input the search query. A combo box is used to choose the search criteria (e.g. search by ID, search by first name, search by last name). By choosing any criteria and clicking on the "search" button, the correct results should be shown on the "results" pane. Search Query Search criteria Search Results Item1 Item2 Item3 otes E Notes Comments 2:38 PM ENG 3/8/202

hello can you help me with writing the java code

Using Java, create a personal directory that contains a data structure for first name, last name, email address and phone number. The data structure should be able to contain the information for an unlimited number of people (depending on system resources).• The program interface should consist of a menu that provides the user with ways to (at least):▪ Add: Get data from user and add the data to the structure.▪ View: which will view the current data in the directory ▪ Edit/Update: Edit existing data ▪ Remove: Delete an entry▪ Search: which prompts the user for search criteria (program should be smart enough to know how to tell what kind of data is being searched for. Try to make this as versatile as possible). Display the data if found. If not found add the new information to the data structure (you must provide the right input for this).The program should store the data in a file so that the program can be run whenever the user wants, even after closing.• Your program should:▪ Contain...

This should be done with Visual Studio C# console app net core Thanks!

A WriteOnly attribute may be implemented automatically. True vs. False

In the following pseudocode of creating a trigger, the first UPDATE is the ____ of the trigger, and the second UPDATE is the ____ of the trigger. CREATE TRIGGER MyTrigger AFTER UPDATE OF attr ON MyTable ... WHEN ... UPDATE MyTable .... Group of answer choices Action; action Condition; action Event; action Event; condition

For this week's assignment you will allow the user to add employee, view all employees, search employee by ssn, and edit employee information. Below this is what its supposed to look like when completed. I have also included what I started to do but I can't figure out how to add the search by SSN option or the edit employee option. If you can give me a step by step on how to do this in python I would greatly appreciate it.

Task Class Requirements The task object shall have a required unique task ID String that cannot be longer than 10 characters. The task ID shall not be null and shall not be updatable. The task object shall have a required name String field that cannot be longer than 20 characters. The name field shall not be null. The task object shall have a required description String field that cannot be longer than 50 characters. The description field shall not be null. Verify with Juint testing as well

What parameters should be sent to the range constructor to produce a rangewith values 11, 8, 5, 2, -1, -4, -7, -10, -13.