MS SQL Server 的money型的取值范围为-2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807,
用 setDouble() 就可以了
tmp表 ID varchar(10)
Price money
String sql="insert into tmp values(?,?)";
PreparedStatement stmt=conn.prepareStatement(sql);
stmt.setString(1,"abc");
stmt.setDouble(2,100.356);
int ret=stmt.executeUpdate();
用 setDouble() 就可以了
tmp表 ID varchar(10)
Price money
String sql="insert into tmp values(?,?)";
PreparedStatement stmt=conn.prepareStatement(sql);
stmt.setString(1,"abc");
stmt.setDouble(2,100.356);
int ret=stmt.executeUpdate();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货