斗地主排序和音乐系统管理

1.斗地主排序

今天将斗地主拿到的牌进行排序，还是五个步骤：
1.拿到一副牌
2.洗牌
3.留3张牌
4.发牌
5.看牌
代码如下：

package com.zhongruan;

import java.util.*;
public class DouDiZhu2 {
public static void main(String[] args) {
    //1.拿到一副牌
    Map<Integer,String> poker=new HashMap<>();
    String[] nums={"A","2","3","4","5","6","7","8","9","10","J","Q","K"};

    String[] colors={"黑桃","红心","梅花","方块"};
    int index=0;
    for(String color:colors){
        for(String num:nums){
            String pai=color+num;
            index=index+1;
            poker.put(index,pai);
        }
    }
    System.out.println(index);
    index++;
    poker.put(index,"大王");
    index++;
    poker.put(index,"小王");
    System.out.println(poker);
    //2.洗牌
    List<Integer> pokerIndexs=new ArrayList<>();
    Set<Integer> integers = poker.keySet();
  //  System.out.println(integers);
    for(Integer i:poker.keySet()){
        pokerIndexs.add(i);
    }
    Collections.shuffle(pokerIndexs);
    System.out.println(pokerIndexs);
    //3.留3张牌
    Set<Integer> dipaiInds=new TreeSet<>();
    dipaiInds.add(pokerIndexs.remove(0));
    dipaiInds.add(pokerIndexs.remove(0));
    dipaiInds.add(pokerIndexs.remove(0));
    System.out.println(dipaiInds);
    System.out.println(pokerIndexs);
    //4.发牌
    Set<Integer> ct=new TreeSet<>();
    Set<Integer> wwc=new TreeSet<>();
    Set<Integer> sj=new TreeSet<>();
    for(int i=0;i <pokerIndexs.size();i++){
        int pi=pokerIndexs.get(i);
        int mod=i%3;
        if(mod==0){
            ct.add(pi);
        }else if(mod==1){
            wwc.add(pi);
        }else{
            sj.add(pi);
        }
    }
    System.out.println(ct);
    System.out.println(wwc);
    System.out.println(sj);
    //5.看牌
    look(poker,ct);
    look(poker,wwc);
    look(poker,sj);

}

public static void look(Map<Integer,String> poker,Set<Integer> indexs){
    List<String> p=new ArrayList<>();
    for(Integer i:indexs){
        String pai=poker.get(i);
        p.add(pai);
    }
    System.out.println(p);
     }
}

运行结果：

2.音乐系统管理

首先在mysql中创建Music数据库,选择表的列名、数据类型、长度（其中id设为主键，选择自增）

打开IDEA软件，创建保存文件夹zjgmworkspace
创建文件夹com和zhongruan
安装jar包，创建文件夹lib,复制粘贴架包，选择"Add as Library"

创建Text、DBUtil、Music文件

Test中代码：

 package com.zhongruan;
 import com.zhongruan.model.Music;
 import com.zhongruan.util.DBUtil;

 import java.sql.*;
 import java.util.ArrayList;
 import java.util.List;

import com.zhongruan.model.Music;
import com.zhongruan.util.DBUtil;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class Test {
public List<Music> findMusic(){
    ResultSet resultSet=null;
    PreparedStatement statement=null;
    Connection connection=null;
    List<Music>musics=new ArrayList<>();
    try {
        connection= DBUtil.getConnection();
        //System.out.println("创建连接成功");
        String sql="select * from music";
        statement=connection.prepareStatement(sql);
        resultSet=statement.executeQuery();
        while(resultSet.next()){
            Music music=new Music();
            music.setId(resultSet.getInt(1));
            music.setName(resultSet.getString(2));
            music.setAuthor(resultSet.getString(3));
            musics.add(music);
        }     
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        DBUtil.closeALL(resultSet,statement,connection);
    }
     return musics;
    }
    public static void main(String[] args){
       Test test=new Test();
       List<Music> music=test.findMusic();
       System.out.println(music);
    }
 }

DBUtil中代码：

package com.zhongruan.util;

import java.sql.*;

public class DBUtil {
public static Connection getConnection() throws ClassNotFoundException, SQLException{
    Class.forName("com.mysql.jdbc.Driver");
    Connection connection= DriverManager.getConnection("jdbc:mysql://localhost:3306/zjgm?characterEncoding=utf-8&user=root&password=123456");
    return connection;
}

public static void closeALL(ResultSet resultSet, Statement statement,Connection connection){
    if (resultSet!=null){
        try {
            resultSet.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    if (statement!=null){
        try {
            statement.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    if (connection!=null){
        try {
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
     }
  }
}

Music中代码：

package com.zhongruan.model;
public class Music {
public int id;
private String name;
private String author;

public int getId() {
    return id;
}

public void setId(int id) {
    this.id = id;
}

public String getName() {
    return name;
}

public void setName(String name) {
    this.name = name;
}

public String getAuthor() {
    return author;
}

public void setAuthor(String author) {
    this.author = author;
}

@Override
public String toString() {
    return "Music{" +
            "id=" + id +
            ", name='" + name + '\'' +
            ", author='" + author + '\'' +
            '}';
    }
}

运行结果：