Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please use eclipse and mysql Use Java and SQL, implement the following functionality: 1. Implement a user registration and login interface so that only a

please use eclipse and mysqlimage text in transcribed

Use Java and SQL, implement the following functionality: 1. Implement a user registration and login interface so that only a registered user can login into the system. The root user has a username "root" and password "pass1234" (Note this is a different root - it is for the website, not a user for the MySQL database system). Sign up for a new user with information such as: username (which is an email), password, password confirmed, first name, last name, age. Duplicate username should be detected and fail the signup. Unmatching passwords should be detected as well. For the root user, implement a button called "Initialize Database". This button will only be displayed after the root user signed in successfully. When the root user clicks the "Initialize Database" button, the following three things will happen: 1) all existing tables, if any, will be dropped; 2) all necessary tables will be created or re-created automatically; and 3) each table will be inserted with at least 10 realistic tuples (which can be hard-coded in your program), so that each query below will return some meaningful results. Use Java and SQL, implement the following functionality: 1. Implement a user registration and login interface so that only a registered user can login into the system. The root user has a username "root" and password "pass1234" (Note this is a different root - it is for the website, not a user for the MySQL database system). Sign up for a new user with information such as: username (which is an email), password, password confirmed, first name, last name, age. Duplicate username should be detected and fail the signup. Unmatching passwords should be detected as well. For the root user, implement a button called "Initialize Database". This button will only be displayed after the root user signed in successfully. When the root user clicks the "Initialize Database" button, the following three things will happen: 1) all existing tables, if any, will be dropped; 2) all necessary tables will be created or re-created automatically; and 3) each table will be inserted with at least 10 realistic tuples (which can be hard-coded in your program), so that each query below will return some meaningful results

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems Third International Conference Achids 2011 Daegu Korea April 2011 Proceedings Part 2 Lnai 6592

Authors: Ngoc Thanh Nguyen ,Chong-Gun Kim ,Adam Janiak

2011th Edition

3642200419, 978-3642200410

More Books

Students also viewed these Databases questions

Question

=+2. Does your message use dishonest or misleading language?

Answered: 1 week ago