/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package cijferregistratie;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;



/**
 *
 * @author Pieter
 */
public class Dbobject {
    private String url = "jdbc:3306://localhost/Cijferregistratie";
    private String user = "root";
    private String password = "pieter";
    private Connection conn = null;
    private Statement stmt = null;
    private ResultSet rs = null;

    public Dbobject() {
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
                    conn = (Connection) DriverManager.getConnection(url, user, password);

        } catch (Exception e) {
            System.out.println(e.getMessage());



        }
    }
    public void loadDeelnemer (Deelnemer d) {
        try {
            stmt = (Statement) conn.createStatement();
            rs = stmt.executeQuery ("select * from deelnemer where Ovnummer = " + d.getOvnummer());
            rs.next();
            System.out.println(rs.getString(4));
            d.setVoornaam(rs.getString(4));

        } catch (Exception e) {
            System.out.println(e.getMessage());
        }

        }
public void insertDeelnemer (Deelnemer d) {
    try {
        stmt = (Statement) conn.createStatement();
        Date datum = new Date(d.getGeboortedatum().getTimeInMillis());
        String sql = "insert into deelnemer values (" + d.getOvnummer() + ",'" + d.getAchternaam()
                + "','" + d.getTussenvoegsel() + "','" + d.getVoornaam() + "','" + datum +"')";
        stmt.execute(sql);


    } catch (Exception e) {
        System.out.println(e.getMessage());
    }

    }
}