package javaapplication1;

       import java.sql.*;
       import java.io.*;



 public class prepare  {

 public static void main(String args[]) throws Exception
{


    try{

        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/idemi?zeroDateTimeBehavior=convertToNull","root","");
        System.out.println("Connection created.. !");
        PreparedStatement ps = conn.prepareStatement("insert into boy values(?,?)");



        boolean b = ps.execute("create table boy(name varchar(30), age int)");
        System.out.println("Table Boy created... !");
        BufferedReader br = new BufferedReader(new InputStreamReader(System.in));

        System.out.println("Enter boy name");
        String bname = br.readLine();

        System.out.println("Enter boy age");
        int bage = Integer.parseInt(br.readLine());

        ps.clearParameters();

        ps.setString(1,bname);
        ps.setInt(2, bage);

        ps.executeUpdate();
    }
    catch(Exception e)
    {
          System.out.println(e);
    }
}

}