From d75d7d7d76fe16e133f793cc31bfaea17a10cd24 Mon Sep 17 00:00:00 2001 From: wuyouming666 <2265557248@qq.com> Date: 星期一, 27 十一月 2023 13:39:59 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/CanadaMes --- springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java | 13 ++++++++----- 1 files changed, 8 insertions(+), 5 deletions(-) diff --git a/springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java b/springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java index 0ca1741..f032d87 100644 --- a/springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java +++ b/springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java @@ -9,6 +9,7 @@ import org.springframework.stereotype.Component; import com.example.springboot.entity.Glass; +import com.example.springboot.entity.north_glass_buffer1; @Component public class JdbcConnections { /** @@ -24,17 +25,17 @@ private static PreparedStatement ps = null; private static ResultSet rs = null; - public Glass selectGlass(int glassid) throws SQLException { + public north_glass_buffer1 selectGlass(int glassid) throws SQLException { conn = getConn(); - Glass glass=new Glass(); - String sql = "select orderid from glass where glassid=?"; + north_glass_buffer1 glass=new north_glass_buffer1(); + String sql = "select ordernumber from north_glass_buffer1 where glassid=?"; ps = conn.prepareStatement(sql); ps.setInt(1, glassid); rs= ps.executeQuery(); while (rs.next()) { - glass.setOrderId(rs.getShort("orderid")); + glass.setordernumber(rs.getString("ordernumber")); } - + conn.close(); return glass; } /** @@ -67,4 +68,6 @@ e.printStackTrace(); } } + + } -- Gitblit v1.8.0