From dc31792dc1b8ad1658e49ba8fce9a1be924e6fbb Mon Sep 17 00:00:00 2001 From: wu <731351411@qq.com> Date: 星期四, 30 十一月 2023 08:44:04 +0800 Subject: [PATCH] 理片笼测试修改 --- springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java | 98 +++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 98 insertions(+), 0 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 f032d87..204a419 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 @@ -5,10 +5,13 @@ import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; +import java.util.ArrayList; +import java.util.List; import org.springframework.stereotype.Component; import com.example.springboot.entity.Glass; +import com.example.springboot.entity.Queue; import com.example.springboot.entity.north_glass_buffer1; @Component public class JdbcConnections { @@ -38,6 +41,101 @@ conn.close(); return glass; } + + public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameId(String glassid,String orderid,String frameid) throws SQLException { + conn = getConn(); + north_glass_buffer1 north_glass_buffer1s=new north_glass_buffer1(); + String sql = "select * from north_glass_buffer1 where barcode=? or ordernumber=? or FrameBarcode=?"; + ps = conn.prepareStatement(sql); + ps.setString(1, glassid); + ps.setString(2, orderid); + ps.setString(3, frameid); + rs= ps.executeQuery(); + while (rs.next()) { + north_glass_buffer1s.setId(rs.getInt("Id")); + north_glass_buffer1s.setordernumber(rs.getString("ordernumber")); + north_glass_buffer1s.setlistnumber(rs.getString("listnumber")); + north_glass_buffer1s.setboxnumber(rs.getString("boxnumber")); + north_glass_buffer1s.setbarcode(rs.getString("barcode")); + north_glass_buffer1s.setglasslength(rs.getDouble("glasslength")); + north_glass_buffer1s.setglassheight(rs.getDouble("glassheight")); + north_glass_buffer1s.setglasslengthmm(rs.getDouble("glasslength_mm")); + north_glass_buffer1s.setglassheightmm(rs.getDouble("glassheight_mm")); + north_glass_buffer1s.setitemtype(rs.getString("itemtype")); + north_glass_buffer1s.setslotnumber(rs.getString("slotnumber")); + north_glass_buffer1s.setdatemodified(rs.getString("datemodified")); + north_glass_buffer1s.setdatecreated(rs.getString("datecreated")); + north_glass_buffer1s.setFrameBarcode(rs.getString("FrameBarcode")); + } + // conn.close(); + return north_glass_buffer1s; + } + //鏍规嵁鐜荤拑id锛岃鍗昳d锛岄摑妗唅d鏌ヨ瀹㈡埛鐜荤拑淇℃伅 + public Queue SelectGlassByGlassIdOrderIdFrameIdQueue(String glassid,String orderid,String frameid) throws SQLException { + conn = getConn(); + Queue queue=new Queue(); + String sql = "select * from north_glass_buffer1 where barcode=? or ordernumber=? or FrameBarcode=?"; + ps = conn.prepareStatement(sql); + ps.setString(1, glassid); + ps.setString(2, orderid); + ps.setString(3, frameid); + rs= ps.executeQuery(); + while (rs.next()) { + queue.setid(rs.getInt("Id")); + queue.setorderId(rs.getString("ordernumber")); + queue.setlistId(rs.getString("listnumber")); + queue.setboxId(rs.getString("boxnumber")); + queue.setglassId(rs.getString("barcode")); + queue.setglasswidthmm(rs.getDouble("glasslength")); + queue.setglassheightmm(rs.getDouble("glassheight")); + queue.setglasswidth(rs.getDouble("glasslength_mm")); + queue.setglassheight(rs.getDouble("glassheight_mm")); + // queue.setitemtype(rs.getString("itemtype")); + // queue.setslotnumber(rs.getString("slotnumber")); + // queue.setdatemodified(rs.getString("datemodified")); + // queue.setdatecreated(rs.getString("datecreated")); + // queue.setFrameBarcode(rs.getString("FrameBarcode")); + } + // conn.close(); + return queue; + } + + public List<north_glass_buffer1> SelectGlassByGlassIdOrderIdFrameIds(String glassid,String orderid,String frameid) throws SQLException { + conn = getConn(); + // north_glass_buffer1 glass=new north_glass_buffer1(); + List<north_glass_buffer1> glass=new ArrayList<north_glass_buffer1>(); + String sql = "select * from north_glass_buffer1 where position(? in barcode) and position(? in ordernumber) and position(? in FrameBarcode)"; + ps = conn.prepareStatement(sql); + ps.setString(1, glassid); + ps.setString(2, orderid); + ps.setString(3, frameid); + rs= ps.executeQuery(); + while (rs.next()) { + north_glass_buffer1 north_glass_buffer1s=new north_glass_buffer1(); + + north_glass_buffer1s.setId(rs.getInt("Id")); + north_glass_buffer1s.setordernumber(rs.getString("ordernumber")); + north_glass_buffer1s.setlistnumber(rs.getString("listnumber")); + north_glass_buffer1s.setboxnumber(rs.getString("boxnumber")); + north_glass_buffer1s.setbarcode(rs.getString("barcode")); + north_glass_buffer1s.setglasslength(rs.getDouble("glasslength")); + north_glass_buffer1s.setglassheight(rs.getDouble("glassheight")); + north_glass_buffer1s.setglasslengthmm(rs.getDouble("glasslength_mm")); + north_glass_buffer1s.setglassheightmm(rs.getDouble("glassheight_mm")); + north_glass_buffer1s.setitemtype(rs.getString("itemtype")); + north_glass_buffer1s.setslotnumber(rs.getString("slotnumber")); + north_glass_buffer1s.setdatemodified(rs.getString("datemodified")); + north_glass_buffer1s.setdatecreated(rs.getString("datecreated")); + north_glass_buffer1s.setFrameBarcode(rs.getString("FrameBarcode")); + + + glass.add(north_glass_buffer1s); + + } + // conn.close(); + return glass; + } + /** * 1. 鍔犺浇椹卞姩 * 2. 鑾峰彇杩炴帴 conn -- Gitblit v1.8.0