package JavaSource.com.pfe.persistance;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.*;
import JavaSource.com.soned.*;

import java.sql.Statement;



public class ConnectionBdlogin {

	public void ajouter(String req){
			
		bd connect = new bd();
			Connection connection=null;
			
			try {			
				connection= connect.getConnection();
			
			Statement statement= connection.createStatement();
			statement.executeUpdate(req);
			} catch (Exception e) {
				e.printStackTrace();
			}
			finally{
				try {
					connection.close();

				} catch (Exception e) {
					// TODO: handle exception
				}
			}
	}
	
	
	public boolean excuteQuery(String req){
		int nb=0;
		java.util.Vector v=new java.util.Vector();
		Doc u=new Doc();
		boolean a=false;
		bd connect = new bd();
		Connection con=null;
		ResultSet resultats=null;
		try{
			con=connect.getConnection();
			
			Statement stmt = con.createStatement();
			resultats = stmt.executeQuery(req);
			ResultSetMetaData rsmd =(ResultSetMetaData) resultats.getMetaData();
			a=resultats.wasNull();
			int nbCols = rsmd.getColumnCount();
			nb=rsmd.getColumnCount();
			boolean encore = resultats.next();
			a=encore;
			while (encore) {
			for (int i = 1; i <=nbCols ; i++)
			System.out.print(resultats.getString(i) + " ");
			System.out.println();
			
			
			encore = resultats.next();
			}
			resultats.close();
			
			
		}
		catch(Exception e ){
			
		}
		finally{
			try {
				con.close();
				

			} catch (Exception e) {
				// TODO: handle exception
			}
	}
		
			return a;
		
		
		
	}




public java.util.Vector res2(String req){
	  
	  java.util.Vector v=new java.util.Vector();
		int nb=0;
		bd connect = new bd();
		Connection con=null;
		ResultSet resultats=null;
		try{
			con=connect.getConnection();
			
			Statement stmt = con.createStatement();
			resultats = stmt.executeQuery(req);
			ResultSetMetaData rsmd =(ResultSetMetaData) resultats.getMetaData();
			int nbCols = rsmd.getColumnCount();
			nb=nbCols;
			boolean encore = resultats.next();
			while (encore) {
				Doc u=new Doc();
			u.setNom(resultats.getString(1));
			u.setCategorie(resultats.getString(2));
			u.setMotcle1(resultats.getString(3));
			u.setMotcle2(resultats.getString(4));
			u.setMotcle3(resultats.getString(5));
			u.setMotcle4(resultats.getString(6));
			u.setMotcle5(resultats.getString(7));
			u.setTheFile(resultats.getString(8));

			v.add(u);
			encore = resultats.next();
			}
			resultats.close();
			
			
		}
		catch(Exception e ){
			
		}
		finally{
			try {
				con.close();
				

			} catch (Exception e) {
				// TODO: handle exception
			}
	}
		return v;
	
	}
}