问JDBC查询根据名为SQL语句的console.an错误输入检索记录未正确结束

EN

package com.sun.java;

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

      public class TableFetch {

      public static void main(String[] args) throws SQLException {
        // TODO Auto-generated method stub

        Driver drv = new oracle.jdbc.driver.OracleDriver();

        DriverManager.registerDriver(drv);



        Connection con =  DriverManager.getConnection ("url", "user", "password");

        System.out.println("Got the connection from DB" + con);

        System.out.println("kindly enter the sno of the record to fetch");

        Scanner n = new Scanner(System.in);

        int s9 = n.nextInt();

        String sql = "select * from student" + "WHERE sno =" + s9 + ";";
        Statement statement = con.prepareStatement(sql);
        statement.executeQuery(sql);

        n.close();
        }
        }