测试iq数据库保留两位小数方法

package com.eastcom_sw.inas.mobile.dao.theme;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
 * 
 * @author Hongten</br>
 * @date 2012-7-16
 *
 */
public class JDBCTest {
	
	// 创建静态全局变量  
    static Connection conn; 
    
	/* 获取数据库连接的函数*/  
    public static Connection getConnection() {  
        Connection con = null;  //创建用于连接数据库的Connection对象  
        try {  
            Class.forName("com.sybase.jdbc3.jdbc.SybDriver");// 加载Mysql数据驱动  
              
            con = DriverManager.getConnection(  
                    "jdbc:sybase:Tds:10.40.93.108:5000", "ipmsodm", "eastcom#1390");// 创建数据连接  
              
        } catch (Exception e) {  
            System.out.println("数据库连接失败" + e.getMessage());  
        }  
        return con; //返回所建立的数据库连接  
    }  
    
    
    public static void main(String[] args) {
    	conn = getConnection();
    	System.out.println(conn);
//        String sql = "select convert(decimal(32,2),round(flow_,2)) from DM_HTTPBAD_TCP_D";
        String sql = "select cast(round(flow_,2) as decimal(32,2)) from DM_HTTPBAD_TCP_D";
 
        try {
            PreparedStatement ps = conn.prepareStatement(sql);
            ResultSet rs = ps.executeQuery();
            System.out.println(rs.next());
            while (rs.next()) {
                System.out.println("FLOW_ : " + rs.getString(1));
            }
 
            // 关闭记录集
            if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
 
            // 关闭声明
            if (ps != null) {
                try {
                    ps.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
 
            // 关闭链接对象
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
 
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
 
}

测试得出

cast(round(flow_,2) as decimal(32,2))

可以保留两位小数