开发者

how to execute procedure with netbeans?

how can i execute a procedure in netbeanse?

I write bellow query but it has error.

statement.execute("call c开发者_StackOverflow中文版ustomer_fnaem('lisa','test')");


I assume that by 'Netbeans' that you mean you want to call a stored procedure from Java. Using JDBC it would be something like the following:

CallableStatement statement = connection.prepareCall("{ call customer_fnaem(?, ?) }");
proc.setString(1, "lisa");
proc.setString(2, "test");
cs.execute();
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