import java.sql.*;
import java.util.Vector;

public class DBConnect {

    private Connection con;
    private Statement st;
    private ResultSet rs;

    public DBConnect() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/beispiel","root","");
            st =  con.createStatement();

        } catch(Exception e) {
            System.out.println("Err: "+e);

        }
    }

    public void getData() {
        try {
            String query = "SELECT * FROM beispiel";
            rs = st.executeQuery(query);
            System.out.println("Records From DB");
            while(rs.next()) {
                Vector jebanirot = new Vector();
                jebanirot.add(rs.getString("artikelnr"));
                jebanirot.add(rs.getString("name"));
                jebanirot.add(rs.getString("preis"));
            }



        } catch(Exception e) {
            System.out.println("Err: "+e);

        }
    }


}