package sqlaplikacija;
import java.sql.*;
public class Konekcija {
    public static void main(String[] args)
    {
         try
         {

                     String dbUrl="jdbc:mysql://localhost:3309/itsbaza";
                     String user= "root";
                     String pass= "";

                    Class.forName("com.mysql.jdbc.Driver");
                    Connection veza= DriverManager.getConnection(dbUrl,user,pass);
                    Statement st=veza.createStatement();
                    String upit="select * from student";
                    try {
                  ResultSet rezultat=st.executeQuery(upit);
                       System.out.println("Ispravljacki program (drajver) je ucitan!");
                     while(rezultat.next())
                     {
                         System.out.println(rezultat.getString("ime")+ " " +
                                 rezultat.getString("prezime") +  " " +rezultat.getString("brIndexa")
                   );
                     };
                  String upit2="delete from student where ime = 'Pera'";
                  PreparedStatement pstate= veza.prepareStatement(upit2);

                        try {
                            pstate.executeUpdate();
                        } catch (SQLException e) {
                              System.out.println("Izuzetak.  " + e);
                        }

             } catch (Exception e) {
                 System.out.println("Pogresan upit");
             }


         }
             catch ( SQLException ex)
                     {
                     System.out.println("Izuzetak.  " + ex);
                     }
             catch ( ClassNotFoundException e)
                     {
                     System.out.println("Upravljacki program nije caitan." + e);
                     }


    }
}