音乐系统1

mvc
m model 实体类
v view 视图
c controller 控制

包结构
model 实体类
dao 持久层 对数据库进行操作 增删改查
service 业务层
controller 控制层

util 工具包

mvc
m model 实体类
v view 视图
c controller 控制

包结构
model 实体类
dao 持久层 对数据库进行操作 增删改查
service 业务层
controller 控制层

util 工具包

package ZhongRuan;

import ZhongRuan.dao.MusicDao;
import ZhongRuan.dao.UserDao;
import ZhongRuan.model.Music;
import ZhongRuan.model.User;
import javafx.fxml.LoadException;

import java.awt.*;
import java.sql.SQLException;
import java.util.List;
import java.util.Random;
import java.util.Scanner;

public class View {

public  static  void  main(String[] args) throws SQLException, ClassNotFoundException, LoadException {

Scanner input=new Scanner(System.in);
System.out.println("请输入用户名：");
String username =input.next();
System.out.println("请输入密码");
String password = input.next();
UserDao userDao = new UserDao();

User user = userDao.findUserByUsername(username);
if(user==null){
System.out.println("—该用户尚未注册，请先注册—");
System.out.println("—请输入注册名—");
String name = input.next();
System.out.println("—请输入注册密码–");
String pw = input.next();
userDao.charu(name,password);
}else if(user.getPassword().equals(password)){
System.out.println("—欢迎来到音乐系统----");
musicSystem(user);
}else {
System.out.println("—密码错误，请重新输入----");
throw new LoadException(“登入失败”);
}
}

public static void musicSystem(User user) throws SQLException, ClassNotFoundException {
Scanner input= new Scanner(System.in);

System.out.println(“1.音乐查询2.音乐添加3.音乐修改4.音乐删除”);

int choice=input.nextInt();
MusicDao musicDao=new MusicDao();
switch (choice){
    case  1:
        List<Music>musics = musicDao.findMusics();
        System.out.println(musics);

break;
case 2:

       if (user.getType()!=0){
           System.out.println("权限不足，请联系管理员");
           break;
        }
        System.out.println("请输入要插入的音乐名");
        String ym=input.next();
        System.out.println("请输入要插的作者名");
        String au = input.next();
     musicDao.charu(ym,au);
     break;
    case  3:
        System.out.println("请输入要删除的id");
        int id =input.nextInt();
        musicDao.delete(id);
        case 4:
            System.out.println("请输入新的id");
            int id1=input.nextInt();
            System.out.println("请输入音乐名");
            String newym=input.next();
            System.out.println("请输入新的作者名");
            String newau=input.next();
            MusicDao.upadateMusic(id1,newym,newau);
            break;
}

}

}
package ZhongRuan.dao;

import ZhongRuan.Util.Dbutil2;
import ZhongRuan.model.Music;
import ZhongRuan.model.User;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.concurrent.Callable;

public class UserDao {

public User findUserByUsername(String username) {

    ResultSet resultSet = null;
    Connection connection = null;
    PreparedStatement statement = null;
   User user=null;
    try {
        connection = Dbutil2.getConnection();

        String sql = "select * from tb_user where  username=?";
        statement = connection.prepareStatement(sql);

statement.setString(1,username);
//加
//String sql=“INSERT INTO stu(id,name,age)VALUES (8,‘erss’,977)”;
//PreparedStatement statement =connection.prepareStatement(sql);
//statement.executeUpdate();
//删除
//String sql = “DELETE FROM stu WHERE id = 2”;
//PreparedStatement statement =connection.prepareStatement(sql);
//statement.executeUpdate();
//ResultSet resultSet =statement.executeQuery();
//改
//String sql=“UPDATE stu SET name=99, age=99 WHERE id=1”;
//PreparedStatement statement =connection.prepareStatement(sql);
//statement.executeUpdate();
// String sql=“INSERT INTO music(name,age)VALUES (‘erss’,977)”;

        //preparedStatement statement1 =connection.prepareStatement(sql);
        //statement.executeUpdate();
        resultSet = statement.executeQuery();

        while (resultSet.next()) {
             user= new User();
          // user.setId(resultSet.getInt(1));
           user.setUsername(resultSet.getString(2));
            user.setPassword(resultSet.getString(3));
            user.setType(resultSet.getInt(4));

        }
        //System.out.println(musics);
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        Dbutil2.closeALL(resultSet,statement,connection);

    }

    return  user;

}
public static void charu(String newname,String password) throws SQLException, ClassNotFoundException {
    ResultSet resultSet=null;
    PreparedStatement statement=null;

Connection connection=null;
try {
connection = Dbutil2.getConnection();
String sql=“insert into tb_user(username,password)value (?,?)”;
statement = connection.prepareStatement(sql);
statement.setString(1,newname);
statement.setString(2,password);
// statement.setInt(3,id);
statement.executeUpdate();
}finally {
Dbutil2.closeALL(null,statement,connection);
}

}

}