globalutil.java

报表,关于ireport报表的一些源码(转)

package cn.edu.hlju.oa.kygl.util;

import java.sql.Date;
import java.sql.Timestamp;
import java.text.*;
import java.util.Calendar;
import java.util.TreeMap;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
import cn.edu.hlju.oa.kygl.db.DBConnection;
import java.sql.Statement;

/**
 * 提供一些公用的工具方法
 */
public class GlobalUtil {
    /**
     * 对数字进行格式化
     * @param data float      原始数据
     * @param integerBits int 整数位
     * @param fractionBit int 小数位
     */
    public static String numberFormat(float data,int intBits,int fractionBit){
        StringBuffer sb = new StringBuffer();
        for(int i = 0; i < intBits; i++)
            sb.append("#");
        sb.append(".");
        for(int j = 0; j < fractionBit; j++)
            sb.append("0");
        DecimalFormat df = new DecimalFormat(sb.toString());
        return df.format(data);
    }

    private static SimpleDateFormat ymFormat = new SimpleDateFormat("yyyy.MM");
    public static String ymTimestampFormater(Timestamp timestamp) throws ParseException {
        return ymFormat.format(timestamp);
    }

    private static SimpleDateFormat ymdFormat = new SimpleDateFormat("yyyy-MM-DD");
    public static String ymdTimestampFormater(Timestamp timestamp) throws ParseException {
        return ymdFormat.format(timestamp);
    }

    private static SimpleDateFormat yFormat = new SimpleDateFormat("yyyy");
    public static String yTimestampFormater(Timestamp timestamp) throws ParseException {
        return yFormat.format(timestamp);
    }

    /**
     * 将已知的字符串前面添加0
     * @param old String 原始字符串
     * @param length int 要填充的字符串长度
     * @return String
     */
    public static String fillWithZero(String old,int length){
        StringBuffer sb = new StringBuffer();
        for(int i = 0; i < length - old.length(); i++){
            sb.append("0");
        }
        sb.append(old);
        return sb.toString();
    }


    //获得重点实验室的编码及其名称
    public static TreeMap getILabInfo(String bmfl) throws SQLException {
        TreeMap<String,String> map = new TreeMap<String,String>();
        Connection conn = DBConnection.getConnection();
        String getBmmcQuery = "select bm,bmmc from ky_kyxtbmb where bmfl=? and bm>'00000' ORDER BY bm";

        PreparedStatement pStmt = conn.prepareStatement(getBmmcQuery);
        pStmt.setString(1,bmfl);
        ResultSet rs = pStmt.executeQuery();
        while(rs.next() ){
            map.put(rs.getString(1),rs.getString(2));
        }
        DBConnection.releaseConnection(conn);
        return map;
    }

    //获得人事编号和其对应的人名
    public static TreeMap getMinistryInfo() throws SQLException {
        TreeMap<String,String> map = new TreeMap<String,String>();
        Connection conn = DBConnection.getConnection();
        String ministryQuery = "SELECT rsbh,xm FROM rsda_jbxx ORDER BY xm";

        Statement pStmt = conn.createStatement();
        ResultSet rs = pStmt.executeQuery(ministryQuery);
        while(rs.next() ){
            map.put(rs.getString(1),rs.getString(2));
        }
        DBConnection.releaseConnection(conn);
        return map;
    }

    //测试用
    public static void main(String[] s){
    	DecimalFormat df = new DecimalFormat("###.0");
        df.applyPattern("###.0");
        System.out.println(df.format(1122.22));
        Timestamp timeStamp = new Timestamp(System.currentTimeMillis());
    }
}