91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 43.83M
    文件類型: .rar
    金幣: 1
    下載: 0 次
    發布日期: 2021-01-30
  • 語言: JavaScript
  • 標簽: Ajax??MySql??java??sql??js??

資源簡介

開始學習java-WEB了,做了基礎練習,
java調用MySQL庫,使用Servlet、ajax實現數據庫的讀寫。
演示在菜單第一類的前2項,其他沒有。
使用時注意將Gson.jar、mysql-connector-java-8.0.11.jar
復制到Tomcat的Lib里面,是序列化和連接數據庫用的。
因為剛學,前端寫不好,只作為數據庫操作的基礎參考,如有錯誤自行修正。

數據庫連接設置在:DBUtil.java文件;
數據庫為sql格式文件,在MySQL編輯器,比如navicat,里運行安裝;
未使用框架,頁碼分頁等均自寫,Function.java

Java編輯器為IntelliJ IDEA 2018.1.5 x64,自行下載百度激活。



//頁碼顯示,添加刪除記錄動態原位置順序更新
public static String[] Paging (int fPage_Ing,String tableName,int fPage_Pading,String terms,String search)
    {
        int fPage_Count; //總頁數

        String pageStr = "";
        fPage_Count = GetPageCount(fPage_Pading,tableName,terms,search);


        if (fPage_Ing>fPage_Count) fPage_Ing=fPage_Count;


        int p_begin = 0, p_end = 10;
        boolean view_first, view_last;

        if (fPage_Count <= 10)
        {
            p_begin = 0;
            p_end = fPage_Count;
            view_first = false;
            view_last = false;
        }
        else
        {
            p_begin = (fPage_Ing - 1) - 5;
            if (p_begin <= 0)
            {
                p_begin = 0;
                p_end = 10;
                view_first = false;
                view_last = true;
            }
            else
            {
                p_end = p_begin   10;
                if (p_end >= fPage_Count)
                {
                    p_begin = fPage_Count - 10;
                    p_end = fPage_Count;
                    view_first = true;
                    view_last = false;
                }
                else
                {
                    p_end = p_begin   10;
                    view_first = true;
                    view_last = true;
                }
            }
        }

        for (int i = p_begin; i < p_end; i  )
        {
            if ((i 1)==fPage_Ing) {
                pageStr  = "[<button style=\"outline: none;color:#ffff00;font-size: 1.2rem;border:0px;background:transparent;cursor: pointer\">"  
                        (i   1)   "</button>] ";
            } else {
                pageStr  = "[<button onclick=\"ajaxGetPaging("   (i 1)   ")\" style=\"outline: none;color:#fff;font-size: 0.85rem;border:0px;background:transparent;cursor: pointer\">"  
                        (i   1)   "</button>] ";

            }
        }
        if (view_first)
        {
            pageStr = "[<button onclick=\"ajaxGetPaging(1)\" style=\"outline: none;color:#fff;font-size: 0.85rem;border:0px;background:transparent;cursor: pointer\">" 
                    "1</button>] " " ... "  pageStr;
        }

        if (view_last)
        {
            pageStr  =" ... [<button onclick=\"ajaxGetPaging(" fPage_Count ")\" style=\"outline: none;color:#fff;font-size: 0.85rem;border:0px;background:transparent;cursor: pointer\">" 
                    fPage_Count "</button>] ";
        }

        pageStr  = "&nbsp;&nbsp;&nbsp;&nbsp;";


        String[] strArr = new String[2];

        strArr[0] = pageStr;
        strArr[1] = fPage_Ing "";

        return strArr;
    }


<script type="text/javascript">

    $(document).ready(function(){
        ajaxGetPaging(1);
    });

    function ajaxGetPaging(page_ing) {
        $.ajax({
            type: "POST",
            url: "/User?action=paging&page=" page_ing,
            data:{
                Sort:$("#Hd_Sort").val(),
                Search:$("#tcSearch").val()
            },
            dataType: "text",
            success: function(data){
                //alert(data);
                $("#paging_top").html("頁碼: " data);
                $("#paging_bottom").html("頁碼: " data);
                ajaxGetUserInfo(page_ing);
            }, error: function(){
                alert("Request data error!");
            }
        });
    }

    function ajaxGetUserInfo(page_ing) {
        clearHtml();
        $.ajax({
            type: "POST",
            url: "/User?action=getuser&page=" page_ing,
            data:{
                Sort:$("#Hd_Sort").val(),
                Search:$("#tcSearch").val()
            },
            dataType: "json",
            success: function(data){
                packJson = data;
                for(var i = 0; i < packJson.length; i  ){
                    $("#user_" (i 1) "2").html(((page_ing-1)*12 (i 1)) ".");
                    $("#user_" (i 1) "3").html(packJson[i].USER_Group);
                    $("#user_" (i 1) "4").html(packJson[i].USER_Name);
                    $("#user_" (i 1) "5").html(packJson[i].USER_RegTime);
                    $("#user_" (i 1) "6").html(
                        "[ <a onclick=\"editInfo(" packJson[i].uid ");\" " 
                            "style=\"height: 10px; outline: none;color:#ffffcc;border:0px;background:transparent;cursor: pointer\"><i class='fa fa-pencil-square-o' ></i> 編輯</a> ]&nbsp;&nbsp;&nbsp;"  
                        "[ <a onclick=\"deleteInfo(\'" packJson[i].USER_Nic "\',\'" packJson[i].uid "\',\'" page_ing "\');\" " 
                            "style=\"outline: none;color:#ffffcc;border:0px;background:transparent;cursor: pointer\"><i class='fa fa-remove'></i> 刪除</a> ]"
                    );
                }
            }, error: function(){
                alert("Request data error!");
            }
        });
    }

     function deleteInfo(uname,uid,page_ing) {
        zeroModal.confirm("<span style=\"color:#ff6666\">刪除</span> " uname, function() {
            $.ajax({
                type: "POST",
                url: "/User?action=delete&page=" page_ing "&id=" uid,
                dataType: "text",
                success: function(data){
                    ajaxGetPaging(data);
                }, error: function(){
                    alert("Request data error!");
                }
            });
        })
    }

    function clearHtml() {
        for (var i=0;i<12;i  )
        {
            for (var t=0;t<6;t  )
            {
                $("#user_" (i 1) (t 1)).html("&nbsp;");
            }
        }
    }

    function ajaxSort(sort) {
        $("#Hd_Sort").val(sort);
        ajaxGetPaging(1);
    }

    function ajaxSearch() {
        ajaxGetPaging(1);
    }
</script>


資源截圖

代碼片段和文件信息

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????3479??2018-06-16?22:49??數據庫sql文件.rar

?????文件???43835665??2018-06-16?22:50??java_代碼.rar

?????文件?????241622??2018-06-06?09:55??gson-2.8.5.jar

?????文件????2036609??2018-03-25?07:00??mysql-connector-java-8.0.11.jar

-----------?---------??----------?-----??----

?????????????46117375????????????????????4


評論

共有 條評論