使用Oracle+Java的小心!
创建一个简单表: TABLE TEST_TABLE ,做下面的测试
public static void main(String[] args) throws Exception
{
Class.forName ("oracle.jdbc.OracleDriver");
Connection connection = null;
try
{
connection = (Connection) DriverManager.getConnection ("some_oci_url", "user", "****");
String query = "insert into test_table values (?)";
PreparedStatement stmt = connection.prepareStatement(query);
BigDecimal bd = new BigDecimal(new Double(12500000).toString());
stmt.setBigDecimal(1, bd);
stmt.execute();
}
finally
{
if(connection != null)
connection.close();
}
}
作好准备;
select * from test_table
VALUE
-----
1250000
结果少了一个零!
转载 :http://blog.csdn.net/benewu/archive/2007/01/10/1478846.aspx
在我的blog,也欢迎大家发表评论。