Merge branch 'master' of http://10.153.19.25:10101/r/CanadaMes

ZengTao

2024-05-08 9472449b4ca46f482d13b6e628660c61101b443f

 springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java

@@ -12,6 +12,7 @@

import com.example.springboot.entity.Queue;
import com.example.springboot.entity.north_glass_buffer1;

@Component
public class JdbcConnections {
    /**
@@ -28,6 +29,7 @@
   private static ResultSet rss = null;
   
   public  north_glass_buffer1 selectGlass(int glassid) throws SQLException {
      try {
        Connection conn = getConn();
        north_glass_buffer1 glass=new north_glass_buffer1();
        String sql = "select ordernumber from north_glass_buffer1 where glassid=?";
@@ -39,9 +41,18 @@
         }
       conn.close();
         return glass;
      } catch (Exception e) {
         // TODO: handle exception
         e.printStackTrace();
         return null;
    }

   public  north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameId(String glassid,String orderid,String frameid) throws SQLException {
   }

   public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameId(String glassid, String orderid, String frameid)
         throws SQLException {

      try {
        Connection 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=?";
@@ -68,9 +79,17 @@
         }
       conn.close();
         return north_glass_buffer1s;
      } catch (Exception e) {
         // TODO: handle exception
         e.printStackTrace();
         return null;
    }

   public  north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameIdout(String glassid,String orderid,String frameid) throws SQLException {
   }

   public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameIdout(String glassid, String orderid, String frameid)
         throws SQLException {
      try {
        Connection 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=?";
@@ -97,9 +116,17 @@
         }
       conn.close();
         return north_glass_buffer1s;
      } catch (Exception e) {
         // TODO: handle exception
         e.printStackTrace();
         return null;
    }

   public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameIdouts(String glassid,String orderid,String frameid) throws SQLException {
   }

   public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameIdouts(String glassid, String orderid, String frameid)
         throws SQLException {
      try {
        Connection 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=?";
@@ -126,9 +153,17 @@
         }
       conn.close();
         return north_glass_buffer1s;
      } catch (Exception e) {
         // TODO: handle exception
         e.printStackTrace();
         return null;
    }

   public  north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameIdplchold(String glassid,String orderid,String frameid) throws SQLException {
   }

   public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameIdplchold(String glassid, String orderid, String frameid)
         throws SQLException {
      try {
        Connection 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=?";
@@ -155,10 +190,18 @@
         }
       conn.close();
         return north_glass_buffer1s;
      } catch (Exception e) {
         // TODO: handle exception
         e.printStackTrace();
         return null;
      }

    }

   //根据玻璃id，订单id，铝框id查询客户玻璃信息
   public  Queue SelectGlassByGlassIdOrderIdFrameIdQueue(String glassid,String orderid,String frameid) throws SQLException {
   public Queue SelectGlassByGlassIdOrderIdFrameIdQueue(String glassid, String orderid, String frameid)
         throws SQLException {
      try {
        Connection conn = getConn();
        Queue queue=new Queue();
        String sql = "select * from north_glass_buffer1 where barcode=? or ordernumber=? or FrameBarcode=?";
@@ -185,12 +228,18 @@
         }
       conn.close();
         return queue;
      } catch (Exception e) {
         // TODO: handle exception
         e.printStackTrace();
         return null;
    }

	
   }

   //根据玻璃id，订单id，铝框id查询客户玻璃信息
   public  List<north_glass_buffer1> SelectGlassByGlassIdOrderIdFrameIds(String glassid,String orderid,String frameid) throws SQLException {
   public List<north_glass_buffer1> SelectGlassByGlassIdOrderIdFrameIds(String glassid, String orderid, String frameid)
         throws SQLException {
      try {
        Connection conn = getConn();
        // north_glass_buffer1 glass=new north_glass_buffer1();
      List<north_glass_buffer1> glass=new ArrayList<north_glass_buffer1>();
@@ -218,16 +267,22 @@
         north_glass_buffer1s.setdatecreated(rs.getString("datecreated"));
         north_glass_buffer1s.setFrameBarcode(rs.getString("FrameBarcode"));


         glass.add(north_glass_buffer1s);
         
         }
       conn.close();
         return glass;
      } catch (Exception e) {
         // TODO: handle exception
         e.printStackTrace();
         return null;
      }

    }

   //根据铝框id查询客户玻璃信息
   public  List<north_glass_buffer1> SelectGlassByGlassIdOrderIdFrameIdss(String frameid) throws SQLException {
      try {
        Connection conn = getConn();
        // north_glass_buffer1 glass=new north_glass_buffer1();
      List<north_glass_buffer1> glass=new ArrayList<north_glass_buffer1>();
@@ -253,16 +308,22 @@
         north_glass_buffer1s.setdatecreated(rs.getString("datecreated"));
         north_glass_buffer1s.setFrameBarcode(rs.getString("FrameBarcode"));


         glass.add(north_glass_buffer1s);
         
         }
       conn.close();
         return glass;
      } catch (Exception e) {
         // TODO: handle exception
         e.printStackTrace();
         return null;
      }

    }

   //根据铝框id查询l铝框是否翻转
   public String SelectFlipByFrameBarcode(String frameBarcode) throws SQLException {
      try {
      Connection conn = getConn();
        // north_glass_buffer1 glass=new north_glass_buffer1();
      String flip="";
@@ -276,9 +337,17 @@
         }
       conn.close();
         return flip;
      } catch (Exception e) {
         // TODO: handle exception
         e.printStackTrace();
         return null;
   }

   }

   //根据铝框id查询是否铝框摆放
   public String SelectPositionByFrameBarcode(String frameBarcode) throws SQLException {
      try {
      Connection conn = getConn();
        // north_glass_buffer1 glass=new north_glass_buffer1();
      String position="";
@@ -291,10 +360,17 @@
         }
       conn.close();
         return position;
      } catch (Exception e) {
         // TODO: handle exception
         e.printStackTrace();
         return null;
      }

    }

   //根据铝框id查询铝框宽
   public String SelectFrameLengthByFrameBarcode(String frameBarcode) throws SQLException {
      try {
      Connection conn = getConn();
        // north_glass_buffer1 glass=new north_glass_buffer1();
      String position="";
@@ -307,10 +383,17 @@
         }
       conn.close();
         return position;
      } catch (Exception e) {
         // TODO: handle exception
         e.printStackTrace();
         return null;
      }

    }

   //根据铝框id查询铝框高
   public String SelectFrameHeightByFrameBarcode(String frameBarcode) throws SQLException {
      try {
      Connection conn = getConn();
        // north_glass_buffer1 glass=new north_glass_buffer1();
      String position="";
@@ -323,6 +406,12 @@
         }
       conn.close();
         return position;
      } catch (Exception e) {
         // TODO: handle exception
         e.printStackTrace();
         return null;
      }

    }
   
   /**
@@ -343,10 +432,21 @@
    *     2. 查一组，做成一个对象列表，查全部
    */
   public static Connection getConn() throws SQLException {
      try {
      Connection conn = null;
      // conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/canadames?serverTimezone=GMT%2B8&characterEncoding=utf-8", "root", "beibo.123/");
      conn = DriverManager.getConnection("jdbc:mysql://192.168.102.9:3306/production?serverTimezone=GMT%2B8&characterEncoding=utf-8&useSSL=false", "northglass", "n0rthgla55");
         // conn =
         // DriverManager.getConnection("jdbc:mysql://localhost:3306/canadames?serverTimezone=GMT%2B8&characterEncoding=utf-8",
         // "root", "beibo.123/");
         conn = DriverManager.getConnection(
               "jdbc:mysql://192.168.102.9:3306/production?serverTimezone=GMT%2B8&characterEncoding=utf-8&useSSL=false",
               "northglass", "n0rthgla55");
      return conn;
      } catch (Exception e) {
         // TODO: handle exception
         e.printStackTrace();
         return null;
      }

   }

   static {
@@ -356,9 +456,5 @@
         e.printStackTrace();
      }
   }

    



}