LlogaritarDB

package tarifa;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

public class LlogaritarDB {
	public static Connection getCon(){
		Connection con=null;
                //Ben te mundur lidhjen me databasen ne mySQL
		try{
			Class.forName("com.mysql.jdbc.Driver");
			con=DriverManager.getConnection("jdbc:mysql://localhost:3306//tarifat","root","admin");
		}catch(Exception e){System.out.println(e);}
		return con;
	}
        //Ben kerkimin ose validimin , vlereson nese keto Emra dhe Fjalekalime egzistojn(boolean) ne databaze dhe egzekuton queryn
	public static boolean validate(String emri,String fjalekalimi){
		boolean status=false;
		try{
			Connection con=getCon();
			PreparedStatement ps=con.prepareStatement("select * from Llogaritar where emri=? and fjalekalimi=?");
			ps.setString(1,emri);
			ps.setString(2,fjalekalimi);
			ResultSet rs=ps.executeQuery();
			status=rs.next();
			con.close();
		}catch(Exception e){System.out.println(e);}


		return status;
	}
        // Lidhet me databazen, egzekuton queryin e cila ben shtimin (insert)

	public static int save(Llogaritar a){
		int status=0;
		try{
			Connection con=getCon();
			PreparedStatement ps=con.prepareStatement("insert into Llogaritar (emri,fjalekalimi,email,nrkontakti) values(?,?,?,?)");
			ps.setString(1,a.getEmer());
			ps.setString(2,a.getFjalekalimi());
			ps.setString(3,a.getEmail());
			ps.setString(4,a.getNrkontakti());
			status=ps.executeUpdate();
			con.close();
		}catch(Exception e){System.out.println(e);}
		return status;
	}
        // Krijon nje liste te klases Llogaritari e cila lidhet me databazen dhe egzekuton queryn nga e cila selektohen te gjitha elementet e tabeles Llogaritari
	public static List<Llogaritar> view(){
		List<Llogaritar> list=new ArrayList<>();
		try{
			Connection con=getCon();
			PreparedStatement ps=con.prepareStatement("select * from Llogaritar");
			ResultSet rs=ps.executeQuery();
			while(rs.next()){
				Llogaritar a=new Llogaritar();
				a.setId(rs.getInt(1));
				a.setEmer(rs.getString(2));
				a.setFjalekalimi(rs.getString(3));
				a.setEmail(rs.getString(4));
				a.setNrkontakti(rs.getString(5));
				list.add(a);
			}
			con.close();
		}catch(Exception e){System.out.println(e);}
		return list;
	}
}