java音乐管理系统增删改查代码及java连接数据库7步骤

Java音乐管理系统增删改查

package com.zhongruan.service;

import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

public class MusicService {
public static void main(String[] args) throws Exception{
while (true){
System.out.println("----------请输入用户名：----------");
Scanner input =new Scanner(System.in);
String username =input.next();
System.out.println("----------请输入密码：----------");
String password =input.next();
System.out.println(username+password);
UserDao.login(username,password);
boolean flag=Userbao.login(username,password);
if (flag)
{
System.out.println("----------登陆成功----------");
System.out.println("----------欢迎来到音乐管理系统----------");
System.out.println("/t1.音乐管理/t2.用户管理/t3.退出");
int i = input.nextInt();
if (i1){
System.out.println("----------欢迎来到音乐管理系统----------");
System.out.println("/t1.音乐查询/t2.音乐添加/t3.音乐删除/t4.修改音乐信息");
int j =input.nextInt();
if (j1){
System.out.println("----------欢迎来到音乐查询功能----------");
List music=new ArrayList();
music= MusicDao.yyfx();
System.out.println(music);
}
if (j3){
System.out.println(“输入要删除的歌名”);
String musicname =input.next();
boolean flag1=MusicDao.yysc(musicname);
if (flag1){
System.out.println(“删除成功”);
}else {
System.out.println(“库中无此歌”);
}
}
if(j2){
System.out.println(“输入添加的歌名”);
String musicname =input.next();
System.out.println(“请输入歌手”);
String singername=input.next();
boolean flag2=MusicDao.yytj(musicname,singername);
if (flag2)
{
System.out.println(“添加成功”);
}else{
System.out.println(“添加失败”);
}
}
if(j==4)
{
System.out.println(“请输入要修改的音乐名”);
String musicname =input.next();
System.out.println(“请输入要修改的歌手名”);
String singername =input.next();
System.out.println(“请输入要修改的id名”);
int id =input.nextInt();
boolean flag3=MusicDao.yyxg(musicname,singername,id);
if (flag3)
{
System.out.println(“修改成功”);
}else{
System.out.println(“修改失败”);
}
}
}

        }
        else
        {
            System.out.println("----------登录失败----------");
            System.out.println("----------用户注册----------");
            System.out.println("请输入注册名：");
            String zcm =input.next();
            System.out.println("请输入注册密码：");
            String mm =input.next();
            System.out.println("请确认密码：");
            String mm1 =input.next();
            if(mm.equals(mm1))
            {
                Userbao.zhuce(zcm,mm);
                System.out.println("是否登入还是退出");
                String i = input.next();
                if (i.equals("N")||i.equals("n")){
                    System.exit(0);
                }else  if(!i.equals("Y")||i.equals("y")){
                    System.out.println("hey！输错了~~~~");
                }
            }else
            {
                System.out.println("密码有误，请重新注册");
            }
        }
    }

}

}

java连接数据库 7步骤

package blackwhite.black;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

public class TestJdb1 {
public static void main(String[] args) throws Exception {
Connection connection = DBUtil.getConnection();
List<Class.Student> students=new ArrayList<>();
//3.写sql语句
String sql="select * from user ";
//4.得到statement对象
PreparedStatement preparedStatement = connection.prepareStatement(sql);
/* 5.执行sql得到结果集 */
ResultSet resultSet = preparedStatement.executeQuery();
//6.处理结果集
while (resultSet.next()){
Class.Student student=new Class.Student();
student.setId(resultSet.getInt(1));
student.setName(resultSet.getString(2));
student.setPassword(resultSet.getString(3));
students.add(student);
}
System.out.println(students);
//7.关闭资源
DBUtil.closeAll(resultSet,preparedStatement,connection);
}

}

The end ！

Thank watching ！