<meta charset="utf-8">
<?php
//链接数据库
$link = mysqli_connect(''127.0.0.1'',''root'',''root'',''mone'');
//设置字符集
mysqli_query($link,''set names utf8'');


//接收当前页
$page = empty($_GET[''page''])?1:$_GET[''page''];
//求出总条数
$sql = "select * from user";
$res = mysqli_query($link,$sql);
$count = mysqli_num_rows($res);
//每页显示多少条
$length = 3;
//求出总页数
$num_page = ceil($count/$length);
//偏移量
$limit = ($page-1)*$length;
//查询
$sql2 = "select * from user limit $limit,$length";
$res2 = mysqli_query($link,$sql2);
while($a=mysqli_fetch_assoc($res2)){
    $data[''data''][] = $a;
}


$data[''home_page''] = 1;
$data[''prev_page''] = $page-1<1?1:$page-1;
$data[''next_page''] = $page+1>$num_page?$num_page:$page+1;
$data[''last_page''] = $num_page;

?>
<table>
    <tr>
        <th>选择</th>
        <th>ID</th>
        <th>用户名</th>
        <th>密码</th>
        <th>性别</th>
        <th>年龄</th>
        <th>班级</th>
        <th>手机</th>
        <th>编辑</th>
    </tr>
    <div id="main">
    <?php foreach($data[''data''] as $k=>$v){ ?>
    <tr id="<?php echo $v[''user_id''];?>">
        <td><input type="checkbox" name="check" value="<?php echo $v[''user_id''];?>"></td>
        <td><?php echo $v[''user_id''];?></td>
        <td><?php echo $v[''username''];?></td>
        <td><?php echo $v[''pwd''];?></td>
        <td><?php echo $v[''sex''];?></td>
        <td><?php echo $v[''age''];?></td>
        <td><?php echo $v[''class_name''];?></td>
        <td><?php echo $v[''phone''];?></td>
        <td>
            <a href="">修改</a>
        </td>
    </tr>
    <?php } ?>
</div>
</table>

