学习java第七天

音乐系统
主页

	    package com.zhongruan.service;
	    
	    import com.zhongruan.dao.UserDao;
	    import com.zhongruan.util.DBUtil;
	    import javafx.scene.input.InputEvent;
	    
	    import java.sql.Connection;
	    import java.sql.PreparedStatement;
	    import java.sql.SQLException;
	    import java.util.Collections;
	    import java.util.Scanner;
	    
	    public class MusicService {
	        public static void main (String[] arge) throws SQLException {
	            Connection connection= DBUtil.getConnection();
	            PreparedStatement statement =null;
	    
	    
	    
	            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 userDao =new UserDao();
	            boolean flag = userDao.login(username,password);
	            if(flag){
	                System.out.println("-----------登录成功----------");
	                System.out.println("-----------欢迎来到音乐管理系统--------");
	    
	            }
	            else{
	                System.out.println("登录失败");
	                System.out.println("请先注册");
	                System.out.println("请输入注册名");
	               String zhuce= input.next();
	                System.out.println("请输入注册密码");
	               String zcmm =input.next();
	                System.out.println("请确认密码");
	                String zcmm2 =input.next();
	                if(zcmm.equals(zcmm2)){
	                    userDao.zhuce(username,password);
	                    System.out.println("注册成功");
	                }
	                else{
	                    System.out.println("密码有误，请重新注册");
	                }
	    
	            }
	    
	    
	    
	        }
	    }

工具类

	    package com.zhongruan.util;
	    
	    import java.io.IOException;
	    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");
	          }catch (Exception e){
	              e.printStackTrace();
	          }
	      return  connection;
	      }
	        public static void closeAll(ResultSet resultSet, PreparedStatement statement,Connection connection){
	      if(resultSet!=null){
	          try {
	              resultSet.close();
	          }catch (SQLException e){
	              e.printStackTrace();
	          }
	      }
	            if(statement!=null){
	                try {
	                    statement.close();
	                }catch (SQLException e){
	                    e.printStackTrace();
	                }
	            }
	            if(connection!=null){
	                try {
	                    connection.close();
	                }catch (SQLException e){
	                    e.printStackTrace();
	                }
	            }
	    
	        }
	    }
	   密码账户  
		     package com.zhongruan.dao;
		    
		    import com.zhongruan.util.DBUtil;
		    import java.util.Scanner;
		    import java.sql.*;
		    import java.util.Collections;
		    
		    public class UserDao {
		    
		    
		        public boolean login(String username, String password) throws SQLException {
		            Connection connection = DBUtil.getConnection();
		            ResultSet resultSet = null;
		            PreparedStatement statement = null;
		    
		    
		                String sql = "select *from tb_user where username =? and password=?";
		                statement = connection.prepareStatement(sql);
		                statement.setString(1, username);
		                statement.setString(2, password);
		                resultSet = statement.executeQuery();
		                if (resultSet.next()) {
		                    return  true;
		                }
		                else {
		                    return  false;
		                }
		    用户类

	

	    package com.zhongruan.bean;
	    		
	    		public class User {
	    		    private  int id;
	    		    private  String username;
	    		    private String possword;
	    		    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 getPossword() {
	    		        return possword;
	    		    }
	    		
	    		    public void setPossword(String possword) {
	    		        this.possword = possword;
	    		    }
	    		
	    		    @Override
	    		    public String toString() {
	    		        return "User{" +
	    		                "id=" + id +
	    		                ", username='" + username + '\'' +
	    		                ", possword='" + possword + '\'' +
	    		                '}';
	    		    }
	    		}