20190917音乐系统初片

次篇：
数组 和集合的区别：
1.数组大小是固定的 集合不是固定的
2.数组只能放一种类型的数据 集合可以放多种类型的数据。

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

list
arraylist 数组list 查询快 删除和添加 慢
linkedlist 添加和删除快 查询慢

set treeset 通过树状保存数据

异常和错误
1.运行时异常 可以不处理 jvm虚拟机处理
2.编译异常 一定要处理

处理异常的2中方式：
1.try catch 自己处理
2.throws 给调用者处理

自定义异常
实体类：与数据库 对象
1.构造方法 2.属性3.get set 4.toString

分层
1.model 实体类
2.dao 持久层 对数据库操作 增删改查

主
package com.zhongruan;

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

import java.sql.SQLException;
import java.util.List;
import java.util.Scanner;

public class Test {
/*public static void main(String[] args) throws SQLException, ClassNotFoundException {
MusicDao musicDao=new MusicDao();
List musics=musicDao.findMusics();
System.out.println(musics);

    try {
        //musicDao.delete(1);
        //musicDao.insert(3);
        musicDao.update(3);
    } catch (SQLException e) {
        e.printStackTrace();
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }


}*/
public static void main(String[] args) throws SQLException, ClassNotFoundException {
    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);*/

   //改
   System.out.println("请输入要修改的ID：");
   Scanner input=new Scanner(System.in);
   int id=input.nextInt();
   System.out.println("请输入新的书名：");
   String name=input.next();
   System.out.println("请输入新的作者：");
   String author=input.next();
   musicDao.update(id,name,author);
   List<Music> musics=musicDao.findMusics();
   System.out.println(musics);





}

}

次
共用
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/zjgm?user=root&password=123456&characterEncoding=utf-8&useSSL=true”);
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();
}
}
}

}

model
package com.zhongruan.model;

public class Music {
private 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 + '\'' +
            '}';
}

}

dao
package com.zhongruan.dao;

import com.zhongruan.model.Music;
import com.zhongruan.util.DButil;

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() throws SQLException, ClassNotFoundException {
ResultSet resultSet =null;
PreparedStatement statement=null;
Connection connection =null;
List musics=new ArrayList<>();
try {
connection= DButil.getConnection();
//写SQL
String sql=“select * from music”;
//得到sratment对象
statement=connection.prepareStatement(sql);
//执行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 void delete(int id) throws SQLException, ClassNotFoundException {
    Connection connection= DButil.getConnection();
    String sql="delete from music where id= ?";
    PreparedStatement statement = connection.prepareStatement(sql);
    statement.setInt(1,id);
    statement.executeUpdate();
    DButil.closeAll(null,statement,connection);
}
//增
public void charu(String name,String author) throws SQLException, ClassNotFoundException {
    Connection connection= DButil.getConnection();
    String sql="insert into music(name,author) values (?,?)";
    PreparedStatement statement = connection.prepareStatement(sql);
    statement.setString(1,name);
    statement.setString(2,author);
    //statement.setInt(1,id);
    statement.executeUpdate();
    DButil.closeAll(null,statement,connection);
}

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