import java.util.*;
import java.sql.*;
class InsertData{
    public static void main(String[] args){
        try{
           Scanner input=new Scanner(System.in);
           System.out.print("DEPT Code: ");
           String code=input.nextLine();
           System.out.print("DEPT Name: ");
           String name=input.nextLine();

           Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("Select * from dept where DEPT_NO='"+code+"'");
           int count=0;
           while(rs.next()){
               count++;
           }
           if(count>0){
               System.out.println("Error! Your dept code is not valid!");
           }
           else{
           st.executeUpdate("insert into dept(DEPT_NO,DEPT_NAME) values('"+code+"','"+name+"')");
           System.out.println("Data is successfully inserted!");
           }
        }
        catch(Exception e){
         System.out.println(e);
        }
    }
}