8.16总结

DBUtil .java
package Music.ruanjian.util;

import java.sql.*;

public class DBUtil {
public static Connection getconnection() {
Connection connection = null;
try {
Class.forName(“com.mysql.jdbc.Driver”);
connection = DriverManager.getConnection(“jdbc:mysql://127.0.0.1:3306/nbcj?useSSL=true&characterEncoding=utf-8&user=root&password=123456”);
System.out.println("|------------------创建连接成功!------------------|");
} catch (SQLException e) {
e.printStackTrace();
}
return connection;
}

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

MusicDao.java
package Music.ruanjian.dao;
import Music.ruanjian.bean.Music;
import Music.ruanjian.util.DBUtil;

import java.net.ConnectException;
import java.security.PublicKey;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

public class MusicDao {
public List findAll() throws SQLException {
List musics=new ArrayList<>();
Connection connection =DBUtil.getconnection();
PreparedStatement statement = connection.prepareStatement(“select * from music”);
ResultSet resultSet=statement.executeQuery();
while(resultSet.next()){
int id=resultSet.getInt(1);
String musicname=resultSet.getString(2);
String author=resultSet.getString(3);
Music music=new Music();
music.setId(id);
music.setMusicname(musicname);
music.setAuthor(author);
musics.add(music);
}
return musics;
}
public void add(Music music) throws SQLException {
Connection connection = DBUtil.getconnection();
PreparedStatement statement = connection.prepareStatement(“insert into music (musicname,author) values (?,?)”);
statement.setString(1, “123”);
statement.setString(2, “123”);
statement.executeUpdate();
}

public void  delete(int id) throws SQLException {
        PreparedStatement statement=null;
        Connection connection=null;
        connection=DBUtil.getconnection();
        int i=0;
        try {
            statement=connection.prepareStatement(“delete from music where id=?”);
            statement.setInt(1, id);
            i = statement.executeUpdate();
            if (i != 0) {
                System.out.println("|-------------------删除成功!--------------------|");
            } else {
                System.out.println("|-------------------删除失败!--------------------|");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
    }
}