创建order订单id号 mysql存储过程

最新推荐文章于 2025-01-12 00:06:12 发布

原创最新推荐文章于 2025-01-12 00:06:12 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

mysql 存储过程创建订单id 专栏收录该内容

1 篇文章

订阅专栏

本文介绍如何在Java中调用MySQL的存储过程来生成唯一的订单ID。通过建立连接，设置并执行存储过程，获取返回的订单ID字符串。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

BEGIN
START TRANSACTION;
   select last_time into @time from create_orderid;
   select num into @num from create_orderid;
select date_format(NOW(),'%Y%m%d') into @nowtime;

if STRCMP(@nowtime,@time)=0 THEN
     update create_orderid set num=num+1,id=concat(@time,num);
ELSE
     update create_orderid set num=1,id=concat(@nowtime,1),last_time=@nowtime;
end if;

select id into ids from create_orderid;
select ids from create_orderid;
COMMIT;

end

-----------------------------------------------------------------

java调用

// 获得订单id
   @SuppressWarnings("deprecation")
   public String getOrderId() {
       java.sql.Connection con = getSession().connection();
       String sql = "{call createOrId(?)}";// 调用存储过程
       CallableStatement cs;
       String name = "";
       try {
           cs = con.prepareCall(sql);
           cs.registerOutParameter(1, java.sql.Types.VARCHAR);
           cs.execute();
           name = cs.getString(1);
       } catch (SQLException e) {
           e.printStackTrace();
       }
       return name;
   }