Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement