예제 #1
0
 static void Main(string[] args)
 {
     string errmsg = "";
     string query;
     int choice;
     string nick, manuf, model;
     int year;
     string confirm;
     GuitarDBQuery dbq = new GuitarDBQuery("localhost", "Instruments", "root", "Flyers2013");
     //MySqlDatabase mysql = new MySqlDatabase("localhost", "Instruments", "root", "");
     Console.Write("Enter the name of the guitar table: ");
     string tableName = Console.ReadLine();
     List<string>[] results;
     if (dbq.OpenConnection(ref errmsg))
     {
         do
         {
             choice = showMenu();
             switch (choice)
             {
                 case 1:
                     Console.WriteLine("Enter NickName: ");
                     nick = Console.ReadLine();
                     Console.WriteLine("Enter manufacturer: ");
                     manuf = Console.ReadLine();
                     Console.WriteLine("Enter model: ");
                     model = Console.ReadLine();
                     Console.WriteLine("Enter year: ");
                     year = int.Parse(Console.ReadLine());
                     query = GuitarDBQuery.GetInsertQuery(tableName, nick, manuf, model, year);
                     if (dbq.InsertGuitar(tableName, nick, manuf, model, year, ref errmsg))
                     {
                         Console.WriteLine("Guitar was added.");
                     }
                     else
                     {
                         Console.WriteLine("Error: " + errmsg);
                     }
                     break;
                 case 2:
                     Console.Write("Enter name of guitar to delete: ");
                     nick = Console.ReadLine();
                     query = GuitarDBQuery.GetDeleteQuery(tableName, nick);
                     if (dbq.DeleteGuitar(tableName, nick, ref errmsg))
                     {
                         Console.WriteLine("Guitar was deleted.");
                     }
                     else
                     {
                         Console.WriteLine("error: " + errmsg);
                     }
                     break;
                 case 3:
                     Console.Write("Are you sure you want to remove all guitars? ");
                     confirm = Console.ReadLine().ToUpper();
                     if (confirm == "Y") {
                         query = GuitarDBQuery.GetDeleteAllQuery(tableName);
                         if (dbq.DeleteAllGuitars(tableName,ref errmsg)) {
                             Console.WriteLine("You are guitar-less.");
                         } else {
                             Console.WriteLine("Error: " + errmsg);
                         }
                     }
                     break;
                 case 4:
                     results = dbq.SelectGuitarsAsStrings("select * from " + tableName,ref errmsg));
                     if (results != null)
                     {
                         DBOutput.WriteTabulatedData(results);
                     }
                     else
                     {
                         Console.WriteLine("An error occurred " + errmsg);
                     }
                     break;
             }
         } while (choice != 5);
     }
     else
     {
         Console.WriteLine("Couldn't open database: " + errmsg);
     }
     Console.WriteLine("Have a nice day.");
     Console.ReadKey();
 }
예제 #2
0
        static void Main(string[] args)
        {
            string errmsg = "";
            string query;
            int    choice;
            string nick, manuf, model;
            int    year;
            string confirm;

            List <string>[] results;
            MySqlDatabase   mysql = new MySqlDatabase("localhost", "Instruments", "root", "Flyers2013");

            Console.WriteLine("Enter the name of the guitar table: ");
            string tableName = Console.ReadLine();

            if (mysql.OpenConnection(ref errmsg))
            {
                do
                {
                    choice = showMenu();
                    switch (choice)
                    {
                    case 1:
                        Console.WriteLine("Enter NickName: ");
                        nick = Console.ReadLine();
                        Console.WriteLine("Enter manufacturer: ");
                        manuf = Console.ReadLine();
                        Console.WriteLine("Enter model: ");
                        model = Console.ReadLine();
                        Console.WriteLine("Enter year: ");
                        year  = int.Parse(Console.ReadLine());
                        query = GuitarDBQuery.GetInsertQuery(tableName, nick, manuf, model, year);
                        if (mysql.Execute(query, ref errmsg))
                        {
                            Console.WriteLine("Guitar was added.");
                        }
                        else
                        {
                            Console.WriteLine("Error: " + errmsg);
                        }
                        break;

                    case 2:
                        Console.Write("Enter name of guitar to delete: ");
                        nick  = Console.ReadLine();
                        query = GuitarDBQuery.GetDeleteQuery(tableName, nick);
                        if (mysql.Execute(query, ref errmsg))
                        {
                            Console.WriteLine("Guitar was deleted.");
                        }
                        else
                        {
                            Console.WriteLine("error: " + errmsg);
                        }
                        break;

                    case 3:
                        Console.Write("Are you sure you want to delete all guitars? ");
                        confirm = Console.ReadLine().ToUpper();
                        if (confirm == "Y")
                        {
                            query = GuitarDBQuery.GetClearQuery(tableName);
                            if (mysql.Execute(query, ref errmsg))
                            {
                                Console.WriteLine("You are guitar-less");
                            }
                            else
                            {
                                Console.WriteLine("error: " + errmsg);
                            }
                        }
                        break;

                    case 4:
                        results = GuitarDBQuery.ParseResults(mysql.Select("select * from " + tableName + ";", ref errmsg));
                        break;
                    }
                } while (choice != 5);
            }
            else
            {
                Console.WriteLine("Couldn't open database: " + errmsg);
            }
        }