Result结果集转换为数组

最新推荐文章于 2023-04-20 16:14:31 发布

wxm192939

最新推荐文章于 2023-04-20 16:14:31 发布

阅读量649

点赞数 1

分类专栏： MySql # javase基础知识

本文链接：https://blog.csdn.net/weixin_42365095/article/details/118462740

版权

javase基础知识同时被 2 个专栏收录

17 篇文章 0 订阅

订阅专栏

MySql

8 篇文章 0 订阅

订阅专栏

        List<String> list=new ArrayList<>();
        List<String> list1=new ArrayList<>();

        try {
            Connection connection=test.getConnection();
            //创建statement对象
            //插入
            String sql1 = "SELECT * FROM tb_shengchanjihua where JiHuaHao=?";
            PreparedStatement ptmt1 = conn.prepareStatement(sql1);
            ptmt1.setString(1,s);
            ResultSet rs1 = ptmt1.executeQuery();
            if(!rs1.next()){
                insert(b);
            }
               //更新
               String sql = "SELECT JiHuaHao FROM tb_shengchanjihua ";
               PreparedStatement ptmt = conn.prepareStatement(sql);
               //ptmt.setString(1,s);
               ResultSet rs = ptmt.executeQuery();
               while(rs.next()){
                   list.add(rs.getString(1));
               }

               String jihuahao[] = (String[])list.toArray(new String[list.size()]);
               for(int ji=0;ji<jihuahao.length;ji++){
                   if(jihuahao[ji].equals(s)){
                       update(b,ji+1);
                   }
               }
       //刪除

            String sql2 = "SELECT JiHuaHao FROM tb_shengchanjihua ";
            PreparedStatement ptmt2 = conn.prepareStatement(sql2);
            ResultSet rs2 = ptmt2.executeQuery();
            while(rs2.next()){
                list1.add(rs2.getString(1));
            }
            String str="00000000";

            String jihuahao1[] = (String[])list1.toArray(new String[list1.size()]);
            for(int ji=0;ji<jihuahao1.length;ji++){
                if(jihuahao1[ji].equals(str)){
                   delete(ji+1);
                }
            }

        } catch (SQLException es) {
            es.printStackTrace();
        }
    }