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 block92             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     @Override20     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