Query_Formatting

package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

public class Insert_QueryFormatting {

public static void main(String[] args) throws ClassNotFoundException ,SQLException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr");
Statement st = con.createStatement();
Scanner sc = new Scanner(System.in);
System.out.println("Enter  FBI Code:");
int code = sc.nextInt();
System.out.println("Enter FBI Name:");
String name = sc.next();
System.out.println("Enter FBI Latitude:");
int lati = sc.nextInt();
System.out.println("Enter FBI Longitude:");
int longi = sc.nextInt();
String query = String.format("Insert into JDBC_SAMPLE_FBI values(%d,'%s',%d,%d)",code,name,lati,longi);
System.out.println(query);
int count = st.executeUpdate(query);
if(count>0)
{System.out.println("Data Inserted in JDBC_SAMPLE_FBI table");}
else {System.out.println("Something went wrong, pleaase contact Customer Services");}

}

}