SHARE
TWEET

Untitled

a guest May 7th, 2016 118 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. db=jdbc:postgresql://studentittools.ipl.be:5432/dbmickael_marlard?user=mickael_marlard&password=aca452
  2. DalServices=dal.dalimpl.DalServicesImpl
  3. BizFactory=biz.factory.BizFactoryImpl
  4. PropertiesHandler=util.PropertiesHandler
  5. DalBackendServices=dal.dalimpl.DalServicesImpl
  6.  
  7.  
  8. ############
  9. #User#######
  10. ############
  11.  
  12. UserUcc=biz.uccimpl.UserUccImpl
  13. UserDao=dal.daoimpl.UserDaoImpl
  14.  
  15. ############
  16. #Mobility#######
  17. ############
  18.  
  19. MobilityDao=dal.daoimpl.MobilityDaoImpl
  20. MobilityUcc=biz.uccimpl.MobilityUccImpl
  21.  
  22. ############
  23. #Country#######
  24. ############
  25.  
  26. CountryDao=dal.daoimpl.CountryDaoImpl
  27. CountryUcc=biz.uccimpl.CountryUccImpl
  28.  
  29. ############
  30. #student#######
  31. ###########
  32.  
  33. StudentDao=dal.daoimpl.StudentDaoImpl
  34. StudentUcc=biz.uccimpl.StudentUccImpl
  35.  
  36. ############
  37. #csv#######
  38. ###########
  39.  
  40. CsvDao=dal.daoimpl.CsvDaoImpl
  41. CsvUcc=biz.uccimpl.CsvUccImpl
  42.  
  43. ############
  44. #payment#######
  45. ###########
  46.  
  47. PaymentDao=dal.daoimpl.PaymentDaoImpl
  48. PaymentUcc=biz.uccimpl.PaymentUccImpl
  49.  
  50.  
  51. ############
  52. #partner#######
  53. ###########
  54.  
  55. PartnerDao=dal.daoimpl.PartnerDaoImpl
  56. PartnerUcc=biz.uccimpl.PartnerUccImpl
  57.  
  58.  
  59. ################
  60. ###Query########
  61. ################
  62.  
  63. #QueryUser
  64. query.findUser=SELECT * FROM izymobi.utilisateurs WHERE pseudo=(?)
  65. query.insertUser= INSERT INTO izymobi.utilisateurs (pseudo, mot_de_passe, sel, email, nom, prenom, date_inscription, professeur) VALUES (?,?,?,?,?,?,?,?)
  66. query.updateToTeacher = UPDATE izymobi.utilisateurs SET professeur = (?), version = (?) WHERE id_utilisateur = (?) AND version =
  67. query.getStudentForMobility = SELECT * FROM izymobi.utilisateurs WHERE id_utilisateur IN (SELECT id_etudiant FROM izymobi.mobilites WHERE id_mobilite = (?) )
  68. query.getUsersInfos=SELECT * FROM izymobi.utilisateurs WHERE id_utilisateur = (?)
  69. query.searchUserWithFirstName= SELECT * FROM izymobi.utilisateurs WHERE prenom LIKE '% (?) %'
  70. query.searchUserWithLastName=SELECT * FROM izymobi.utilisateurs WHERE nom LIKE '% (?) %'
  71. query.searchUser=SELECT u.* FROM izymobi.utilisateurs AS u, izymobi.etudiants AS e WHERE LOWER(u.nom) LIKE LOWER((?)) AND LOWER(u.prenom) LIKE LOWER((?)) AND u.id_utilisateur = e.id_utilisateur
  72.  
  73. #QueryCountries
  74. query.selectAllCountries=SELECT * FROM izymobi.pays
  75. query.getMatchingCountry=SELECT * FROM izymobi.pays WHERE nom LIKE '% (?) %'
  76.  
  77. #QueryMobility
  78. query.CreateMobility= INSERT INTO izymobi.mobilites (id_etudiant, id_partenaire, type_programme, anneeAcademique, quadrimestre, priorite, date_introduction, etat_mobilite, etat_demande_payement, contrat_bourse, convention, charte_etudiant, test_langue_aller, test_langue_retour, engagement, attestation_sejour, releve_notes_certificat, rapport_final, annulation, commentaire_annulation, version) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
  79. query.UpdateCancellation= UPDATE izymobi.mobilites SET annulation = (?),commentaire_annulation=(?), version=(?) WHERE id_mobilite = (?) AND version = (?)
  80. query.UpdateMobilityState= UPDATE izymobi.mobilites SET etat_mobilite = (?), version=(?) WHERE id_mobilite = (?) AND version = (?)
  81. query.UpdateScholarshipContractSignature=UPDATE izymobi.mobilites SET contrat_bourse = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
  82. query.UpdateStageConventionSignature=UPDATE izymobi.mobilites SET convention = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
  83. query.UpdateStudentConventionSignature=UPDATE izymobi.mobilites SET charte_etudiant = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
  84. query.UpdateLinguisticTestToGo=UPDATE izymobi.mobilites SET test_langue_aller = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
  85. query.UpdateEngagementDocumentSignature=UPDATE izymobi.mobilites SET engagement = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
  86. query.UpdatePaymentRequestState=UPDATE izymobi.mobilites SET etat_demande_payment = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
  87. query.UpdateSojournCertificate=UPDATE izymobi.mobilites SET attestation_sejour = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
  88. query.UpdateStudentNotes=UPDATE izymobi.mobilites SET releve_notes_certificat = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
  89. query.UpdateFinalReport=UPDATE izymobi.mobilites SET rapport_final = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
  90. query.UpdateLinguisticTestsProof=UPDATE izymobi.mobilites SET test_langue_retour = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
  91. query.findMobilityWithAcademicYear=SELECT * FROM izymobi.mobilites WHERE anneeAcademique LIKE '% (?) %'
  92. query.findMobilityWithMobilityState=SELECT * FROM izymobi.mobilites WHERE etat_mobilite LIKE '% (?) %'
  93. query.selectStudentMobilities=SELECT * FROM izymobi.mobilites WHERE id_etudiant = (?)
  94. query.findMobilityWithId=SELECT * FROM izymobi.mobilites WHERE id_mobilite =(?)
  95. query.getMobilitiesByYear=SELECT * FROM izymobi.mobilites WHERE anneeAcademique =(?)
  96. query.getMobilitiesByYearDepartment=SELECT * FROM izymobi.mobilites WHERE anneeAcademique = (?) AND id_partenaire IN (SELECT id_partenaire FROM izymobi.partenaires WHERE departement LIKE '% (?) %')
  97. query.selectAllCancellationComments=SELECT * FROM izymobi.mobilites
  98. query.searchMobility=SELECT * FROM izymobi.mobilities WHERE anneeAcademique = (?) AND etat_mobilite LIKE ' (?) '
  99.  
  100.  
  101. #QueryPartenaire
  102. query.insertPartenaire=INSERT INTO izymobi.partenaires (nom_legal, nom_affaires, nom_complet, type_organisation, nb_employes, adresse, code_postal, ville, region, pays, email, telephone, site_web, departement, version, visibilite) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
  103. query.searchPartnerWithName=SELECT * FROM izymobi.partenaires WHERE nom_complet LIKE '% (?) %' AND department = "UNI"
  104. query.findAllUniPartner = SELECT * FROM izymobi.partenaires WHERE type_organisation LIKE ' (?) '
  105. query.findAllPartners = SELECT * FROM izymobi.partenaires
  106. query.updatePartner=UPDATE izymobi.partenaires SET nom_legal =(?), nom_affaires=(?), nom_complet=(?), type_organisation=(?), nb_employes=(?), adresse=(?), code_postal=(?), ville=(?), region=(?), pays=(?), email=(?), telephone=(?), site_web=(?), departement=(?), version=(?), visibilite=(?) WHERE id_partenaire=(?) AND version =(?)
  107. query.findPartnerWithCountry = SELECT * FROM izymobi.partenaires WHERE id_partenaire = (?)
  108. query.getPartner = SELECT * FROM izymobi.partenaires WHERE id_partenaire = (SELECT id_partenaire FROM izymobi.mobilites WHERE id_mobilite =(?))
  109. query.getMobilityPartner = SELECT id_partenaire FROM izymobi.mobilites WHERE id_mobilite = (?)
  110. query.searchPartnerWithCountry=SELECT * FROM izymobi.partenaires WHERE pays LIKE '% (?) %' AND department = "UNI"
  111. query.searchPartnerWithTown=SELECT * FROM izymobi.partenaires WHERE ville LIKE '% (?) %' AND department = "UNI"
  112. query.searchPartner=SELECT * FROM izymobi.partenaires WHERE pays LOWER(nom_complet) LIKE LOWER((?)) AND pays LIKE LOWER((?)) AND ville LIKE LOWER((?)) AND department = "UNI"
  113. query.deletePartner=UPDATE izymobi.partenaires SET visibilite = false, version = (?) WHERE id_partenaire = (?) AND version = (?)
  114. query.getAllVisiblePartners = SELECT * FROM izymobi.partenaires WHERE visibilite = true
  115.  
  116.  
  117. #QueryStudent
  118. query.findStudent=SELECT * FROM izymobi.etudiants WHERE id_utilisateur = (?)
  119. query.insertStudent=INSERT INTO izymobi.etudiants (departement, date_naissance, sexe, nationalite, adresse, telephone, annees_reussies, compte_bancaire, proeco, mobi_mobility_tool, version, id_utilisateur) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)
  120. query.updateStudent=UPDATE izymobi.etudiants SET departement=(?), date_naissance=(?), sexe=(?), nationalite=(?), adresse=(?), telephone=(?), annees_reussies=(?), compte_bancaire=(?), proeco=(?), mobi_mobility_tool=(?), version=(?) WHERE id_utilisateur=(?) AND version=(?)
  121. query.getAllStudents= SELECT * FROM izymobi.etudiants
  122. query.updateBankAccount=UPDATE izymobi.comptes_bancaires SET titulaire =(?), bic=(?), banque=(?), version=(?) WHERE compte_bancaire=(?) AND version=(?)
  123. query.insertBankAccount=INSERT INTO izymobi.comptes_bancaires (titulaire, bic, banque, version) VALUES(?,?,?,?)
  124. query.findBankAccount=SELECT * FROM izymobi_comptes_bancaires WHERE compte_bancaire =(?)
  125.  
  126. #QueryPayment
  127. query.getAllPaymentsFromMobilityId= SELECT * FROM izymobi.paiements WHERE id_mobilite =(?)
  128. query.CreatePayment=INSERT INTO izymobi.paiements (id_mobilite, pourcentage_paye, date_paiement, version) VALUES (?,?,?,?)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top