oracle+servlet+extjs4 分页表格布局示例代码

Log.java

 

  1 package com.example.entity;
  2 
  3 import java.util.Date;
  4 
  5 public class Log {
  6 
  7     private int id;
  8     private Date timestamp;
  9     private String module;
 10     private String function;
 11     private String method;
 12     private String userId;
 13     private String userName;
 14     private String localIp;
 15     private String remoteIp;
 16     private int type;
 17     private String fileName;
 18     private int fileSize;
 19     private String params;
 20     private int success;
 21     private String error;
 22     public String getError() {
 23         return error;
 24     }
 25     public void setError(String error) {
 26         this.error = error;
 27     }
 28     public String getFileName() {
 29         return fileName;
 30     }
 31     public void setFileName(String fileName) {
 32         this.fileName = fileName;
 33     }
 34     public int getFileSize() {
 35         return fileSize;
 36     }
 37     public void setFileSize(int fileSize) {
 38         this.fileSize = fileSize;
 39     }
 40     public String getFunction() {
 41         return function;
 42     }
 43     public void setFunction(String function) {
 44         this.function = function;
 45     }
 46     public int getId() {
 47         return id;
 48     }
 49     public void setId(int id) {
 50         this.id = id;
 51     }
 52     public String getLocalIp() {
 53         return localIp;
 54     }
 55     public void setLocalIp(String localIp) {
 56         this.localIp = localIp;
 57     }
 58     public String getMethod() {
 59         return method;
 60     }
 61     public void setMethod(String method) {
 62         this.method = method;
 63     }
 64     public String getModule() {
 65         return module;
 66     }
 67     public void setModule(String module) {
 68         this.module = module;
 69     }
 70     public String getParams() {
 71         return params;
 72     }
 73     public void setParams(String params) {
 74         this.params = params;
 75     }
 76     public String getRemoteIp() {
 77         return remoteIp;
 78     }
 79     public void setRemoteIp(String remoteIp) {
 80         this.remoteIp = remoteIp;
 81     }
 82     public int getSuccess() {
 83         return success;
 84     }
 85     public void setSuccess(int success) {
 86         this.success = success;
 87     }
 88     public Date getTimestamp() {
 89         return timestamp;
 90     }
 91     public void setTimestamp(Date timestamp) {
 92         this.timestamp = timestamp;
 93     }
 94     public int getType() {
 95         return type;
 96     }
 97     public void setType(int type) {
 98         this.type = type;
 99     }
100     public String getUserId() {
101         return userId;
102     }
103     public void setUserId(String userId) {
104         this.userId = userId;
105     }
106     public String getUserName() {
107         return userName;
108     }
109     public void setUserName(String userName) {
110         this.userName = userName;
111     }
112     
113 }

 

LogDAO.java

 

 1 package com.example.DAO;
 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 import java.sql.PreparedStatement;
 6 import java.sql.ResultSet;
 7 import java.sql.SQLException;
 8 import java.util.ArrayList;
 9 import java.util.List;
