package com.database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;

public class Kisikaydet {

	private static final String Uye = null;

	private Connection con;

	private Statement stmt;

	private ResultSet rs;

	private String url;

	private String userId;

	private String password;

public Kisikaydet() {

		url= "jdbc:mysql://localhost:3306/emarket";

		userId= "root";

		password ="";
	}

public void uyeEkle(String ad, String soyad, String email, String sifre)

{

try {

	String insert_statement_sql= "insert into uyeler(ad, soyad, email, sifre) values(?,?,?,?)";

	Class.forName("com.mysql.jdbc.Driver");

    Connection con = DriverManager.getConnection(url, userId, password);

    PreparedStatement stmt = con.prepareStatement(insert_statement_sql);

    // yukarıda oluşturduğumuz sql cümlesini verdik

        stmt.setString(1, ad);

        stmt.setString(2, soyad);

        stmt.setString(3, email );

        stmt.setString(4, sifre);




        stmt.executeUpdate();

        con.close();

} catch (Exception ex) {

// TODO: handle exception

	Logger.getLogger(Datalayer.class.getName()).log(Level.SEVERE, null, ex);

	}

 }


}