20211030 1+X 中级JAVA

最新推荐文章于 2024-03-25 06:27:25 发布

阿陈在努力

最新推荐文章于 2024-03-25 06:27:25 发布

阅读量339

点赞数 1

分类专栏： 1+X 文章标签： java mysql big data 大数据

本文链接：https://blog.csdn.net/m0_56364182/article/details/124878928

版权

1+X 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

本文介绍了Java编程中成员变量的初始化、商品库存限制、日期转换、SQL查询及更新操作。涉及方法包括：限制商品数量不超过100的设置、日期字符串与日期对象之间的转换、查询最高价格商品、计算商品总价、更新密码、根据分数更新排名、统计订单数量以及获取最大消费金额的客户。这些内容涵盖了基本的Java语法和数据库操作。

摘要由CSDN通过智能技术生成

步骤一

安装要求复制粘贴即可

步骤二

public Member(){}
 
	public Member(String name,String pwd,float score,int rank){
		this.name = name;
		this.pwd = pwd;
		this.score = score;
		this.rank = rank;
	}

步骤三

//请修改该方法，并且在赋值时，商品数量不能超过100
	public void setNum(int num) {
		if(num<100){
			this.num = num;
		}
	}

步骤四

public static Date convertFromStringToDate(String stringDate) {
		// 补全代码：
		Date date = null;
		try{
			date = sdf.parse(stringDate);
		}catch (Exception e){
			e.printStackTrace();
		}
		return date;
	}

步骤五

public static String convertFromDateToString(Date date) {
		// 补全或替换代码
		
		return sdf.format(date);
	}

步骤六

	public String queryExpensiveGoods() {
                // 请补全sql语句
                String sql = "select * from goods where price=(select max(price) from goods)";
                Goods g = goodsUtil.getOne(sql, Goods.class);
                return g.getName();
        }

步骤七

public double querySum() {
                String sql = "select * from goods";
                double sum = 0;
                List<Goods> list = goodsUtil.getList(sql, Goods.class);
                for (Goods goods : list) {
                        // 请补全代码
                sum = sum + goods.getPrice()*goods.getNum(); 
                }
                return sum;
        }

步骤八

public void updatePwd(){
                // 请补全sql语句
                String sql = "update member set pwd=reverse(pwd)";
                memberUtil.update(sql); 
        }

步骤九

public void updateRank() {
                // 请补全sql语句
                String sql = "update member set `rank` = "+
                "case when 0<=score and score<100 then 0 "+
                "when 100<=score and score<200 then 1 "+
                "when 200<=score and score<300 then 2 "+
                "when 300<=score and score<400 then 3 "+
                "when 400<=score and score<500 then 4 "+
                "when 500<=score then 5 "+
                "end";
                memberUtil.update(sql); 
        }

步骤十

public int queryNum() {
                String sql = "select * from `order`;";
                List<Order> o = orderUtil.getList(sql, Order.class); 
                Set<Integer> s = new HashSet<Integer>();
                for (Order order : o) {
                        // 请补全语句
                        s.add(order.getId());
                }
                return s.size();
        }

步骤十一

public String queryMax() {
                // 请补全sql语句
                String sql = "select mname,sum(num*price) from `order` group by mname order by sum(num*price) desc limit 1";
                Order o = orderUtil.getOne(sql, Order.class); 
                return o.getMname();
        }