Create a single database table to hold information SQL or MySQL

[login to view URL] a connection to a relational database using SQLite or MySQL.

[login to view URL] a single database table to hold information.

Let’s make a simple class called Person for this exercise.


firstName (String)


age (int)

ssn (long)

creditCard (long)

Note that once you have the DB created, you don’t want to do this again every time you run your test program. The easiest way to deal with this – for this assignment, is to comment out the code that creates the DB creation and the table creation while you experiment with the following.

(Aside: I choose ssn and credit card as fields here so that you might think about the persistent storage of sensitive data. There are some pretty strict laws governing the storage of some data. Please don’t use any actual social security numbers or credit card numbers in this exercise.)

[login to view URL] the insertion of a record into the database Insert several records.

[login to view URL] a method called insertPerson(Person person) that adds a person object to your database. Create another object of type Person, and demonstrate calling your method, passing the object to the method.

[login to view URL] the retrieval of information from the database. Use SQL Select statements, to retrieve a particular Person from the database.

[login to view URL] a method called selectPerson that returns a Person object. This method retrieves the data for a Person from the database. We also need to pass a parameter to identify what person. You can use ‘name’ if you like, or if you find it easier to use the database generated ID that’s fine too.

[login to view URL] method returns the object that represents that person. This will require that you extract the data that is returned from the database, and call the Person constructor. (Later you will understand that that this is the data-exchange between the relational database and the business layer. )

[login to view URL] a method called findAllPeople that returns an ArrayList<Person> of objects containing all the people in the database. Demonstrate that it is working correctly.

[login to view URL] a method called deletePerson that removes a person from the database. The parameters will be first name and last name. Print out on the console the data from the record that is being deleted. Use your findAllPeople method to verify that that person has been removed from the database. Consider what this method should return. Suppose the person is not found, should the method return that information somehow?

Taidot: Koodaus, SQL, MySQL

Näytä lisää: create database table xml schema, mysql create user database, save images sql server 2005 database table, how to create a query in mysql, create table student details in sql, create table sql, how to create database in mysql workbench, mysql student database, create database query in mysql, create employee table in mysql, create table in mysql workbench, database table example, create table mysql, create access database table using, create mail database mysql, sql create field database, create database taxi booking system sql, uploading images mysql database table, sql create access database visual basic, mysql query remote database table

Tietoa työnantajasta:
( 2 arvostelua ) orlando, United States

Projektin tunnus: #26568439

27 freelanceria on tarjonnut keskimäärin 49$ tähän työhön


Greetings of the day I have gone through the job description as per the requirement I'm an expert in Codeignitor . Will assure the attendance system with high quality work and will complete on time with the budg Lisää

$90 USD 5 päivässä
(37 arvostelua)

✅Hi sir, just now I read your project requirement and I fell, I do this job very well. my skill matching with your project requirement so I am really interested to do this project. Before start your project I have som Lisää

$50 USD 1 päivässä
(32 arvostelua)

INTRODUCTION I can write all the CRUD codes you specified in your project description. SIMILAR PROJECTS COMPLETED: • • [login to view URL] Lisää

$100 USD 7 päivässä
(8 arvostelua)

⭐⭐⭐⭐⭐ Hello, MR Jourdankev I went through your project description in detail. This is a piece of cake for me. As I am a experienced web developer, I can proudly say you that I can complete this perfectly. I will let yo Lisää

$30 USD 1 päivässä
(4 arvostelua)

I am good in sql and mysql along with automation and development, please let me know if you are good to award this project to me

$55 USD 2 päivässä
(6 arvostelua)

Hello sir. I read your description. I will design your database design and fulfill your 8 points. I am full-stack developer having strong skills in diff technologies. Technologies are: PHP Laravel MYSQL JS JQUERY AJA Lisää

$30 USD 2 päivässä
(7 arvostelua)

- I have working experience of more than 5 years in this field, good with data warehouse modelling by SQL. -with proper coding skills in Python, R, Pyspark, SMV, HIVE SQL, etc., I am well into Big Data so any kind of d Lisää

$45 USD 4 päivässä
(3 arvostelua)

Hello. I am full-stack web developer and expert in SQL databases. I read your description and I can do this task in 2 hours. Send me message so we can talk about details and I can start working.

$25 USD 1 päivässä
(4 arvostelua)

Hi ! In my current Professional Database Administrator role, I have extensive experience with Creating Database include (Procedures, Queries, Views, Index), as well as Administration of on SQL Server versions 2000-201 Lisää

$100 USD 2 päivässä
(3 arvostelua)

Dear Sir, I am kamlesh kumar and I have 7+ year of experience in developing web and desktop application using Java/jee along with php framework like spring MVC, boot, codignitor etc. I have gone through your requirem Lisää

$35 USD 1 päivässä
(1 arvostelu)

Hi, I will develop a fully functional and tested solution for the above specification. I am senior developer and expert in developing database applications using Hibernate/JDBC/[login to view URL] and Entity Framework communica Lisää

$170 USD 7 päivässä
(1 arvostelu)

Hello, I can start making this project right now expert in php/mysql/js/jquery/html/css Best regards

$30 USD 1 päivässä
(0 arvostelua)

Hello, My name is Maksim and SQL PROFESSOR. I've read your project details carefully and I think I can do your project perfectly. I'd been done project similar your project. I have 12+ experience in IT and I mastered S Lisää

$20 USD 1 päivässä
(0 arvostelua)

Hi, Hope you are doing well and having great health I will do this project in a considerable budget for the project. Give me more detail about the work and discuss the deadline. I have done many similar types of proj Lisää

$20 USD 7 päivässä
(0 arvostelua)

Hello there? **I am Senior developer and Having all required skills based on your job post** and I consider myself a responsible, creative, with initiative and punctuality, I accept with pleasure the challenges and go Lisää

$20 USD 7 päivässä
(0 arvostelua)

It looks like a school exam or a job interview test ... do you need the SQL part? or the code too? which language?

$30 USD 2 päivässä
(0 arvostelua)

I have well experience in MySQL to create tables, writing various query to retrieval of information from the relation and also usage of DDL, DML, TCL, ect., will provide work on time with 100% quality as you expected.

$20 USD 7 päivässä
(0 arvostelua)

hi...being Java Certified Developer I assure you to complete the entire within 2 working days. by tomorrow eod you would have your assignment ready or maybe even less than that time. pinge once to discuss further

$50 USD 1 päivässä
(0 arvostelua)

I understand your requirement and I am happy to provide you my service. I am having 2+ years of experience in Database and database operations. I would request you to consider my proposal. It will good opportunity for Lisää

$25 USD 2 päivässä
(0 arvostelua)

Hello! I have experience with SQL in Java, python, c# and node.js! I'll be very happy to work on your project.

$30 USD 3 päivässä
(0 arvostelua)