78 lines
2.1 KiB
C#
78 lines
2.1 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Linq;
|
||
using System.Text;
|
||
using System.Threading.Tasks;
|
||
using MySql.Data.MySqlClient;
|
||
using MySql.Data;
|
||
using System.ComponentModel;
|
||
using MySqlX.XDevAPI;
|
||
using System.Security.Cryptography.X509Certificates;
|
||
|
||
namespace Федосеев_проект
|
||
{
|
||
internal class Cl_Федосеев
|
||
{
|
||
}
|
||
class CL_Федосеев
|
||
{
|
||
private static CL_Федосеев instance = null;
|
||
|
||
MySqlConnection connection = new MySqlConnection("server=cfif31.ru; port=3306; username=ISPr25-22; " +
|
||
"password=ISPr25-22; database=ISPr25-22_MARK");
|
||
|
||
private CL_Федосеев() { }
|
||
|
||
public void openConnection()
|
||
{
|
||
if(connection.State == System.Data.ConnectionState.Closed)
|
||
connection.Open();
|
||
}
|
||
|
||
public void CloseConnection()
|
||
{
|
||
if (connection.State != System.Data.ConnectionState.Open)
|
||
connection.Close();
|
||
}
|
||
|
||
public static CL_Федосеев getInstance()
|
||
{
|
||
if (instance != null) return instance;
|
||
|
||
else
|
||
{
|
||
instance = new CL_Федосеев();
|
||
instance.openConnection();
|
||
return instance;
|
||
}
|
||
}
|
||
|
||
public int CreateCommand(string query)
|
||
{
|
||
MySqlCommand command = connection.CreateCommand();
|
||
command.CommandText = query;
|
||
|
||
try
|
||
{
|
||
int rows = command.ExecuteNonQuery();
|
||
return rows;
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
connection = new MySqlConnection("server=cfif31.ru; port=3306; username=ISPr25-22; " +
|
||
"password=ISPr25-22; database=ISPr25-22_MARK");
|
||
|
||
connection.Open();
|
||
command = connection.CreateCommand();
|
||
command.CommandText = query;
|
||
int rows = command.ExecuteNonQuery();
|
||
|
||
return rows;
|
||
}
|
||
}
|
||
public MySqlConnection GetConnection()
|
||
{
|
||
return connection;
|
||
}
|
||
}
|
||
} |