看样子不是参数类型的问题,
用setFloat(2,1000)和setDouble(2,1000);都可以import java.sql.*;
public class TestSqlServer{
public static void main(String[] args){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
Connection con = DriverManager.getConnection(url,"sa","sa");
System.out.println("diver is ok"); String sql = "insert into emp values (?,?)";
PreparedStatement pst = con.prepareStatement(sql);
pst.setString(1,"aaa");
pst.setDouble(2,1000);
pst.executeUpdate();
System.out.println("Update is ok");
}catch(Exception e){
e.printStackTrace();
}
}
};
用setFloat(2,1000)和setDouble(2,1000);都可以import java.sql.*;
public class TestSqlServer{
public static void main(String[] args){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
Connection con = DriverManager.getConnection(url,"sa","sa");
System.out.println("diver is ok"); String sql = "insert into emp values (?,?)";
PreparedStatement pst = con.prepareStatement(sql);
pst.setString(1,"aaa");
pst.setDouble(2,1000);
pst.executeUpdate();
System.out.println("Update is ok");
}catch(Exception e){
e.printStackTrace();
}
}
};
解决方案 »
- javax.servlet.ServletException:错误初始化servlet类com.jxw.Hello
- 在测试类中如何加载logback的配置文件logback.xml
- 关于ibatis使用出现的问题
- 急:struts2的问题
- 请问大家有没有用过监控Tomcat状态的软件?
- **郁闷**lomboz开发servlet时不能自动更新web.xml的问题
- servlet请求跳转的问题,怎么转不过去??
- hibernate高手进,hibernate中调用sql的疑问(100分),6点前不定时看贴
- 有没有做过Jtapi,能否提供一些资料
- 运行ejb的中简单问题-----在线等
- <html:errors>问题
- 如何以网页形式向远程服务器串口发送命令
bigint identity BIGINT
binary BINARY
bit BIT
char CHAR
datetime TIMESTAMP
decimal DECIMAL
decimal() identity DECIMAL
float FLOAT
image LONGVARBINARY
int INTEGER
int identity INTEGER
money DECIMAL
nchar CHAR
ntext LONGVARCHAR
numeric NUMERIC
numeric() identity NUMERIC
nvarchar VARCHAR
real REAL
smalldatetime TIMESTAMP
smallint SMALLINT
smallint identity SMALLINT
smallmoney DECIMAL
sql_variant VARCHAR
sysname VARCHAR
text LONGVARCHAR
timestamp BINARY
tinyint TINYINT
tinyint identity TINYINT
uniqueidentifier CHAR
varbinary VARBINARY
varchar VARCHAR