package insertData;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.Scanner;
public class insertData {
private static Scanner sc;
public static void main(String[] args) throws Exception { // throws Exception is used to handle the exception without using try-catch block
sc = new Scanner(System.in);
System.out.println("Enter the student details: ");
System.out.print("Enter the student id: ");
int id = sc.nextInt();
System.out.print("Enter the student name: ");
String name = sc.next();
System.out.print("Enter the student branch: ");
String branch = sc.next();
Class.forName("com.mysql.cj.jdbc.Driver"); // load and register the driver
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3308/jdbc_db", "root", "Akash@123"); // establish the connection
PreparedStatement ps = connection.prepareStatement("insert into student values('"+id+"','"+name+"','"+branch+"')"); // execute the query")
int i = ps.executeUpdate(); // execute the query
if (i > 0) // if the record is inserted successfully then it will return 1 else 0
System.out.println("Record inserted successfully");
else
System.out.println("Record not inserted successfully");
}
}
Files
insert_data_into_database
Folders and files
Name | Name | Last commit date | ||
---|---|---|---|---|
parent directory.. | ||||