static void Main(string[] args) { Order order = new Order(); OrderService service = new OrderService(); OrderDetails a = new OrderDetails(1, "fish", "feng", 234, "18398581560"); OrderDetails b = new OrderDetails(2, "fish", "feng", 234, "18398581560"); //service.addOneOrder(ref order, a); //service.addOneOrder(ref order, b); //string username=""; //string password=""; String connetStr = "server=127.0.0.1;port=3306;user=root;password=anjiaxin123; database=base1;"; MySqlConnection conn = new MySqlConnection(connetStr); try { conn.Open();//打开通道,建立连接,可能出现异常,使用try catch语句 Console.WriteLine("已经建立连接"); //在这里使用代码对数据库进行增删查改 /* * foreach (OrderDetails s in order.orderList) * { * service.InseartToDatabase(conn, s); * }*/ service.DataSetToList(ref order, service.DataBaseToSet(conn)); service.deleteByNumber(ref order, 20181129002); service.deleteByNumberInDatabase(20181129002, conn); order.PrintOrder(); } catch (MySqlException ex) { Console.WriteLine(ex.Message); } finally { conn.Close(); } /* * * service.Export(order); * service.html(".../.../ksfdjkas.xsl", "sss.xml"); * //service.findOrderByNumber(order, 1).print(); * */ }