CREATE OR REPLACE VIEW edt_cahier_pointages AS 
	SELECT point_id, point_visible, point_date_crea, point_date_mod, point_user_crea, point_user_mod, 
		point_edt_id, point_type_id, point_com_prof, point_etu_id, etu_photo, etu_mode
	FROM pointages,  etudiants  
	WHERE point_etu_id=etu_id AND point_visible=1
	ORDER BY point_date_crea DESC	
	;

 
$stmt = mysqli_prepare($bdd, "SELECT adresse FROM groupes_index WHERE groupe LIKE ?");

$stmt = mysqli_prepare($bdd, "SELECT adresse FROM groupes_index WHERE
groupe LIKE ?");

 
SL color = java.awt.Color[r=0,g=0,b=255]
FG color = java.awt.Color[r=255,g=255,b=255]
CD color = java.awt.Color[r=204,g=204,b=204]
RL color = java.awt.Color[r=0,g=0,b=255]
PN color = java.awt.Color[r=0,g=0,b=255] pour Accueil.ListeFilms
BG color = java.awt.Color[r=51,g=51,b=51]

 
PN color = java.awt.Color[r=0,g=0,b=255] pour Accueil.ListeFilms
RL color = java.awt.Color[r=0,g=0,b=255]

 
 
package patches;
 
/* 
 * Auteur: Gérard MARTINELLI
 */
 
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import cinephil.Common;
 
public class Patch26
{
		private static 	Connection 	cnx 		= 	null;
 
		public static void exécuter()
		{
			connect();
			try
			{
				Statement 	stmt1  	= cnx.createStatement();
				Statement 	stmt2  	= cnx.createStatement();
			 	String 		req   	= "Select * from  Parametres Order by clef";
 
			 	ResultSet 	rs 		= stmt1.executeQuery(req); 
 
				while (rs.next())
				{
					String clef 		=	rs.getString("Clef");
					String type 		=  	rs.getString("Type");
					String mode 		=  	rs.getString("Mode");
					String couleur 		= 	rs.getString("Couleur");
					String fichier 		= 	rs.getString("Nom_Fichier");
					String police		=	rs.getString("Nom_Police");
					String attributs 	=	rs.getString("Attributs"); 
					int    taille 		=   rs.getInt("Taille_Police");
 
					String requete  	= "INSERT INTO  Parametre2 SET ";
						   requete 		+=  " Clef			='" + clef + "', "   	;
						   requete 		+=  " Type			='" + type + "', "   	; 
						   requete 		+=  " Mode			='" + mode + "', "  	; 
						   requete 		+=  " Couleur		='" + couleur + "', "   ; 
						   requete 		+=  " Nom_Fichier	='" + fichier + "', "   ; 
						   requete 		+=  " Nom_Police 	='" + police + "', "   	; 
						   requete 		+=  " Attributs		='" + attributs  + "', "; 
						   requete 		+=  " Taille_Police	="  +  taille   ; 
 
					stmt2.executeUpdate(requete);					
				}
				rs.close();
				stmt1.close();
				stmt2.close();
				cnx.close();
			} 
			catch (SQLException e) 	{ e.printStackTrace();}
		}
 
		public static void connect()
		{
			if (Common.creationConnexion() < 0)	return;
			cnx = Common.cnx;
		}
 
		public static void main(String[] args)
		{
			  Patch26.exécuter();
			  System.out.println("Terminé");
		}
}