显示用户信息:(show_user_info)

private void Page_Load(object sender, System.EventArgs e)

         {

              // 在此处放置用户代码以初始化页面

              if(!Page.IsPostBack)

              {

                   this.HyperLink1.NavigateUrl="modify_pwd.aspx?id="+Request.QueryString["id"];

                  SqlConnection  con=new SqlConnection();

                   con.ConnectionString=ConfigurationSettings.AppSettings["ConnectionString"];

                   SqlCommand cmd=new SqlCommand();

                   cmd.CommandText="select user_name,user_kind,user_sex,user_birthday,user_email from user_info where user_id= '"+Request.QueryString["id"]+"'";

                   cmd.Connection=con;

                   con.Open();

                   SqlDataReader reader=cmd.ExecuteReader();

                  if(reader.Read())

                   {

                       if(Convert.ToInt32(reader["user_sex"])==0)

                            sex="";

                       else

                            sex="";

 

 

 

                   lblbirthday.Text=Convert.ToDateTime(reader["user_birthday"]).ToString("D");

                   lblusername.Text=Convert.ToString(reader["user_name"]);

                   lbluserkind.Text=Convert.ToString(reader["user_kind"]);

                  

                   lbluseremail.Text=Convert.ToString(reader["user_email"]);

                   lblsex.Text=Convert.ToString(sex);

                   }

                   Page.DataBind();

                   reader.Close();

                   con.Close();

              }

         }

 
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
好的,首先我们来创建数据库和表。 1. 打开 Navicat,选择连接数据库的服务器。 2. 在菜单栏中选择“数据库” -> “新建数据库”,输入数据库名,例如“market_0314”,选择字符集为“utf8mb4”,点击“确定”。 3. 在“market_0314”数据库中右键选择“新建表”,创建用户表“users_0314”。 4. 在“users_0314”表中新建字段“id_0314”(类型为int,长度为11,主键、自增)、“name_0314”(类型为varchar,长度为20)、“pwd_0314”(类型为varchar,长度为20)。 5. 创建产品表“products_0314”,在其中新建字段“id_0314”(类型为int,长度为11,主键、自增)、“num_0314”(类型为varchar,长度为10)、“name_0314”(类型为varchar,长度为20)、“price_0314”(类型为float,长度为10,小数位为2)、“discount_0314”(类型为float,长度为10,小数位为2)。 6. 创建订单表“orders_0314”,在其中新建字段“id_0314”(类型为int,长度为11,主键、自增)、“num_0314”(类型为varchar,长度为10)、“count_0314”(类型为int,长度为11)、“amount_0314”(类型为float,长度为10,小数位为2)。 接下来,我们开始编写代码来实现超市日常管理中的业务。 ```python import mysql.connector # 登录功能 def login_0314(): username_0314 = input("请输入用户名:") password_0314 = input("请输入密码:") conn = mysql.connector.connect(user='root', password='123456', database='market_0314') cursor = conn.cursor() sql = "SELECT * FROM users_0314 WHERE name_0314=%s AND pwd_0314=%s" cursor.execute(sql, (username_0314, password_0314)) result = cursor.fetchall() if len(result) == 1: print("登录成功!") else: print("用户名或密码错误!") cursor.close() conn.close() # 查看所有产品信息功能 def show_all_products_0314(): conn = mysql.connector.connect(user='root', password='123456', database='market_0314') cursor = conn.cursor() sql = "SELECT * FROM products_0314" cursor.execute(sql) result = cursor.fetchall() for r in result: print(r) cursor.close() conn.close() # 查找商品功能 def search_product_0314(): product_name_0314 = input("请输入商品名称:") conn = mysql.connector.connect(user='root', password='123456', database='market_0314') cursor = conn.cursor() sql = "SELECT price_0314, discount_0314 FROM products_0314 WHERE name_0314=%s" cursor.execute(sql, (product_name_0314,)) result = cursor.fetchone() if result is not None: print("价格:", result[0], "折扣:", result[1]) else: print("该商品不存在!") cursor.close() conn.close() # 添加商品功能 def add_product_0314(): product_name_0314 = input("请输入商品名称:") product_price_0314 = float(input("请输入商品单价:")) product_discount_0314 = float(input("请输入商品折扣(0.1-0.99之间):")) conn = mysql.connector.connect(user='root', password='123456', database='market_0314') cursor = conn.cursor() sql = "INSERT INTO products_0314 (num_0314, name_0314, price_0314, discount_0314) VALUES (%s, %s, %s, %s)" cursor.execute(sql, (generate_num_0314(), product_name_0314, product_price_0314, product_discount_0314)) conn.commit() print("商品添加成功!") cursor.close() conn.close() # 生成商品编号 def generate_num_0314(): conn = mysql.connector.connect(user='root', password='123456', database='market_0314') cursor = conn.cursor() sql = "SELECT MAX(num_0314) FROM products_0314" cursor.execute(sql) result = cursor.fetchone()[0] cursor.close() conn.close() if result is None: return "0001" else: return str(int(result) + 1).zfill(4) # 修改商品价格和折扣功能 def modify_product_0314(): product_num_0314 = input("请输入商品编号:") product_price_0314 = float(input("请输入新的商品单价:")) product_discount_0314 = float(input("请输入新的商品折扣(0.1-0.99之间):")) conn = mysql.connector.connect(user='root', password='123456', database='market_0314') cursor = conn.cursor() sql = "UPDATE products_0314 SET price_0314=%s, discount_0314=%s WHERE num_0314=%s" cursor.execute(sql, (product_price_0314, product_discount_0314, product_num_0314)) conn.commit() print("商品修改成功!") cursor.close() conn.close() # 删除商品功能 def delete_product_0314(): product_num_0314 = input("请输入商品编号:") conn = mysql.connector.connect(user='root', password='123456', database='market_0314') cursor = conn.cursor() sql = "DELETE FROM products_0314 WHERE num_0314=%s" cursor.execute(sql, (product_num_0314,)) conn.commit() print("商品删除成功!") cursor.close() conn.close() # 查看所有订单功能 def show_all_orders_0314(): conn = mysql.connector.connect(user='root', password='123456', database='market_0314') cursor = conn.cursor() sql = "SELECT * FROM orders_0314" cursor.execute(sql) result = cursor.fetchall() for r in result: print(r) cursor.close() conn.close() # 订单统计功能 def order_statistics_0314(): conn = mysql.connector.connect(user='root', password='123456', database='market_0314') cursor = conn.cursor() sql = "SELECT SUM(count_0314), SUM(amount_0314) FROM orders_0314" cursor.execute(sql) result = cursor.fetchone() print("总销售额:", result[1], "货品数量:", result[0]) cursor.close() conn.close() # 商品结算功能 def product_settlement_0314(): product_num_0314 = input("请输入商品编号:") product_count_0314 = int(input("请输入商品数量:")) conn = mysql.connector.connect(user='root', password='123456', database='market_0314') cursor = conn.cursor() # 查询商品单价和折扣 sql = "SELECT price_0314, discount_0314 FROM products_0314 WHERE num_0314=%s" cursor.execute(sql, (product_num_0314,)) result = cursor.fetchone() if result is not None: product_price_0314 = result[0] product_discount_0314 = result[1] # 计算商品金额 product_amount_0314 = product_price_0314 * product_discount_0314 * product_count_0314 # 添加订单 sql = "INSERT INTO orders_0314 (num_0314, count_0314, amount_0314) VALUES (%s, %s, %s)" cursor.execute(sql, (product_num_0314, product_count_0314, product_amount_0314)) conn.commit() print("商品结算成功!") else: print("该商品不存在!") cursor.close() conn.close() # 主函数 def main_0314(): while True: print("0.用户登录 1.查看所有产品信息 2.查找商品 3.添加商品 4.修改商品价格和折扣 5.删除商品 6.查看所有订单 7.订单统计 8.商品结算") choice_0314 = input("请输入要执行的操作:") if choice_0314 == "0": login_0314() elif choice_0314 == "1": show_all_products_0314() elif choice_0314 == "2": search_product_0314() elif choice_0314 == "3": add_product_0314() elif choice_0314 == "4": modify_product_0314() elif choice_0314 == "5": delete_product_0314() elif choice_0314 == "6": show_all_orders_0314() elif choice_0314 == "7": order_statistics_0314() elif choice_0314 == "8": product_settlement_0314() else: print("输入有误,请重新输入!") if __name__ == '__main__': main_0314() ``` 在代码中,我们使用了 MySQL 的 Python 客户端库 mysql-connector-python 来连接数据库,并通过 SQL 语句来实现各项业务。同时,我们也使用了 Navicat 来创建数据库和表。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值