如何使用setObject为PreparedStatement对象传入动态参数？

最新推荐文章于 2022-03-10 21:56:46 发布

zd10101501

最新推荐文章于 2022-03-10 21:56:46 发布

阅读量3.7k

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/danzhang1010/article/details/42835143

版权

这篇博客介绍了在Java中使用PreparedStatement时，如何通过setObject方法传入动态参数，特别是处理datetime类型的值，建议使用对象表示参数，利用PreparedStatement的类型支持以避免类型转换错误。示例代码展示了如何创建更简洁、易维护的方法。

摘要由CSDN通过智能技术生成

来自stackoverflow的答案，注意的是一般为sqlserver中datetime类型传入值的时候，对应的是java.sql.Timestamp类型，别把值传错了，当然以前用hibernate的时候，框架已经把这些类型差异都封装屏蔽好了，现在自己用jdbc写，好多坑坑。。。

http://stackoverflow.com/questions/10125270/prepare-statement-create-method-using-an-arraylist-of-parameters/10126048#10126048

You should use an object representation for your parameters, rather than an ArrayList<Object> of size 2. Also, you don't need your own DataType enumeration, there is already a java.sql.Typesclass. Best of all, there's a setObject() method on PreparedStatement that recognizes these types values, so you don't need a switch statement or calls to type-specific PreparedStatement.set..()methods.

Here's a solution that has an object representation for the parameters, takes advantage of java.sql.Types and preparedStatement.setObject() support for those types, and also insulates you from the type constant values.

First, the object representation for the parameters: