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();
*
*/
}
