Shulou(Shulou.com)06/02 Report--

This article is to share with you about the example analysis of java-jdbc-prepared-statement, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

When I was writing the general method of neo4j and orientdb, I suddenly thought of jdbc, and then I wanted to try whether the prepartdStatement in several database jdbc connections of mysql neo4j orientdb is the same.

The source of the problem comes from the following code

List list = new ArrayList (); try (PreparedStatement pst = conn.prepareStatement (sql); ResultSet rs = pst.executeQuery ();) {List fields = new ArrayList (); while (rs.next ()) {if (fields.isEmpty ()) {ResultSetMetaData metaData = rs.getMetaData () / / the fields int count = metaData.getColumnCount (); for (int I = 1; I)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.