10 
11 
12 import com.example.entity.Log;
13 
14 
15 public class LogDAO {
16 
17     private static Connection getConn() {
18         String driver = "oracle.jdbc.driver.OracleDriver";
19         String url = "jdbc:oracle:thin:@192.168.97.201:1521:fznop";
20         String username = "bi_swxt";
21         String password = "swxt2013";
22         Connection conn = null;
23         try {
24             Class.forName(driver);
25             // new oracle.jdbc.driver.OracleDriver();
26             conn = DriverManager.getConnection(url, username, password);
27         }
28         catch (ClassNotFoundException e) {
29             e.printStackTrace();
30         }
31         catch (SQLException e) {
32             e.printStackTrace();
33         }
34 
35         return conn;
36     }
37     
38     public static List<Log> findAll(int start, int limit) {
39         int s = start +1;
40         int e = start + limit;
41         Connection conn = getConn();
42         String sql = "select id,timestamp,module,function,method,user_id,user_name,local_ip," +
43                 "remote_ip,type,file_name,file_size,params,success,error from (select r.*, rownum as d " +
44                 "from (select * from system_log) r where rownum <= " +e + ") where d >= " +s;
45         PreparedStatement pstmt;
46         List<Log> list = new ArrayList<Log>();
47         
48             try {
49                 pstmt = conn.prepareStatement(sql);
50                 ResultSet rs = pstmt.executeQuery();
51                 while (rs.next()) {
52                     Log log = new Log();
53                     log.setId(rs.getInt(1));
54                     log.setTimestamp(rs.getDate(2));
55                     log.setModule(rs.getString(3));
56                     log.setFunction(rs.getString(4));
57                     log.setMethod(rs.getString(5));
58                     log.setUserId(rs.getString(6));
59                     log.setUserName(rs.getString(7));
60                     log.setLocalIp(rs.getString(8));
61                     log.setRemoteIp(rs.getString(9));
62                     log.setType(rs.getInt(10));
63                     log.setFileName(rs.getString(11));
64                     log.setFileSize(rs.getInt(12));
65                     log.setParams(rs.getString(13));
66                     log.setSuccess(rs.getInt(14));
67                     log.setError(rs.getString(15));
68                     list.add(log);
69                 }
70                 rs.close();
71                 pstmt.close();
72                 conn.close();
73             } catch (SQLException e1) {
74                 e1.printStackTrace();
75             }        
76         return list;
77     }
78     
79     public static int getTotal(){
80         Connection conn = getConn();
81         String sql = " select count(*) from system_log";
82         PreparedStatement pstmt;
83         int total = 0;
84         try {
85             pstmt = conn.prepareStatement(sql);
86             ResultSet rs = pstmt.executeQuery();
87             if(rs.next()){
88                 total= rs.getInt(1);
89             }
90         } catch (SQLException e) {
91             // TODO Auto-generated catch block
92             e.printStackTrace();
93         }
94         return total;
95     }
96 }

 

LogServlet.java

 

 1 package com.example.servlet;
 2 
 3 import java.io.IOException;
 4 import java.io.PrintWriter;
 5 import java.util.List;
 6 
 7 import javax.servlet.ServletException;
 8 import javax.servlet.http.HttpServlet;
 9 import javax.servlet.http.HttpServletRequest;
10 import javax.servlet.http.HttpServletResponse;
11 
12 import com.example.DAO.LogDAO;
13 import com.example.entity.Log;
14 
15 public class LogServlet extends HttpServlet {
16     
17     private static final long serialVersionUID = -4798851845756886622L;
18 
19     @Override
20     protected void doGet(HttpServletRequest req, HttpServletResponse resp)
21             throws ServletException, IOException {
22         int start = Integer.parseInt(req.getParameter("start"));
23         int limit = Integer.parseInt(req.getParameter("limit"));
24         LogDAO logDAO = new LogDAO();
25         List<Log> list = logDAO.findAll(start , limit);
26         int total = logDAO.getTotal();
27         StringBuilder sb = new StringBuilder();
28         sb.append("{results: " + total + ", rows:[");
29         for (Log log : list) {
30             sb.append("{");
31             sb.append("ID : " + log.getId());
32             sb.append(", TIMESTAMP : \‘" + log.getTimestamp() + "\‘");
33             sb.append(", MODULE : \‘" + log.getModule() + "\‘");
34             sb.append(", FUNCTION : \‘" + log.getFunction() + "\‘");
35             sb.append(", METHOD : \‘" + log.getMethod() + "\‘");
36             sb.append(", USER_ID : \‘" + log.getUserId() + "\‘");
37             sb.append(", USER_NAME : \‘" + log.getUserName() + "\‘");
38             sb.append(", LOCAL_IP : \‘" + log.getLocalIp() + "\‘");
39             sb.append(", REMOTE_IP : \‘" + log.getRemoteIp() + "\‘");
40             sb.append(", TYPE : " + log.getType());
41             sb.append(", FILE_NAME : \‘" + log.getFileName() + "\‘");
42             sb.append(", FILE_SIZE : " + log.getFileSize());
43             sb.append(", PARAMS : \‘" + log.getParams() + "\‘");
44             sb.append(", SUCCESS : " + log.getSuccess());
45             sb.append(", ERROR : \‘" + log.getError() + "\‘");
46             sb.append("},");
47         }
48 
49         String json = sb.substring(0, sb.length() - 1);
50 
51         json += "]}";
52         resp.setContentType("text/html");
53         resp.setCharacterEncoding("UTF-8");
54         PrintWriter out = resp.getWriter();
55         out.println(json);
56         out.close();
57     }
58 
59 }

 

