JavaAPI--lang包相关练习题

本文聚焦于SQL语句的动态构造与字符串处理技巧,通过具体案例演示如何使用Java的StringBuffer类来拼接复杂的SQL语句,同时涉及字符串数组的筛选与过滤,适用于初学者及需要提升SQL构造技能的开发者。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

第一题
第二题

 

第三题,第四题,第五题

 

第六题(五星题)

 

开发实践题

1.要得到字符串 "select * from member where memberId = 10086"

已知条件:

String sql = "select * from member where 1=1";

StringBuffer sb = new StringBuffer(sql);

String ids[] = {"where ","memberId ","10086"};

后面怎么写?利用append实现。

2.要得到字符串 "delete from member where 1=1 and id = 1 and id =2 and id=3"

已知条件

String sql = "delete from member where 1 = 1";

StringBuffer sb = new StringBuffer(sql);

String ids[] = {"1","2","3"};

怎么写?利用append实现。

3.输出名字中有“艳”的名字

String names[] = {"张小艳"","大熊熊","花儿朵朵","花无期","小不点","妖艳货色","艳阳天"};

4.输出后缀名是.jpg的

String images[] ={"小猫猫.png","小花花.jpg","小不点.png","小乖乖.bmp","鼠标.jpg","键盘.jpg","白月光.mp3"};.

5.输出刘姓员工

String  employees[] = {"张新成","肖战","刘青云","刘易斯","张学友","易烊千玺","王源","胡歌","刘少云","迪丽热巴","刘德华"};

6.输出名字含四个字的

String  employees[] = {"张新成","肖战","刘青云","刘易斯","张学友","易烊千玺","王源","胡歌","刘少云","迪丽热巴","刘德华"};

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

汤永红

一分也是爱

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值