8.08

一、斗地主模拟程序
功能：
1.准备一幅牌(54张)
2.洗牌(打乱牌序)
3.发牌(三个人)
4.留三张底牌
5.每个人拿到牌后，对牌进行排序
6.出牌

public static void main(String[] args){
    List<String> pokers= new ArrayList<>();
    String[] colors= new String[]{"黑桃","红桃","方块","梅花"};
    String[] numbers=new String[]{"A","2","3","4","5","6","7","8","9","10","J","Q","K"};
    for(String color:colors){
        for(String number:numbers){
            String poker =number +color;
            pokers.add(poker);
        }
    }
    pokers.add("大王");
    pokers.add("小王");
    Collections.shuffle(pokers);
    System.out.println(pokers);

    List<String> dipai=new ArrayList<>();
    Random random = new Random();
    for(int i=0;i<3;i++){
        int index = random.nextInt(pokers.size()-1);
        String pai=pokers.remove(index);
        dipai.add(pai);
    }
    System.out.println(pokers);
    System.out.println(dipai);

    List<String> gamer1 = new ArrayList<>();
    List<String> gamer2 = new ArrayList<>();
    List<String> gamer3 = new ArrayList<>();
    for(int i =0;i<pokers.size();i++){
        String pai = pokers.get(i);
        int mod = i%3;
        if(mod ==0)
            gamer1.add(pai);
        else if (mod==1)
            gamer2.add(pai);
        else
            gamer3.add(pai);
    }
    System.out.println("gamer1: " + gamer1);
    System.out.println("gamer2: " + gamer2);
    System.out.println("gamer3: " + gamer3);

    int dizhu = random.nextInt(3);
    if(dizhu==0){
        gamer1.addAll(dipai);
    }else if (dizhu==1){
        gamer2.addAll(dipai);
    }else if (dizhu==2){
        gamer3.addAll(dipai);
    }
    System.out.println("gamer1: " + gamer1);
    System.out.println("gamer2: " + gamer2);
    System.out.println("gamer3: " + gamer3);
}

结果如下图：

二、jdbc连接
连接步骤：

1. 加载驱动 （需要下载jar包并导入包）
2. 创建连接
3. 写sql语句
4. 得到statement对象
5. 执行sql得到结果集
6. 处理结果集
7. 关闭资源

public static void main(String[] args) throws Exception {
        //1.加载驱动
        Class.forName("com.mysql.jdbc.Driver");
        //2.创建连接
        Connection connection = DriverManager.getConnection
                ("jdbc:mysql://127.0.0.1:3306/nbcj?useSSL=true&characterEncoding=utf-8&user=root&password=123456");
        System.out.println("创建连接成功");
        //3.写sql语句
        String sql = "";
        //4.得到statement对象
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        //5.执行sql得到结果集
        ResultSet resultSet=preparedStatement.executeQuery();
        //6.处理结果集
        while (resultSet.next()){
            System.out.println(resultSet.getInt(1));
            System.out.println(resultSet.getString(2));
            System.out.println(resultSet.getString(3));
        }
        //7.关闭资源
    }

结果如下图：