练习题(查,删,排,改)

<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
        <script type="text/javascript" src="../Anglert/angular.min.js" ></script>
        <script>
            var app=angular.module("Myapp",[]);


        var goods=[{"id":165,"name":"dfddf","price":5414,"done":false},
                {"id":455,"name":"fddh","price":2123,"done":false},
                {"id":184,"name":"ghgh","price":7415,"done":false},
                {"id":191,"name":"cvcd","price":9999,"done":false}];

            app.controller("Myctrl",function($scope){

                 $scope.gds=goods;


                //批量删除
                $scope.delall=function(){
                    var goodNames=[];

                    for(index in $scope.gds){

                        if($scope.gds[index].done==true){
                            goodNames.push($scope.gds[index].name);
                        }
                    }

                    if(goodNames.length>0)
                    {

                        if(confirm("是否删除选中项")){

                            for(i in goodNames)
                            {
                                var names=goodNames[i];

                                for(i2 in $scope.gds)
                                {

                                    if($scope.gds[i2].name==names)
                                    {

                                    $scope.gds.splice(i2,1);   

                                    }

                                }


                            }


                        }


                    }else{
                        alert("请删除选项");

                    }




                }




                //单独删除
                $scope.delone=function(names){


                    if(confirm("确定删除吗")){

                     for(index in $scope.gds)
                     {

                         if(names==$scope.gds[index].name){

                            $scope.gds.splice(index,1);

                         }

                     }



                    }

                }




                $scope.fuhao="";
                $scope.shuxing="";
                $scope.zfpai=function(sx){
                    $scope.shuxing=sx;
                    if($scope.fuhao=="")
                    {

                        $scope.fuhao="-";

                    }else{

                        $scope.fuhao="";

                    }
                }



                //全选
                $scope.checkall=function(){

                    if($scope.cheall==true){

                        for(var  i=0;i<$scope.gds.length;i++){
                            $scope.gds[i].done=true;
                        }
                    }else{
                        for(var  i=0;i<$scope.gds.length;i++){

                            $scope.gds[i].done=false;
                             }
                    }



                }


                //修改
                $scope.xiugai = function(price) {
                    //获得价格
                    for(index in $scope.gds) {

                        if(price == $scope.gds[index].price) {
                            var  tan=window.prompt("清输入要修改的价格", price)


                          if(!tan=="NaN" ||!tan==""){
                            var result = parseInt(tan);
                            //在这之前对result的结果进行非字符串判断
                            if(result < 0) {
                                alert("输入有误,请重新更改");
                            } else {


                                if(window.confirm("确定要将" + $scope.gds[index].name + "的价格更改为:" + result + "吗?")) {
                                    $scope.gds[index].price = result;
                                }




                            }

                     }

                        } 
                    }
                }













                //下拉菜单筛选
                $scope.xuzhe="-请选择-";
                $scope.fun=function(priced){


                    if($scope.xuzhe=="-请选择-"){

                        return true;

                    }else{

                        var arr=$scope.xuzhe.split("-");
                        var pricemin=arr[0];
                        var pricemax=arr[1];

                        //alert(pricemin);
                        //alert(pricemax);
                        if(priced>pricemax||priced<pricemin){

                            return false;

                        }else{

                            return true;
                        }

                        }
                     }



                //定义下拉菜单排序规则
                $scope.selOrder;
                $scope.orderSel=function(){
                    if($scope.selOrder == "id") {
                        $scope.fuhao = "";
                        $scope.shuxing = "id";
                    } else if($scope.selOrder == "-id") {
                        $scope.fuhao = "-";
                        $scope.shuxing = "id";
                    } else if($scope.selOrder == "price") {
                        $scope.fuhao = "";
                        $scope.shuxing = "price";
                    } else if($scope.selOrder == "-price") {
                        $scope.fuhao = "-";
                        $scope.shuxing = "price";
                    };



            }



                //反选
                $scope.checkselectall=function(){

                    var  flag=false;
                    for(index in $scope.gds)
                    {


                        if(!$scope.gds[index].done){

                            flag=true;

                        }



                    }



                    if(flag)
                    {

                    $scope.cheall=false;


                   }else{


                        $scope.cheall=true;

                   }








                }






            });





        </script>
    </head>
    <body ng-app="Myapp" ng-controller="Myctrl">
        <center>
            <input type="text" placeholder="请输入关键字" ng-model="gjz" />
            <select ng-model="xuzhe" >
                <option>-请选择-</option>
                <option>1000-2000</option>
                <option>2000-4000</option>
                <option>4000-6000</option>
                <option>7000-10000</option>
                <option>10000-12000</option>
            </select>
            正反排序<select ng-model="selOrder" ng-change="orderSel()">
                <option value="">排序方式</option>
                <option value="id">id正序</option>
                <option value="-id">id逆序</option>
                <option value="price">价格正序</option>
                <option value="-price">价格逆序</option>

            </select>
            <button ng-click="delall()">批量删除</button>

            <br /><br />




            <table border="1px solid blue"   cellpadding="10px" cellspacing="0px">
                <thead>
                    <tr>
                        <td><input type="checkbox" ng-click="checkall()" ng-model="cheall"/></td>
                        <td ng-click="zfpai('id')">编号</td>
                        <td ng-click="zfpai('name')">名称</td>
                        <td ng-click="zfpai('price')">价格</td>
                        <td>操作</td>
                    </tr>




                </thead>



                <tbody>
                <tr ng-repeat="good in gds|filter:{'name':gjz}|orderBy:(fuhao+shuxing)"  ng-if="fun(good.price)" >
                    <td><input type="checkbox" ng-model="good.done" ng-click="checkselectall()"/></td>
                    <td>{{good.id}}</td>
                    <td>{{good.name}}</td>
                    <td>{{good.price}}</td>
                    <td><button ng-click="delone(good.name)">删除</button><button ng-click="xiugai(good.price)">修改</button></td>

                </tr>
                </tbody>



            </table>



        </center>
        </body>
</html>

这里写图片描述

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
在MySQL中进行增操作的练习题如下: 1. 创建一个名为"oldboy"的数据库,并在该数据库中创建三个表:student、kcb和score。 2. 新建一个名为"wp"的用户,并使用该用户登录MySQL。 3. 看名为"agui"的学生的所有科目分数和教学老师。 4. 看名为"agui"的学生的所有科目分数和教学老师,并只显示该学生的名字。 5. 看分数低于60分的学生的名字、科目和教学老师。 6. 看名为"agui"的学生低于60分的科目和教学老师,并将分数为70分。 7. 看所有分数低于50分的学生的名字、科目和教学老师,并将分数置为零。 8. 看所有分数为0的学生的名字和科目,并将分数为60分。 9. 将名为"agui"的学生的语文分数为59分,并将教学老师为"cuimeng"。 另外,如果要在MySQL中授权用户权限,可以使用以下命令: - 授权用户对指定库的增权限:grant select, insert, update, delete on <database_name>.* to <user_name>@'%'; - 授权用户在整个MySQL服务器上具有全部权限:grant all on *.* to <user_name>@'%'; 请注意,上述练习题和授权命令只是示例,并不代表完整的练习题或授权方式,具体操作还需根据实际需求来确定。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* *2* *3* [MySQL-day6-条件语句与增练习题](https://blog.csdn.net/qq_23995091/article/details/114271955)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 100%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值