tools.java

简单的分页类

package com.accp;

import java.text.*;
import java.util.*;
import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 * 工具类
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */
public class Tools {
    static String lineSepartor = System.getProperty("line.separator"); //换行
    public Tools() {
    }

    public static String getPageStr(String url, int pageNow, int pageCount) { // 显示分页,传地址,起始页,总页数,
        StringBuffer sb = new StringBuffer(); //用StrintBuffer来写
        sb.append("<TABLE border=\"1\" width=\"100%\">" + lineSepartor);
        sb.append("<TR>" + lineSepartor);
        sb.append("<TD><a href=\"" + url + "?pageNow=1\">首页</a></TD>");
        if (pageCount != pageNow && pageCount != 0) { // 总页数不等于第一页
            sb.append("<TD><a href=\"" + url + "?pageNow=" + (pageNow + 1) +
                      "\">下一页</a></TD>");
        } else {
            sb.append("<TD>下一页</TD>"); // 总页数等于第一页
        }
        if (pageNow != 1&&pageCount!=0) { //不是第一页
            sb.append("<TD><a href=\"" + url + "?pageNow=" + (pageNow - 1) +
                      "\">上一页</a></TD>");
        } else {
            sb.append("<TD>上一页</TD>"); // 是第一页
        }
        sb.append("<TD><a href=\"" + url + "?pageNow=" + pageCount +
                  "\">末页</a></TD>");
        sb.append("<TD>" + pageNow + "/" + pageCount + "</TD>");
        sb.append("</TR>");
        sb.append("</TABLE>");

        return sb.toString();
    }

    public static String getChn(String str) { //转码的方法;
        try {
            str = new String(str.getBytes("ISO-8859-1"), "GB2312");
        } catch (UnsupportedEncodingException ex) {
        }
        return str;
    }

    public static String getCurrentTime() { // 时间转换;
        Date d = new Date();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        return sdf.format(d);
    }

    public static String formatTime(String str) { //格式划时间
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        Date d = null;
        try {
            d = sdf.parse(str);
        } catch (ParseException ex) {
        }
        return sdf.format(d);
    }

    public static void main(String[] args) throws Exception {
//        Class.forName("org.gjt.mm.mysql.Driver");
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection(
                "jdbc:mysql://localhost/accp?user=root&password=mysql");
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("select * from person");
        while (rs.next()) {
            System.out.println(rs.getString(2));
        }
//        String temp = "<SCRIPT LANGUAGE=JavaScript>alert(123);</SCRIPT>";
//        temp = temp.replaceAll("<","&lt");
//        temp = temp.replaceAll(">","&gt");
//        System.out.println(temp);
//
    }
}