catch (Exception e) { System.out.println(e); e.printStackTrace(); // };执行后D:\>javac A.javaD:\>java A 1 java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]COUNT 字段不正确或语法 错误 java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]COUNT 字段不正确或语法 错误 at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036) at sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3104) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedState ment.java:214) at A.main(A.java:38) 0.0没有看懂是什么错误。
CREATE PROCEDURE UGT1(@thermalcapacity float output) asdeclare @A float output,@B float out put,@C float output,@T int,@ID int set @T=273 set @ID=15 select @A=A,@B=B,@C=C FROM 1表 where ID=@ID set @thermalcapacity=@A+@B*@T/100+@C*@T*@T/1000000 GO
{
System.out.println(e);
e.printStackTrace();
//
};执行后D:\>javac A.javaD:\>java A
1
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]COUNT 字段不正确或语法
错误
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]COUNT 字段不正确或语法
错误
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)
at sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3104)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedState
ment.java:214)
at A.main(A.java:38)
0.0没有看懂是什么错误。
asdeclare @A float output,@B float out put,@C float output,@T int,@ID int
set @T=273
set @ID=15
select @A=A,@B=B,@C=C
FROM 1表
where ID=@ID
set @thermalcapacity=@A+@B*@T/100+@C*@T*@T/1000000
GO