此實例是在我發表的“ Extjs4---grid+servlet分頁查詢 ”上添加的搜索功能,基本功能已經實現,但是存在亂碼問題,希望有大師指導解決亂碼問題
在 Extjs4 中,搜索組件以插件的形式出現,而且實現也非常簡單,搜索組件位于 examples/ux/form 目錄下, JS 文件是 SearchField.js 。
Grid 加載搜索功能,要注意的是:
1 、開啟延遲加載,即 Ext.Loader.setConfig({enabled:true});
2 、設置插件的目錄: Ext.Loader.setPath('Ext.ux','../../examples/ux'); ,需要注意,插件所在目錄一定要正確,否則加載失敗,就實現不了 所要功能了。
html代碼:
和“ Extjs4---grid+servlet分頁查詢 ”代碼相同這里就不貼了
searchGrid.js代碼:
//下面兩行代碼必須要,不然會報404錯誤 Ext.Loader.setConfig({enabled:true}); //我的searchGrid和ext4在同一目錄下,所以引用時要到根目錄去"../" Ext.Loader.setPath('Ext.ux','../ext4_example/ext4/examples/ux'); //預加載 Ext.require( [ 'Ext.grid.*', 'Ext.toolbar.Paging', 'Ext.util.*', 'Ext.data.*', //注意引用 'Ext.ux.form.SearchField' ] ); Ext.onReady( function(){ //創建Model Ext.define( 'User', { extend:'Ext.data.Model', fields:[ {name:'name',mapping:'name'}, {name:'sex',mapping:'sex'}, {name:'age',mapping:'age'} ] } ) //創建數據源 var store = Ext.create( 'Ext.data.Store', { model:'User', //設置分頁大小 pageSize:5, proxy: { type: 'ajax', url : 'users', reader: { //數據格式為json type: 'json', root: 'bugs', //獲取數據總數 totalProperty: 'totalCount' } }, autoLoad:true } ); //創建grid var grid = Ext.create('Ext.grid.Panel',{ store:store, columns:[ {text:'姓名',width:120,dataIndex:'name',sortable:true}, {text:'性別',width:120,dataIndex:'sex',sortable:true}, {text:'年齡',width:120,dataIndex:'age',sortable:true} ], height:200, width:480, x:20, y:40, title: 'ExtJS4 Grid分頁查詢示例示例', renderTo: 'grid', dockedItems:[ //添加搜索控件 { dock:'top', xtype:'toolbar', items:{ width:200, fieldLabel:'搜索姓名', labelWidth:70, xtype:'searchfield', store:store } },{ dock:'bottom', xtype:'pagingtoolbar', store:store, displayInfo:true, displayMsg:'顯示{0}-{1}條,共計{2}條', emptyMsg:'沒有數據' } ], } ) store.loadPage(1); } )
package servlet; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; /* * @author 劉暢 */ public class Servlet extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { doPost(req, resp); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { //在這里已經設置編碼但是還是有亂碼出現 req.setCharacterEncoding("UTF-8"); //System.out.println(req.getCharacterEncoding()); Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; String start = req.getParameter("start"); String limit = req.getParameter("limit"); StringBuilder sb = null; String query = req.getParameter("query"); //此處會輸出亂碼,求高人解決 System.out.println(query); //數據總數 int total = 0; try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/user", "root", "123456"); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } //sql語句 String countSql = "select count(*) from users"; String selectSql = "select * from users limit " + start + ", " + limit; //如果有搜索條件則會把條件添加到sql語句中 if(query!=null){ countSql+=" where name='"+query+"'"; selectSql="select * from users where name='"+query+"' limit " + start + ", " + limit; } //查詢總數 try { pstmt = con.prepareStatement(countSql); rs = pstmt.executeQuery(); while(rs.next()){ total = rs.getInt(1); } } catch (SQLException e) { e.printStackTrace(); } //分頁查詢 try { pstmt = con.prepareStatement(selectSql); rs = pstmt.executeQuery(); sb = new StringBuilder(); //設置json數據格式 sb.append("{totalCount:"+total+",bugs:["); while (rs.next()) { sb.append("{"); sb.append("name:" + "\'" + rs.getString(1) + "\',"); sb.append("sex:" + "\'" + rs.getString(2) + "\',"); sb.append("age:" + "\'" + rs.getString(3) + "\'"); sb.append("},"); } } catch (SQLException e) { e.printStackTrace(); } try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } String json = sb.substring(0, sb.length() - 1); json += "]}"; System.out.println(json); resp.setContentType("text/html"); resp.setCharacterEncoding("UTF-8"); try { resp.getWriter().write(json); resp.getWriter().close(); } catch (IOException e) { e.printStackTrace(); } } }
效果圖:
查詢姓名為“1”的:
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索:z360901061

微信掃一掃加我為好友
QQ號聯系: 360901061
您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對您有幫助就好】元
