How to use storage in JSP

This article introduces the knowledge of "how to use storage in JSP". Many people will encounter this dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. Standard usage of overstorage process in Java:

Various functions in the stored procedure can be realized, and compared with the minimalist method, it can get the out parameters and the return value of the procedure.

? Is the placeholder for the parameter, and a question mark indicates that there is a parameter.

Double-click the code to select all

Stringproc= "{callprocname (?)}"

CallableStatementstat=con.prepareCall (proc)

/ / if the first parameter is in, what is the description? The number should be under the English input method, and this blog cannot enter a question mark in English.

Stat.setString (1 recording paravalue'); / / set parameter values

/ / if the second parameter is out

Stat.registerOutParameter (1domain java.sql.Types.VARCHAR); / / sets the parameter type

Stat.execute ()

StringparaValue=stat.getString (2); / / get the out parameter value

For example: