d

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package pab_lab1_grs2232;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;

public class BazaDanych {
    public void baza(){
        try{
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection polaczenie = DriverManager.getConnection("jdbc:sqlserver://localhost\\MSSQLServer2017;databaseName=S2232","sa","student");
            Statement skladnia = polaczenie.createStatement();
            ResultSet rezultat = skladnia.executeQuery(
                    "select nazwa, cena from dane"
            );
            while(rezultat.next()){
                System.out.println(rezultat.getString("nazwa")+" "+rezultat.getString("cena"));
            }
            polaczenie.close();
        }
        catch(Exception ex){
            JOptionPane.showMessageDialog(null,"Błąd"+ex.getMessage(),"Błąd programu", JOptionPane.ERROR_MESSAGE);
        }
    }
}