SQL stored procedure of spring (13)

• Java

The simplejdbccall class can be used to call a stored procedure containing in and out parameters. You can use this method when dealing with any RDBMS, such as Apache Derby, DB2, mysql, Microsoft SQL server, Oracle, and Sybase.

Or continue with the example of spring based JDBC framework

(1) Create the corresponding stored procedure based on the test library

(2) Create entity

(3) Write studentdao

(4) Write studentmapper java

(5) Write the studentjdbc template java

(6) Write the corresponding mainapp java

(7) Write beans xml

(8) Run mainapp Main method in Java

The results are shown in the figure below:

@H_ 502_ 322@

The content of this article comes from the network collection of netizens. It is used as a learning reference. The copyright belongs to the original author.
THE END
分享
二维码
< <上一篇
下一篇>>