1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
import _mssql
Continue = 1
Server = 'NOMDUSERVEUR\SQLEXPRESS'
Login = 'dogua'
Password = 'passwordcomplique'
DBsql = 'NomDB'
while (Continue == 1):
#
# Je vous passe le menu :p
#
os.system('cls')
print("==== pyXXX v1.0 ====")
print("Encodage d'une convention")
saisie = input("Veuillez entrez le numero d'une nouvelle convention")
try:
conn = _mssql.connect(server=Server, user=Login, password=Password, database=DBsql)
Sql_cmd = "INSERT INTO convention VALUES(%d)" % (saisie)
conn.execute_non_query(Sql_cmd)
except _mssql.MssqlDatabaseException,e:
if e.number == 2627 and e.severity == 14:
print ("ERREUR : La convention existe déjà")
os.system('pause')
else:
print "Erreur : %d \n Severity : %d" % (e.number, e.severity)
os.system('pause')
finally:
conn.close() |
Partager