因扰了我两个小时,不得其解,各位高手帮忙看看!!!!!!!!

[xuzhenhua21]

package com.huafu;
import java.sql.*;


/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2003</p>
* <p>Company: </p>
* @author not attributable
* @version 1.0
*/

public class CallProcedure {
public CallProcedure() {
}
public static void main(String[] args) {
try
{CallProcedure callProcedure1 = new CallProcedure();

PrepareStatement1 prepareStatement1 = new PrepareStatement1();
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String sourceURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String userID = "sa";
String passwd = "sa";
//String strSql="insert into test (au_id,au_lname,au_fname,phone,address,city,state,zip,contract) values(?,?,?,?,?,?,?,?)";

Connection databaseConnection=DriverManager.getConnection(sourceURL, userID, passwd);
String sql="{ call addauthor(?,?,?}";
CallableStatement stmt;
stmt=databaseConnection.prepareCall(sql);
String x="10101";
String y="11";

String z="11";

stmt.setString(1,x);
stmt.setString(2,y);
stmt.setString(3,z);

stmt.executeUpdate();
System.out.println("successfully!");

}
catch (ClassNotFoundException ec){
ec.printStackTrace();
} catch (SQLException es){
es.printStackTrace();

}


}

}
--------------------------
存储过程如下:
CREATE PROCEDURE addauthor (@id varchar(50),@lname varchar(50),
@fname varchar(50))
AS
insert into test (au_id,au_lname,au_fname)
values(@id,@lname,@fname)
--------------
提示信息,
第 1 行: '{' 附近有语法错误。
为什么?

[piaochenli]

String sql="{ call addauthor(?,?,?}";

[CitySir]

显然上面一行少了一个小括号)

[ExplorerCSharp]

可能是掉‘）’的原因

[xuzhenhua21]

真是不好意思，我都怀疑自己是不是程序员了，有近一年没写了！^-^
大家这么热情，怎么能好意思不结贴呢。