package glasbena_trgovina;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Vector;

public class GlasbenaTrgovina {
Artikel[] artikli;
public Artikel[] najdiArtikle (String name){
try {
// Load JDBC driver
Class.forName("org.postgresql.Driver");
// Make connection
String url = "jdbc:postgresql://localhost:5432/musicshop?user=postgres&password=simonr";
Connection conn = DriverManager.getConnection(url);
// create & execute statement
PreparedStatement st =
conn.prepareStatement("SELECT ime_artikla, cena, popust FROM artikel WHERE ime_artikla LIKE ?");
st.setString(1, "%" + name + "%");
ResultSet rs = st.executeQuery();
if (rs.wasNull())
return null;
Vector<Artikel> v = new Vector<Artikel>();
while (rs.next()) {
v.add(new
Artikel(rs.getString("ime_artikla"),rs.getFloat("cena"),rs.getFloat("popust")));
}
artikli = new Artikel[v.size()];
for (int i = 0; i < v.size(); i++) {
artikli[i] = v.get(i);
}
// clear result & close connection
rs.close();
st.close();
} catch (Exception e) {
}
return artikli;
}
}