資源簡介
開始學習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調用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 = " "; 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> ] " "[ <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(" "); } } } 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
-----------?---------??----------?-----??----
?????文件???????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
- 上一篇:nodejs 視頻聊天 (SkyRTC)
- 下一篇:js 獲取當前用戶的地理位置
評論
共有 條評論