初见音乐管理系统

学习JAVA的第八天

今天开始我们就要开始写一个音乐管理系统

我们首先要建立一个项目，然后到入jar包，建立一个登陆用的数据库，先写界面类似于JDBC的登陆界面，昨天我们完善了登陆和注册的步骤
代码如下

package com.nbufe.service;



import com.nbufe.dao.UserAdd;
import com.nbufe.dao.UserLogin;

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

public class MusicService {
    public static void main(String[] args) throws SQLException {
        System.out.println("************************************************");
        System.out.print("请输入用户名：");
        Scanner input=new Scanner(System.in);
        String username=input.next();
        System.out.println("************************************************");
        System.out.print("请输入密码：");
        String password=input.next();
        System.out.println("************************************************");
        boolean login=UserLogin.login(username,password);
        if(login)
        {
            System.out.println("登陆成功");
            System.out.println("************************************************");
            System.out.println("*************欢迎来到音乐管理系统***************");
            System.out.println();

        }
        else
        {
            System.out.println("登陆失败");
            System.out.println("************************************************");
            System.out.println("请先注册");
            System.out.println("************************************************");
            System.out.print("请输入注册名");
            String zcusername=input.next();
            System.out.println("************************************************");
            System.out.print("请输入密码");
            String zcpassword1=input.next();
            String zcpassword2;
            System.out.println("************************************************");
            do {
                System.out.print("请再次输入密码");
                zcpassword2=input.next();
                if(zcpassword1.equals(zcpassword2))
                {
                    break;
                }
                System.out.println("************************************************");
            }while(true);
            if(UserAdd.add(zcusername,zcpassword1))
            {
                System.out.println("添加成功");
                System.out.println("************************************************");
            }
            else
            {
                System.out.println("添加失败");
                System.out.println("************************************************");
            }


        }

    }
}

package com.nbufe.dao;



import com.nbufe.util.DBUtil;

import java.sql.*;

public class UserLogin {
    public static boolean login(String username,String password) throws SQLException {
        Connection connection = DBUtil.getconnection();
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;



            String sql = "select * from musicuser where username=? and password=?";
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1, username);
            preparedStatement.setString(2, password);
            resultSet = preparedStatement.executeQuery();
            if (resultSet.next())
            {
                return  true;
            }
            else
                {
                return false;
                }



    }
}

package com.nbufe.dao;

import com.nbufe.util.DBUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class UserAdd {
    public static boolean add(String username,String password) throws SQLException {
        Connection connection = DBUtil.getconnection();
        PreparedStatement preparedStatement = null;
        int resultSet = 0;
        String sql = "insert into musicuser(username,password) value (?,?)";
        preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setString(1, username);
        preparedStatement.setString(2, password);
        resultSet=preparedStatement.executeUpdate();
        if(resultSet==1)
        {
            return true;
        }else
        {
            return false;

        }
    }
}

package com.nbufe.bean;

public class User {
    private int id;
    private String username;
    private String password;

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                '}';
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

建立的两个工具类用来连接数据库和关闭资源

package com.nbufe.util;

import java.sql.*;

public class DBUtil {
    public static Connection getconnection() {
        Connection connection=null;

        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        try {
            connection= DriverManager.getConnection
                    ("jdbc:mysql://127.0.0.1:3306/nbufe?useSSL=true&characterEncoding=utf-8&user=root&password=123");
            System.out.println("创建连接成功");
            System.out.println("************************************************");


        } catch (SQLException e) {
            e.printStackTrace();
        }


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



    }
}