Db.cs 801 B

1234567891011121314151617181920212223242526272829
  1. using MySql.Data.MySqlClient;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Linq;
  5. using System.Text;
  6. using System.Threading.Tasks;
  7. namespace distant
  8. {
  9. internal class Db
  10. {
  11. MySqlConnection connection = new MySqlConnection("server=localhost;port=3306;username=root;password=;database=video");
  12. public void openConnection()
  13. {
  14. if (connection.State == System.Data.ConnectionState.Closed)
  15. {
  16. connection.Open();}
  17. }
  18. public void closeConnection()
  19. {
  20. if (connection.State == System.Data.ConnectionState.Open)
  21. {
  22. connection.Close();
  23. }
  24. }
  25. public MySqlConnection GetConnection() { return connection; }
  26. }
  27. }