java no4

import java.sql.*;
class Main {
  static String db_user = "root";
  static String db_pass = "root";
  static String db_url = "jdbc:mysql://localhost/";
  public static void main(String[] args) {
    try{
      class.forName("com.jdbc.driver");
      Connection con = DriverManager.getConnection(db_url,db_user,db_pass);
      Statement stmt = con.createStatement;
      //create table
      String sql = "CREATE TABLE AUTHOR"+
                    "(ID INT NOT NULL" +
                    "FNAME VARCHAR(255)" +
                    "LNAME VARCHAR(255"))";

      string sql2 = "CREATE TABLE Book" +
                    "(ID INT NOT NULL" +
                    "AUTHOR_ID INT NOT NULL" +
                    "TITLE VARCHAR(255)" +
                    "YEAR VARCHAR(255)" +
                    "ISBN VARCHAR(255)" +
                    "PRICE INT" +
                    "FOREIGN KEY(AUTHOR_ID REFERENCES AUTHOR(ID))";

      stmt.executeUpdate(sql);
      stmt.executeUpdate(sql2);
      //insert values
      PreparedStatement ps = con.prepareStatement("INSERT INTO AUTHOR(ID,FNAME,
      LNMAE) VALUES(?,?,?)");
      ps.setId(1,1);
      ps.setString(2,'kishore');
      ps.setString(3,'Srinivas');

      ps.executeUpdate();






      // get the specific book name and list the author

      String book_name = "alice in wonderland";
      PreparedStatement ps2 = con.prepareStatement("select * from AUTHOR where id IN ( select AUTHOR_ID from BOOK  where TITLE = ? ) ORDER BY FNAME ASC");

      ps2.setString(1,book_name);
      ResultSet rs = ps2.excuteQuery();
      while(rs.next())
      {
        System.out.println(rs.getString("FNAME"));
        System.out.println(rs.getString("LNAME"));

      }

      // get the specific author name and list the books

      String author_name ="oprah";
      PreparedStatement ps2 = con.prepareStatement("select * from BOOK where AUTHOR_ID  IN ( select ID from AUTHOR  where FNAME = ? ) ORDER BY TITLE ASC");

      ps2.setString(1,author_name);
      ResultSet rs = ps2.excuteQuery();
      while(rs.next())
      {
        System.out.println(rs.getString("TITLE"));
        System.out.println(rs.getString("PRICE"));

      }






    }catch(Exception e){}

  }
}