本机查询错误

发布于 2024-11-30 12:03:49 字数 419 浏览 4 评论 0原文

我是 sql 新手，我面临以下本机查询的问题

 public void saveOfflineBatchDetails(BigInteger user_id) {

    em.createNativeQuery("INSERT INTO rst_offline_transaction_batch (created_date , user_id)" +
            "VALUES('?1', ?2)")
            .setParameter(1, new java.util.Date())
            .setParameter(2, user_id)
            .executeUpdate();
}

它不会将值传递到数据库。创建日期应该是今天的日期和时间。谁能告诉我这个查询有什么问题。多谢

原文

Im new to sql and im facing a problem with the below native query

 public void saveOfflineBatchDetails(BigInteger user_id) {

    em.createNativeQuery("INSERT INTO rst_offline_transaction_batch (created_date , user_id)" +
            "VALUES('?1', ?2)")
            .setParameter(1, new java.util.Date())
            .setParameter(2, user_id)
            .executeUpdate();
}

It doesn't pass the values to the database. the created date should be the today's date and time. Can anyone tell me whats wrong in this query.
Thanks a lot

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

思念满溢 2024-12-07 12:03:49

通常，参数化查询不包含单引号。尝试：（

VALUES(?1, ?2)

不带 ?1 两边的引号）。否则（对于读者和解析器来说）很难判断您是否想要插入参数 1 还是文字值 ?1 。

您还应该检查 executeUpdate() 的返回值，看看它是否认为它影响了任何行。这可能会给你零，但无论如何它都值得检查。

最后，我认为日期需要特殊处理：

setParameter(1, new java.util.Date(), TemporalType.DATE);

这是因为 Java Date 对象根本不是日期，而是时间戳 - 您需要确保选择正确的时间对象类型，以便将正确的值放置在询问。

所以，简而言之，类似：

int affected = em.createNativeQuery(
    "INSERT INTO rst_offline_transaction_batch (" +
    "    created_date," +     // ?1
    "    user_id" +           // ?2
    ") VALUES (?1,?2)"
    )
    .setParameter(1, new java.util.Date(), TemporalType.DATE)
    .setParameter(2, user_id)
    .executeUpdate();
// Check affected.

You generally don't include the single quotes for parameterised queries. Try:

VALUES(?1, ?2)

(without the quotes around the ?1). Otherwise it's hard (for both readers and parsers) to tell whether you wanted parameter 1 or the literal value ?1 to be inserted.

You should also check the return value from executeUpdate() to see if it thinks it affected any rows. This will probably give you zero but it's worth checking anyway.

And, finally, I think dates require special handling as per:

setParameter(1, new java.util.Date(), TemporalType.DATE);

This is because the Java Date object is not a date at all but a timestamp - you need to ensure you select the correct temporal object type so that the right value is placed in the query.

So, in short, something like:

int affected = em.createNativeQuery(
    "INSERT INTO rst_offline_transaction_batch (" +
    "    created_date," +     // ?1
    "    user_id" +           // ?2
    ") VALUES (?1,?2)"
    )
    .setParameter(1, new java.util.Date(), TemporalType.DATE)
    .setParameter(2, user_id)
    .executeUpdate();
// Check affected.

回复收藏 0 原文

~没有更多了~