In this project, you mustt design a java program using mybatis and mysql in order for it to do the following: -Ask the u

Post by **answerhappygod** » Tue May 24, 2022 9:33 am

: In This Project You Mustt Design A Java Program Using Mybatis And Mysql In Order For It To Do The Following Ask The U 1 (37.22 KiB) Viewed 13 times

Hello, i need help in solving this project , i need the java code for the first 2 parts.
i created the table in mysql
In this project, you mustt design a java program using mybatis and mysql in order for it to do the following: -Ask the user to enter info for a bus and inserts it into the table (that we created in mysql). -Retrieves all the buses entered by the user and display them every bus on a line using the following order: Brand - Model - Color - Year - Owner : firstname, lastname -Enter a given brand and model, and then display the total of owners for that particular brand and model, then displays the list of owners, one owner by line. Note: use this table CREATE TABLE 'BUS `( 'busld' int NOT NULL AUTO_INCREMENT, 'firstname' varchar(25) DEFAULT NULL, "lastname varchar(30) DEFAULT NULL, brand varchar(30) DEFAULT NULL, model varchar(30) DEFAULT NULL, color varchar(45) DEFAULT NULL, year varchar(30) DEFAULT NULL, PRIMARY KEY ('busld')