package films;
import java.sql.*;

import java.util.logging.*;
import java.util.Random;

public class Films {

public static Connection Soedinenie = null;

public static Statement stmt = null;

public static ResultSet Rezultat = null;



public static Random Random = new Random();

public static void main(String[] args){//ГЛАВНЫЙ МЕТОД;
try{
String url = "jdbc:postgresql://localhost:5432/films";
String name = "postgres";
String password = "privet";//пароль
Class.forName("org.postgresql.Driver");//загружаем драйвер



Soedinenie = DriverManager.getConnection(url, name, password);//создаем соединение
stmt = Soedinenie.createStatement();
}
catch(ClassNotFoundException | SQLException ex){
System.out.println("errors");}finally{
///////////////////////////////////////////////////////////////////////////////////////////////////

// IskomoeSlovo("А");
IskomoeSlovo("'; delete from films---"); // KAAAAAAAAAAAAAAAAAAAAAAAKKKKKKKKKKKK??? D:

public static void IskomoeSlovo(String Slovo){//ИЩЕМ ЭТО СЛОВО В НАЗВАНИЮ;
try{

/*Как быть?*///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////


Rezultat = stmt.executeQuery("SELECT * FROM films" + " WHERE name like '%"+Slovo+"%';");
/while(Rezultat.next()){
System.out.println(Rezultat.getRow()+"\t"+Rezultat.getString("name")+"\t"+"\n"+Rezultat.getString("genre")+"\t"+"\n"+Rezultat.getInt("raiting"));}
}
catch(Exception ex){ Logger.getLogger(Films.class.getName()).log(Level.SEVERE, null, ex);}
End();}


}