V193
MySQL Workbench - GUI tool for managing MySQL database
Set up a new user for the DB and a new schema populated with sample data.
Use two scripts provided.
V194
Test DB Connection
Steps:
-
Create Eclipse project - > new Dynamic Web Project -> web-customer-tracker
-
Add JDBC driver to WEB-INF ->lib (it is a jar file named .....mysql-connection.....jar). Paste it into lib directory.
-
Under Java Resources -> src -> create a new package named com.luv2code.testdb
-
In that new package, create a new servlet to test a db connection. TestDBServlet (in the settings, uncheck doPost, constructorsFromSuperClas)
V195