音乐系统权限
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();
}
}
}