This blog will help you to connect your java program with SQL Database with all operations like Create Table, Insert , Select , Update and Delete operations. Step 1: F irst we required drivers which we can use to connect our SQL database with Java. So in you need to add drivers as shown in the next steps. Step 2: Go to you project -> Libraries->Right Click and Add JAR/Folder Go to C:\Program Files\NetBeans 8.2\ide\modules\ext\ and Select mysql-connector-java-5.1.23-bin.jar Step 3: Again Go to you project -> Libraries->Right Click and Add Library Go to Library and Add Java DB Driver Step 4: Now we have added all the Libraries so now we will create a database in the SQL. To Create New Database Go to Services->Java DB->Right Click ->Create Database Type New Database Name = STUDENTS, Username=APP, Password=root and Confirm Password=root Now Connect Your Database by Right Click on STUDENTS and Click o...
Posts
Showing posts from July, 2020