jdbc

Hi everyone. You need to get the ResultSet from such a procedure: exec ais_disp.p_lk.p_add_client (v_sis_id => 1640, ... ommit; How to cram this into java code? I tried using CallableStatement, but I can't insert select from the procedure there.

I am developing my own mini-utility for working with MySQL. How can I check the connection to the specified host (by username ... stractions require a corresponding database to work (in particular, MysqlDataSource, in my case)... Thank you in advance)

The program should display the data of registered users. There are no problems connecting to the database, but resultSet.getS ... ame, and the "working" database was displayed in my broken program. What kind problems may be with the krknutyun database?

I often see statements that you should use PreparedStatement instead of the usual Statement to protect yourself from sql injections. How does it protect?

There is a simple Java application for tests on joining a MySQL database. What I did: In web.xml I added this: <?x ... ter.java:53) I've already tried everything I can. I reviewed all the documentation. I don't understand why it doesn't work?

Tell me how to get the number of rows in the database via ResultSet and the count query?

In 1C, when traversing the query result, you can traverse the query hierarchically. Each final result contains, in addition t ... ect that the situation is similar in bare SQL. Tell me how to correctly bypass the query result in the code using groupings.