第四天的学习

1.查询、删除、更新数据库
select ‘ from student;
insert into student (name,password) values(‘123’,’xingming’);/查询
update student SET NAME=‘wanglaoshi’ WHERE ID=1 /更新
DELETE FROM student WHERE id=3; ／删除

2.模拟斗地主
1.准备一副牌（54）
list poker=new ArrayList<>();
//花色
／＊
String[] colors=new String[]{“黑桃”,”红桃”,”方块”,”梅花”}；
String[] number=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(“大王”)；
System.out.println(pokers);

//2.洗牌（打乱牌序）
Collections.shuffle(pokers) /静态 static
System.out.println(pokers); /写工具类
/ 调用类中方法的方式有两种

list dipai=new ArrayList<>();
Random random=new Random();
for(int i=0;i<3;i++){
int index=random.nextInt(bound:pokers.size()-1);//1-53的随机数
String pai=pokers.remove(index);
dipai.add(pai);
}
System.out.println(pokers);
System.out.println(dipai);

List lilaoshi=new ArrayList<>();
List wanglaoshi=new ArrayList<>();
List malaoshi=new ArrayList<>();
for(int i=0;i<pokers.size();i++){
String pai=pokers.get(i);
int mod=i%3; //取余数
if(mod0){
lilaoshi.add(pai);
}else if(mod1){
wanglaoshi.add(pai);
}else{
malaoshi.add(pai);
}
}
System.out.println(“lilaoshi: ”+lilaoshi);
System.out.println(“wanglaoshi: ”+wanglaoshi);
System.out.println(“malaoshi: ”+malaoshi);
int dizhu = rndom.nextint(3)
if (dizhu0){
lilaoshi.addAll(dipai);
}else if(dizhu1){
wanglaoshi.addAll(dipai);
}else{
malaoshi.addAll(dipai);
}
System.out.println(“lilaoshi: ”+lilaoshi);
System.out.println(“wanglaoshi: ”+wanglaoshi);
System.out.println(“malaoshi: ”+malaoshi);

     }

}

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

}