/**
         * Create a data provider.
         */
        public static Database createDataProvider()
        {
            //<option name="db_system" value="mysql"/>
            string dbsystem=Configuration.getValue("db_system", "mysql");

            switch(dbsystem.ToLower())
            {
                case "sqlite":
                    {
                        //SQLite provider=new SQLite();
                        //return provider;
                        return null;
                    }
                case "mysql":
                    {
                        string host=Configuration.getValue("mysql_hostname", "example.org");
                        int port=Convert.ToInt32(Configuration.getValue("mysql_port", "3306"));
                        string database=Configuration.getValue("mysql_database", "");
                        string username=Configuration.getValue("mysql_username", "");
                        string password=Configuration.getValue("mysql_password", "");

                        MySQL provider=new MySQL(host, port, database, username, password);
                        return provider;
                    }
                default:
                    {
                        throw new Exception();
                    }
            }
        }
Exemple #2
0
		static void Main(string[] args)
		{
			////MySQL
			{
				Console.WriteLine("MySQL");

				//Connect to MySQL Database
				string mySQLserver="seeseekey.net";
				int mySQLPort=3306;
				string mySQLusername="******";
				string mySQLpassword="******";
				string mySQLDbName="daten";

				MySQL mySQL=new MySQL(mySQLserver, mySQLPort, mySQLDbName, mySQLusername, mySQLpassword);
				mySQL.Connect();

				//get table names
				List<string> tables=mySQL.GetTables();

				foreach(string table in tables)
				{
					Console.WriteLine(table);
				}
			}

			////PostgreSQL
			{
				Console.WriteLine("PostgreSQL");

				//Connect to PostgreSQL Database
				string postgreSQLserver="seeseekey.net";
				int postgreSQLPort=5432;
				string postgreSQLusername="******";
				string postgreSQLpassword="******";
				string postgreSQLDbName="test";

				PostgreSQL postgresql=new PostgreSQL(postgreSQLserver, postgreSQLPort, postgreSQLDbName, postgreSQLusername, postgreSQLpassword);
				postgresql.Connect();

				//get table names
				List<string> tables=postgresql.GetTables();

				foreach(string table in tables)
				{
					Console.WriteLine(table);
				}
			}

			//SQLite
			{
				Console.WriteLine("SQLite");

				//Connect/Open to SQlite Database
				string sqliteDB=@"D:\test.db";
				SQLite sqlite=new SQLite(sqliteDB);

				//get table names
				List<string> tables=sqlite.GetTables();

				foreach(string table in tables)
				{
					Console.WriteLine(table);
				}
			}

			//Ende
			Console.ReadLine();
		}