<button onclick="fun1()">全选</button>
<button onclick="fun2()">全不选</button>
<button onclick="fun3()">反选</button>
<button onclick="fun4()">单删/批删</button>
<script>
    

    function fun1(){
        var check = document.getElementsByName(''check'');
        for(var i=0;i<check.length;i++){
            if(check[i].checked==false){
                check[i].checked=true;
            }
        }
    }

    function fun2(){
        var check = document.getElementsByName(''check'');
        for(var i=0;i<check.length;i++){
            if(check[i].checked==true){
                check[i].checked=false;
            }
        }
    }

    function fun3(){
        var check = document.getElementsByName(''check'');
        for(var i=0;i<check.length;i++){
            if(check[i].checked==true){
                check[i].checked=false;
            }else{
                check[i].checked=true;
            }
        }
    }

    function fun4(){
        var arr = document.getElementsByName(''check'');
        var ar = [];
        for(var i=0;i<arr.length;i++){
            if(arr[i].checked==true){
                ar.push(arr[i].value);
            }
        }

        var id = ar.toLocaleString();
        if(id==''''){
            alert(''请先选择一项'');
            return false;
        }else{
            //ajax请求
            var ajax = new XMLHttpRequest();
            ajax.open("get","delete.php?id="+id);
            ajax.send();
            ajax.onreadystatechange=function(){
                if(ajax.readyState==4 && ajax.status==200){
                    //alert(ajax.responseText);
                    //成功
                    if(ajax.responseText==1){

                        for(var i=0;i<ar.length;i++){
                            var tr=document.getElementById(ar[i]);
                            tr.remove();
                        }

                    }
                }
            }
        }
    }
</script>

<?php
//接收传值
$id = $_GET[''id''];
//链接数据库
$link = mysqli_connect(''127.0.0.1'',''root'',''root'',''mone'');
//设置字符集
mysqli_query($link,''set names utf8'');
//拼接sql
$sql = "DELETE FROM user WHERE user_id in ($id)";
if(mysqli_query($link,$sql)){
    echo 1;
}else{
    echo 2;
}

package com.bwie.day06;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.support.v7.widget.linearlayoutmanager;
import android.support.v7.widget.RecyclerView;
import android.view.View;

import com.bwie.day06.myadapter.MyAdapter;

public class MainActivity extends AppCompatActivity {

  private MyAdapter myAdapter;
  private linearlayoutmanager linearlayoutmanager;

  @Override
  protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    //初始化控件
    RecyclerView recyclerView = (RecyclerView) findViewById(R.id.recyclerview);
    //在加载数据之前配置
    linearlayoutmanager = new linearlayoutmanager(this);
    recyclerView.setLayoutManager(linearlayoutmanager);
    //创建一个适配器
    myAdapter = new MyAdapter();
    recyclerView.setAdapter(myAdapter);


  }

  public void btnAll(View view) {
    myAdapter.All();
  }

  public void btnner(View view) {
    myAdapter.neverall();
  }
}

package com.bwie.day06.myadapter;

import android.support.v7.widget.RecyclerView;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.CheckBox;
import android.widget.TextView;

import com.bwie.day06.R;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;
import java.util.Set;


public class MyAdapter extends RecyclerView.Adapter<MyAdapter.MyViewHolder> {
  //这个是checkBox的Hashmap集合
  private final HashMap<Integer,Boolean> map;
  //这个是数据集合
  private final ArrayList<String> list;

  public MyAdapter() {
    map = new HashMap<>();
    list = new ArrayList<>();
    for (int i = 0; i < 30; i++) {
      //添加30条数据
      list.add("这是条目" + i);
      map.put(i,false);
    }

  }

  /**
   * 全选
   */
  public void All() {
    Set<Map.Entry<Integer,Boolean>> entries = map.entrySet();
    boolean shouldall = false;
    for (Map.Entry<Integer,Boolean> entry : entries) {
      Boolean value = entry.getValue();
      if (!value) {
        shouldall = true;
        break;
      }
    }
    for (Map.Entry<Integer,Boolean> entry : entries) {
      entry.setValue(shouldall);
    }
    notifyDataSetChanged();
  }

  /**
   * 反选
   */
  public void neverall() {
    Set<Map.Entry<Integer,Boolean>> entries = map.entrySet();
    for (Map.Entry<Integer,Boolean> entry : entries) {
      entry.setValue(!entry.getValue());
    }
    notifyDataSetChanged();
  }

  /**
   * 单选
   *
   * @param postion
   */
  public void singlesel(int postion) {
    Set<Map.Entry<Integer,Boolean> entry : entries) {
      entry.setValue(false);
    }
    map.put(postion,true);
    notifyDataSetChanged();
  }

  //这里主要初始化布局控件
  @Override
  public MyViewHolder onCreateViewHolder(ViewGroup parent,int viewType) {
    RecyclerView.LayoutManager layoutManager = ((RecyclerView) parent).getLayoutManager();
    //初始化布局文件
    View inflate = LayoutInflater.from(parent.getContext()).inflate(R.layout.check,parent,false);
    return new MyViewHolder(inflate);
  }

  @Override
  public void onBindViewHolder(final MyViewHolder holder,final int position) {
    //放入集合中的值
    holder.txt.setText(list.get(position));
    holder.checkBox.setChecked(map.get(position));
    holder.checkBox.setonClickListener(new View.OnClickListener() {

      @Override
      public void onClick(View v) {
        map.put(position,!map.get(position));
        //刷新适配器
        notifyDataSetChanged();
        //单选
//        singlesel(position);

      }
    });

  }

  @Override
  public int getItemCount() {
    return list.size();
  }

  public class MyViewHolder extends RecyclerView.ViewHolder {
    View itemView;
    private TextView txt;
    private CheckBox checkBox;

    //初始化控件
    public MyViewHolder(View itemView) {
      super(itemView);
      this.itemView = itemView;
      txt = (TextView) itemView.findViewById(R.id.txt);
      checkBox = (CheckBox) itemView.findViewById(R.id.cBox);
    }
  }
}

<LinearLayout
  android:layout_width="match_parent"
  android:layout_height="wrap_content"
  android:orientation="horizontal">

  <Button
    android:onClick="btnAll"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_weight="1"
    android:text="全选" />

  <Button
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_weight="1"
    android:text="反选"
    android:onClick="btnner"/>

</LinearLayout>

<android.support.v7.widget.RecyclerView
  android:id="@+id/recyclerview"
  android:layout_width="match_parent"
  android:layout_height="match_parent"></android.support.v7.widget.RecyclerView>

<CheckBox
  android:id="@+id/cBox"
  android:layout_width="wrap_content"
  android:layout_height="wrap_content" />


<TextView
  android:text="dfdfdfdf"
  android:id="@+id/txt"
  android:layout_width="wrap_content"
  android:layout_height="wrap_content"
  android:textSize="20sp" />

using System; 
using System.Data; 
using System.Data.SqlClient; 
using System.Configuration; 
using System.Collections; 
using System.Web; 
using System.Web.Security; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.Web.UI.WebControls.WebParts; 
using System.Web.UI.HtmlControls; 

public partial class Demo18 : System.Web.UI.Page 
{ 
protected void Page_Load(object sender, EventArgs e) 
{ 
if (Page.IsPostBack == false) 
{ 
BindData(); 
} 
} 

public void BindData() 
{ 
string strSql = "select UserID,C_Name,E_Name,UpdataDate,isDY from Demo_User "; 
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.CONN_STRING, CommandType.Text, strSql, null).Tables[0]; 

GridView.DataSource = dt; 
GridView.DataKeyNames = new string[] { "UserID" };//主键 
GridView.DataBind(); 
} 

protected void GridView_PageIndexChanging(object sender, GridViewPageEventArgs e) 
{ 
GridView.PageIndex = e.NewPageIndex; 
BindData(); 
} 

protected void Button1_Click(object sender, EventArgs e) 
{ 
CheckBoxAll.Checked = false; 
CheckBox1.Checked = false; 
for (int i = 0; i <= GridView.Rows.Count - 1; i++) 
{ 
CheckBox CheckBox = (CheckBox)GridView.Rows[i].FindControl("CheckBox"); 
CheckBox.Checked = false; 
} 

} 

protected void Button2_Click(object sender, EventArgs e) 
{ 
for (int i = 0; i <= GridView.Rows.Count - 1; i++) 
{ 
CheckBox CheckBox = (CheckBox)GridView.Rows[i].FindControl("CheckBox"); 
if (CheckBox.Checked == true) 
{ 
string strSql = "Update Demo_User set UpdataDate=@UpdataDate where UserID=@UserID "; 
SqlParameter[] para = { 
new SqlParameter("@UpdataDate", DateTime.Now), 
new SqlParameter("@UserID", GridView.DataKeys[i].Value), 
}; 
SqlHelper.ExecuteNonQuery(SqlHelper.CONN_STRING, CommandType.Text, strSql, para); 
} 
} 
CheckBoxAll.Checked = false; 
CheckBox1.Checked = false; 
BindData(); 

} 

protected void CheckBoxAll_CheckedChanged(object sender, EventArgs e) 
{ 
for (int i = 0; i <= GridView.Rows.Count - 1; i++) 
{ 
CheckBox CheckBox = (CheckBox)GridView.Rows[i].FindControl("CheckBox"); 
if (CheckBoxAll.Checked == true) 
{ 
CheckBox.Checked = true; 
} 
else 
{ 
CheckBox.Checked = false; 
} 
} 
CheckBox1.Checked = false; 

} 

protected void CheckBox1_CheckedChanged(object sender, EventArgs e) 
{ 
for (int i = 0; i <= GridView.Rows.Count - 1; i++) 
{ 
CheckBox CheckBox = (CheckBox)GridView.Rows[i].FindControl("CheckBox"); 
if (CheckBox.Checked == false) 
{ 
CheckBox.Checked = true; 
} 
else 
{ 
CheckBox.Checked = false; 
} 
} 
CheckBoxAll.Checked = false; 
} 
} 

<table align="center" bgcolor="#c0de98" border="0" cellpadding="0" cellspacing="1" width="99%"> 
<tr> 
<th colspan="2"> 
GridView演示</th> 
</tr> 
<tr> 
<td colspan="2"> 
<asp:GridView ID="GridView" runat="server" Width="100%" AutoGenerateColumns="False" AllowPaging="True" OnPageIndexChanging="GridView_PageIndexChanging" PageSize="12" > 
<Columns> 
<asp:TemplateField HeaderText="选择"> 
<ItemTemplate> 
<asp:CheckBox ID="CheckBox" runat="server" /> 
</ItemTemplate> 
</asp:TemplateField> 
<asp:BoundField DataField="UserID" HeaderText="UserID" ReadOnly="True" /> 
<asp:BoundField DataField="C_Name" HeaderText="中文名字" ReadOnly="True" /> 
<asp:BoundField DataField="E_Name" HeaderText="英文名字" ReadOnly="True" /> 
<asp:BoundField DataField="UpdataDate" HeaderText="更新时间" /> 
</Columns> 
<RowStyle HorizontalAlign="Center" /> 
<PagerStyle HorizontalAlign="Right" /> 
</asp:GridView> 
</td> 
</tr> 

<tr> 
<td > 
<asp:CheckBox ID="CheckBoxAll" runat="server" Text="全选" Width="80px" AutoPostBack="True" OnCheckedChanged="CheckBoxAll_CheckedChanged" /> 
<asp:CheckBox ID="CheckBox1" runat="server" Text="反选" Width="80px" AutoPostBack="True" OnCheckedChanged="CheckBox1_CheckedChanged" /> 
<asp:Button ID="Button1" runat="server" Text="取　消" CssOnClick="Button1_Click"/> 
<asp:Button ID="Button2" runat="server" Text="更新时间" CssOnClick="Button2_Click"/></td> 
</tr> 
</table>