list和set的区别 异常 键盘的增删改查

集合分为两种
List a=new ArrayList ArrayList 通过数组的方式进行存储：查询快，增删慢的特点，但是他的效率高
List b=new LinkedList LinkedList链表 插入快，查询慢

String[] a=new String{‘a’,2,3,4,5}

String[] b=new String[4];

数组和集合的区别
1.数组的长度是固定的，集合长度不是固定的
2.数组只能放一种类型，集合可以放多种类型

list和set的区别
1.list有序可重复
2.set无序不可重复

异常和错误
1.运行时异常 可以不处理 jvm虚拟机 处理
2.编译异常 必须要处理
处理异常的2种方式：
1.try catch 自己处理
2.throws 给调用者处理

DBUill.java
增删改查都是这个代码
package com.zhongruan.utill;

import java.sql.*;

public class DBUill {
public static Connection getConnection() throws ClassNotFoundException, SQLException {
Class.forName(“com.mysql.jdbc.Driver”);
Connection connection = DriverManager.getConnection(“jdbc:mysql://localhost/zjgm?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();
        }
    }
}

}

MusicDao.java
只是查询
package com.zhongruan.dao;
import com.zhongruan.model.Music;
import com.zhongruan.utill.DBUill;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class MusicDao {
public List findMusics(){
//查询
ResultSet resultSet = null;
PreparedStatement statement = null;
Connection connection = null;
List musics=new ArrayList<>();
try {
connection = DBUill.getConnection();
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 {
DBUill.closeAll(resultSet,statement,connection);
}
return musics;
}
}
//插入
public void charu(String name,String author){
ResultSet resultSet = null;
PreparedStatement statement = null;
Connection connection = null;
List musics=new ArrayList<>();
try {
connection= DBUill.getConnection();
String sql=“insert into music(name,author) values (?,?)”;
statement=connection.prepareStatement(sql);
statement.setString(1,name);
statement.setString(2,author);
statement.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}finally {
DBUill.closeAll(resultSet,statement,connection);

    }
}

//删除
public void delete(int id) throws SQLException, ClassNotFoundException {
Connection connection=DBUill.getConnection();
String sql=“delete from music where id=?”;
PreparedStatement statement=connection.prepareStatement(sql);
statement.setInt(1,id);
statement.executeUpdate();
DBUill.closeAll(null,statement,connection);
}

//修改
public static void updateMusic(int id,String newname,String author) throws SQLException, ClassNotFoundException {
Connection connection=DBUill.getConnection();
String sql=“update music set name=?, author=? where id=?”;
PreparedStatement statement=connection.prepareStatement(sql);
statement.setString(1,newname);
statement.setString(2,author);
statement.setInt(3,id);
statement.executeUpdate();
DBUill.closeAll(null,statement,connection);
}

package com.zhongruan;

import com.zhongruan.dao.MusicDao;
import com.zhongruan.model.Music;
import com.zhongruan.utill.DBUill;

Test.java

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

public class Test {

public static void main(String[] args) throws SQLException, ClassNotFoundException {
    //查询
     MusicDao musicDao=new MusicDao();
     Scanner input=new Scanner(System.in);
     List<Music> musics=musicDao.findMusics();
      System.out.println(musics);
      //添加
     MusicDao musicDao=new MusicDao();
    System.out.println("请输入音乐名：");
     Scanner input=new Scanner(System.in);
    String name=input.next();
    System.out.println("请输入作者：");
    String author=input.next();
    musicDao.charu(name,author);
    List<Music> musics=musicDao.findMusics();
   System.out.println(musics);
   //删除
   MusicDao musicDao=new MusicDao();
   Scanner input=new Scanner(System.in);
   System.out.println("删除某个音乐的ID");
    int id=input.nextInt();
    try {
        musicDao.delete(id);
    } catch (SQLException e) {
        e.printStackTrace();
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }
    List<Music> musics=musicDao.findMusics();
      System.out.println(musics);

//修改

    MusicDao musicDao=new MusicDao();
    Scanner input=new Scanner(System.in);
    System.out.println("请输入某个要修改的的ID");
    int id1=input.nextInt();
    String huche=input.nextLine();
    System.out.println("请输入新的歌名");
    String name1=input.nextLine();
    System.out.println("请输入新的作者");
    String author1=input.nextLine();
    MusicDao.updateMusic(id1,name1,author1);
      List<Music> musics=musicDao.findMusics();
      System.out.println(musics);





}

}