java干货——一键导入QQ群里的QQ号

1、打开Q群空间

2、打开最右上角的群人数

3、复制QQ号码到txt文件中

4、把群主和管理员的字去掉

5、执行java的main方法

try {
            String encoding="UTF-8";
            File file=new File(filePath);
            if(file.isFile() && file.exists()){ 
                InputStreamReader read = new InputStreamReader(
                        new FileInputStream(file),encoding);
                BufferedReader bufferedReader = new BufferedReader(read);
                String lineTxt = null;
                String qqName = "";
                String qqNum = "";      
                while((lineTxt = bufferedReader.readLine()) != null){
                    if(!lineTxt.equals("")){
                        if(lineTxt.startsWith("(")){
                            lineTxt = lineTxt.replace("(", "");
                            lineTxt = lineTxt.replace(")", "");
                            qqNum = lineTxt;

                            Connection con = dbUtil.getConnection(); // 获取连接
                            String sql = "insert into qqnum values(?,?,?,?,now(),1)";
                            PreparedStatement pstmt = con.prepareStatement(sql);
                            pstmt.setString(1, UUID.randomUUID().toString());
                            pstmt.setString(2, qqName);
                            pstmt.setString(3, qqNum);
                            pstmt.setString(4, search);
                            int result = pstmt.executeUpdate();
                            dbUtil.closeResources(con, pstmt, null);
                            if(result==1){
                                System.out.println("添加"+qqNum+"成功！");
                            }else{
                                System.out.println("添加"+qqNum+"失败！");
                            }
                        }else{
//                          qqName = lineTxt;
                            qqName = new String(lineTxt.getBytes("gb2312"),"gbk");
                        }
                    }
                }
                read.close();
            }else{
                //System.out.println("找不到指定的文件");
                throw new Exception("找不到指定的文件");
            }
        } catch (Exception e) {
            throw new Exception("读取文件内容出错");
        }

6、数据库的数据

全CSDN的丰（好）色（se）博客，这里有书本看不到的Java技术，电影院禁播的电影，欢迎关注QQ群494808400