学习java第11天

  音乐系统权限
		      static boolean longin2() throws SQLException {
		        List<User> users = new ArrayList<>();
		        ResultSet resultSet = null;
		        Connection connection = null;
		        PreparedStatement statement = null;
		        connection = DBUtil.getConnection();
		        try {
		            statement = connection.prepareStatement("select *from tb_user");
		            resultSet = statement.executeQuery();
		            while (resultSet.next()) {
		
		                int id = resultSet.getInt(1);
		                String username = resultSet.getString(2);
		                String password = resultSet.getString(3);
		                int type = resultSet.getInt(4);
		                if (id == 0) {
		                    return false;
		                }
		            }
		        } catch (SQLException e) {
		            e.printStackTrace();
		        }
		        return true;
		    }
					}
			public class Delete {
			public static void delete(int id) throws Exception {
			    Scanner input = new Scanner(System.in);
			    Connection connection = null;
			    connection = DBUtil.getConnection();
			    PreparedStatement preparedStatement = null;
			    if(longin2()){
			        try {
			
			            preparedStatement = connection.prepareStatement("delete from  music where id=?");
			            preparedStatement.setInt(1, id);
			            int i = preparedStatement.executeUpdate();
			            if (i != 0) {
			                System.out.println("删除成功");
			
			                jiemian();
			            } else {
			                System.out.println("你没有权限");
			            }
			
			        } catch (SQLException e) {
			            e.printStackTrace();
			        } finally {
			            jiemian();
			        }
			    }
			    else  {
			        System.out.println("不是管理员，不能删除");
			            System.out.println("请按1返回");
			            int i = input.nextInt();
			            if(i==1){
			                jiemian();
			            }else{
			                System.out.println("输入错误，请重新输入");
			                int j =input.nextInt();
			                jiemian();
			        }
			
			    }
			
			
			
			}