音乐系统的增删改查（不完整版）

培训打卡
在musicservic中加入功能模块
基础的增删改查
if (flag) {
System.out.println("----登入成功----");
System.out.println("----欢迎来到音乐管理系统----");
System.out.println("\t1.音乐管理\t2.用户管理\t3.退出系统");
int j = input.nextInt( );
if (j == 1) {
System.out.println("-欢迎进入音乐管理系统-");
System.out.println("\t1.查询音乐\t2.添加音乐\t3.修改音乐\t4.删除音乐");
int a = input.nextInt( );
switch (a) {
case 1:
List musics = MusicDao.findAll();
System.out.println(musics);
break;
case 2:
System.out.println(“请输入要添加的音乐名:” );
String n=input.next();
System.out.println(“请输入作者” );
String au=input.next();
Music music=new Music();
music.setMusicname(n);
music.setAuthor(au);
MusicDao.add(music);
case 3:
System.out.println(3);
case 4:
System.out.println(“请输入要删除的歌曲的id”);
int id = input.nextInt( );
MusicDao.Delete(id);
break;
}
}
}

建新一个music类

package com.zhongruan.beam;

public class Music {
private int id;
private String musicname;
private String author;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getMusicname() {
return musicname;
}
public void setMusicname(String musicname) {
this.musicname = musicname;
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
@Override
public String toString() {
return “Music{” + “id=” + id + “, musicname=’” + musicname + ‘’’ + “, author=’” + author + ‘’’ + ‘}’;
}
}

再建新一个musicDao
这里面放增删改查

package com.zhongruan.dao;

import com.zhongruan.beam.Music;
import com.zhongruan.util.DBUtil;

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

public class MusicDao {
public static 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 static void Delete(int id) throws SQLException {
DBUtil dbUtil = new DBUtil( );
Connection connection = dbUtil.getConnection( );
int i = 0;
try{
String sql = “delete from music where id=?”;
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setInt(1, 1);
i = preparedStatement.executeUpdate( );
if (i != 0) {
System.out.println(“删除成功”);
} else {
System.out.println(“删除失败”);
}
}catch (SQLException e){
e.printStackTrace();
}
}
public static void add(Music music) throws SQLException {
Connection connection = DBUtil.getConnection( );
String sql = “insert into music( musicname,author) values (?,?)”;
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1,“123”);
preparedStatement.setString(2,“123”);
int resultSet = preparedStatement.executeUpdate( );
if (preparedStatement != null) {
System.out.println(“添加成功”);
}
}
public void update() throws SQLException {
Connection connection = DBUtil.getConnection();//创建连接
String sql=“update music set musicname=‘1’,author=‘1’ where id=1”;
PreparedStatement preparedStatement=connection.prepareStatement(sql);
int resultSet=preparedStatement.executeUpdate();
if(preparedStatement!=null){
System.out.println(“修改成功”);

    }
}

}

此处代码不完整，仅可借鉴
完整版等下次更新
白白~