grid.js

 

 1 Ext.onReady(function(){
 2         var itemsPerPage = 10;
 3         
 4         var store = Ext.create(‘Ext.data.Store‘,{
 5             autoLoad: {start: 0, limit: itemsPerPage},
 6             fields: [‘ID‘,‘TIMESTAMP‘,‘MODULE‘,‘FUNCTION‘,‘METHOD‘,‘USER_ID‘,‘USER_NAME‘
 7                 ,‘LOCAL_IP‘,‘REMOTE_IP‘,‘TYPE‘,‘FILE_NAME‘,‘FILE_SIZE‘,‘PARAMS‘,‘SUCCESS‘,‘ERROR‘],//定义字段
 8             pageSize: itemsPerPage,
 9             proxy: {
10                  type: ‘ajax‘,
11                  url: ‘log.do‘,             
12                  reader: {
13                        type: ‘json‘,
14                        root: ‘rows‘,
15                        totalProperty: ‘results‘
16                  }
17             }
18         });
19         //创建Grid表格组件
20         Ext.create(‘Ext.grid.Panel‘,{
21             title : ‘Grid表格示例‘,
22             renderTo: Ext.getBody(),
23             width:1300,
24             height:330,
25             frame:true,
26             store: store,
27            
28             columns: [//配置表格列
29                 {header: "ID", width: 80, dataIndex: ‘ID‘, sortable: true},
30                 {header: "TIMESTAMP", width: 80, dataIndex: ‘TIMESTAMP‘, sortable: true},
31                 {header: "MODULE", width: 80, dataIndex: ‘MODULE‘, sortable: true},
32                 {header: "FUNCTION", width: 80, dataIndex: ‘FUNCTION‘, sortable: true},
33                 {header: "METHOD", width: 80, dataIndex: ‘METHOD‘, sortable: true},
34                 {header: "USER_ID", width: 80, dataIndex: ‘USER_ID‘, sortable: true},
35                 {header: "USER_NAME", width: 80, dataIndex: ‘USER_NAME‘, sortable: true},
36                 {header: "LOCAL_IP", width: 80, dataIndex: ‘LOCAL_IP‘, sortable: true},
37                 {header: "REMOTE_IP", width: 80, dataIndex: ‘REMOTE_IP‘, sortable: true},
38                 {header: "TYPE", width: 80, dataIndex: ‘TYPE‘, sortable: true},
39                 {header: "FILE_NAME", width: 80, dataIndex: ‘FILE_NAME‘, sortable: true},
40                 {header: "FILE_SIZE", width: 80, dataIndex: ‘FILE_SIZE‘, sortable: true},
41                 {header: "PARAMS", width: 80, dataIndex: ‘PARAMS‘, sortable: true},
42                 {header: "SUCCESS", width: 80, dataIndex: ‘SUCCESS‘, sortable: true},
43                 {header: "ERROR", width: 80, dataIndex: ‘ERROR‘, sortable: true}
44             ],
45             bbar:[{
46                 xtype: ‘pagingtoolbar‘,
47                 store: store,
48                 displayInfo: true,
49                 displayMsg: ‘显示第 {0} 条到 {1} 条记录,一共 {2} 条‘,
50                 emptyMsg: "当前查询条件无数据,请重新查询"
51             }]
52         });
53     });

 

index.jsp

 

 1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 2 <html>
 3     <head>
 4         <title>MyTestWeb</title>
 5         <link type="text/css" rel="stylesheet" href="resource/common/extjs/resources/css/ext-all-neptune.css" />
 6     </head>
 7     <body >
 8         <script type="text/javascript" src="resource/common/extjs/ext-all.js"></script>
 9         <script type="text/javascript" src="resource/common/extjs/locale/ext-lang-zh_CN.js"></script>
10         <script type="text/javascript" src="resource/common/extjs/packages/ext-theme-neptune/build/ext-theme-neptune.js"></script>
11         <script type="text/javascript" src="resource/grid/grid.js"></script>
12         <%--<div >
13         </div>
14     --%></body>
15 </html>

 

web.xml

 

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"
 3     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 4     xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
 5     http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
 6     
 7     <servlet>
 8         <servlet-name>Log</servlet-name>
 9         <servlet-class>
10             com.example.servlet.LogServlet
11         </servlet-class>
12     </servlet>
13     <servlet-mapping>
14         <servlet-name>Log</servlet-name>
15         <url-pattern>/log.do</url-pattern>
16     </servlet-mapping>
17 
18     <welcome-file-list>
19         <welcome-file>index.jsp</welcome-file>
20     </welcome-file-list>
21 </web-app>

 

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。