Posts

Showing posts from July, 2020
Image
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...