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

来源：互联网发布：连拍相机软件编辑：程序博客网时间：2024/05/16 12:33

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))

可以保留两位小数

0 0