/// <summary> /// Constructeur du service (initialisation des composants et de la connexion) /// </summary> public ServiceGSB() { InitializeComponent(); connect = ConnexionSql.getInstance("10.30.0.113", "DUBOST", "DUBOST", "mdubost"); /* +---------+-------------+-----------------+ | | Lycée | Maison | +---------+-------------+-----------------+ | Adresse | 10.30.0.113 | slam.siolms.pro | +---------+-------------+-----------------+ */ }
/// <summary> /// Affichage du formulaire et initialisation de la connexion /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Form1_Load(object sender, EventArgs e) { connect = ConnexionSql.getInstance("10.30.0.113", "DUBOST", "DUBOST", "mdubost"); /* +---------+-------------+-----------------+ | | Lycée | Maison | +---------+-------------+-----------------+ | Adresse | 10.30.0.113 | slam.siolms.pro | +---------+-------------+-----------------+ */ afficher(); }
/// <summary> /// Méthode de création d'une instance de connexion si elle n'existe pas (Singleton) /// </summary> /// <param name="unProvider"></param> /// <param name="uneDataBase"></param> /// <param name="unUid"></param> /// <param name="unMdp"></param> /// <returns></returns> public static ConnexionSql getInstance(string unProvider, string uneDataBase, string unUid, string unMdp) { lock ((mylock)) { try { if (connection == null) { connection = new ConnexionSql(unProvider, uneDataBase, unUid, unMdp); } } catch (Exception emp) { MessageBox.Show(emp.Message); } return(connection); } }