- Create a new project in NetBeans
- Add my sql connector under the Libraries folder by clicking Add JAR/Folder
download the mysql connector jar file (I’m using 8.0.17 version)
- Add this jar file to the Tomcat/lib folder (to avoid 500 HTTP code errors in JSP file)
- Then , create a database in by initializing the xampp server by starting the MySql
- Create database and table of your choice
- Then , in netbeans create database to get the connection link for your jsp file
All Set good to go!!🚀
Now , create html or jsp files for your project on your own to connect JSP→JDBC(MySql)
To start off let’s create registration forms and make entries and store it in the database for demo to check whether everything is working properly
Eg:
keep the file names as it is as they invoked inside the code suits.If you wish to change the file name don’t forget to update the file names inside the code blocks
Once all set, now run the file from index.html page .VOILA!!🎉 Everything works perfect..⚡